How to Make Import Into SAP Hana Database

There are some specifics that should be considered when migrating DDL and Data into Sap Hana from other databases using Ispirer Migration and Modernization Toolkit. To be able to load data into Sap Hana database we need to have a folder on Sap Hana server where we will copy/upload the text files with the data and CTL files. If your Sap Hana database is running in the cloud, then you need to have a folder on cloud. Also please be sure that the hdbadm user has read permissions on this directory. If the user doesn’t have read permissions, please change the permissions on the directory where CSV and CTL file will be located.

In order to generate correct import scripts we need to set the following options in the tool:

- “Directory for CSV and CTL Files” - is a path to the folder, where all the control files and files with the data will be uploaded.

- “Bin directory” - is a path to the HDBSQL.exe utility that will be used to load the definitions and data into Sap Hana database.

When all the options are set, we can run the conversion process. When the conversion process is finished we need to go to the “Export” folder and click the “View Export” button:

In the opened folder we need to choose all the CSV and CTL files and copy/upload them to the place that we specified in the “Directory for CSV and CTL Files” option (described in the previous step). If your SAP Hana database is located on the cloud, then you need to copy these files on cloud. If your Hana database is located on the server, then you have to copy the files on the server using ftp client:

After copying all the files to the required location, we can initiate the import process by clicking the “Run Import” button on the “Import” tab:

And the tool will try to load all the definitions and data to Sap Hana database.

More about Ispirer Systems