Sap Bods-Hana
Prerequisites
There are a number of steps that need to be taken before Data Services can connect to and extract data from an SAP Business Suite system. Please have a look at the Supplement for SAP for more details.
During the Data Services installation, you have the opportunity to select the features you wish to install. Please ensure that the "Data Services APS Services" are selected, otherwise the metadata import functionality in HANA Studio will not work properly (Data Services Metadata Service and Data Services Viewdata Service).
After the installation is complete, go to the Administrator section of the Data Services Management Console and open the Web Services node. Click on the Web Services Configuration tab and check the select checkbox for the IMPORT_REPO_OBJECT web service. Then select Disable Session Security from the drop-down listbox at the botttom and click on the Apply button. Once you've done this, the Session Security checkbox should be unchecked for this web service. This is mandatory for the metadata import functionality in HANA Studio to work properlly.
SAP HANA
From a Data Services perspective, SAP HANA isn't all that different from other databases. It communicates with it using HANA's ODBC driver (there is no native driver) and it uses mostly standard SQL. However, there are two topics that are specific to HANA and warrant some special focus so we'll have a look at them now.
Table Creation
Bulk Loading
Table Creation
Before Data Services Job Execution
During Data Services Job Execution
Before Data Services Job Execution
There are multiple ways of creating tables in HANA before execution of the Data Services Job, let’s see how.
New Table Editor
SQL Statement
Import
New Table Editor
1. Right-click on the Tables node, located under the schema where you wish to create the table, and click on New Table. 2. Enter a table name and create as many columns as you wish by defining the names, data types and other
There are a number of steps that need to be taken before Data Services can connect to and extract data from an SAP Business Suite system. Please have a look at the Supplement for SAP for more details.
During the Data Services installation, you have the opportunity to select the features you wish to install. Please ensure that the "Data Services APS Services" are selected, otherwise the metadata import functionality in HANA Studio will not work properly (Data Services Metadata Service and Data Services Viewdata Service).
After the installation is complete, go to the Administrator section of the Data Services Management Console and open the Web Services node. Click on the Web Services Configuration tab and check the select checkbox for the IMPORT_REPO_OBJECT web service. Then select Disable Session Security from the drop-down listbox at the botttom and click on the Apply button. Once you've done this, the Session Security checkbox should be unchecked for this web service. This is mandatory for the metadata import functionality in HANA Studio to work properlly.
SAP HANA
From a Data Services perspective, SAP HANA isn't all that different from other databases. It communicates with it using HANA's ODBC driver (there is no native driver) and it uses mostly standard SQL. However, there are two topics that are specific to HANA and warrant some special focus so we'll have a look at them now.
Table Creation
Bulk Loading
Table Creation
Before Data Services Job Execution
During Data Services Job Execution
Before Data Services Job Execution
There are multiple ways of creating tables in HANA before execution of the Data Services Job, let’s see how.
New Table Editor
SQL Statement
Import
New Table Editor
1. Right-click on the Tables node, located under the schema where you wish to create the table, and click on New Table. 2. Enter a table name and create as many columns as you wish by defining the names, data types and other