SAP HANA Data Warehouse

Introduction

SAP HANA is a modern, in-memory database and platform that is deployable on premise or in the cloud. It is a flexible data source-agnostic in-memory data platform that allows you to analyze large volumes of data in real time.

Read more about how to get started with SAP HANA here.

In case you wish to use this platform to host your data that you are aggregating using DataChannel, this document will show you how you can connect your SAP HANA based warehouse in minutes using the DataChannel Platform.

IMPORTANT

Please note that presently SAP HANA is only supported for the following connectors:

  • Sharepoint

  • SFTP

  • Netsuite Analytics

  • Amazon Seller Central

  • MSSQL

  • Google Sheets

Prerequisites for connecting your SAP HANA

  • You have access to an active SAP BTP account.

  • You have the privileges granted in the following SAP HANA XS user roles: sap.hana.xs.admin.roles::RuntimeConfAdministrator

  • Login to your SAP HANA to obtain the details required for DataChannel to access your SAP HANA.

To find your SAP HANA Details

You’ll be needing certain SAP HANA details when configuring your Data Warehouse at DataChannel:

  1. Open the SAP HANA cockpit as a user with DBADMIN privileges

    sap 1

  2. Go to: Services → Instance and Subscriptions.

    sap 2

  3. Setup Subscriptions. Select Create and add the following subscriptions.

    1. SAP HANA Cloud

    2. SAP Business Application Studio

  4. To set up a Database, you will first need to create a new Instance. Select Create Instance and choose SAP HANA Database as the instance type.

    sap 3

  5. Specify the Instance Name (without spaces), administrator password, description(optional) and desired database configuration.

    sap 4

  6. Review all the configured settings for the instance. Once completed, click on Create. Please note that all subscriptions and instances need to be created separately one by one.

  7. Click on created Instance for Database

    sap 5

  8. Click on View Dashboard

    sap 6

  9. You will be directed to SAP Hana Cloud Central. To find your host and port name in SAP HANA go to the All Instances page, click the …​ More icon.

    sap 7

  10. Then click on Copy SQL End Point. The host and port information for the specified instance is automatically saved to your clipboard.

    sap 8

  11. The connection string will have the format. Please refer the image below to find out the endpoint.

    sap 9

  12. Please refer the image below to find out the port.

    sap 10

  13. Please keep these handy as these will be needed at the time of setting up your Warehouse at DataChannel.

Step By Step Guide for Adding a new SAP HANA warehouse to your DataChannel Account

Step 1

Click on the Data Warehouses tab in the left side bar navigation to reach the Data Warehouses Module as shown below.

sap 11
Step 2

Click on Add New to add a new Data Warehouse to your account.

Step 3

Select SAP HANA from listed options and click on Add Warehouse Details.

sap 12
Step 4

Enter the details for your SAP HANA in the form and click on Validate Configuration.

sap 13
Step 5

Once the configuration is validated, the warehouse will be added.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.