Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
faq:migration-toolkit:ddl-and-data [2019/06/12 19:16]
127.0.0.1 external edit
faq:migration-toolkit:ddl-and-data [2019/07/19 11:32] (current)
darya.prikhodkina
Line 1: Line 1:
 ====== How to Make Import Into SAP Hana Database ====== ====== How to Make Import Into SAP Hana Database ======
  
-While migrating DDL and Data into Sap Hana from other databases using the Ispirer Migration and Modernization Toolkit ​there are some specifics that you need to know+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. 
-So 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 a user hdbadm has read permissions on that directory. If the user doesn’t have read permissions,​ change permissions on directory where CSV and CTL file will reside+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
  
  
 ===== Options Setting ===== ===== Options Setting =====
  
-So in order to generate correct import scripts we need to set the following options in the tool:+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 folder, where all the control files and files with the data will be uploaded.+- "​**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.
  
 {{:​faq:​migration-toolkit/​hana_dir.png?​800|}} {{:​faq:​migration-toolkit/​hana_dir.png?​800|}}
Line 20: Line 20:
 ===== Running the Export And Uploading the Files ===== ===== Running the Export And Uploading the Files =====
  
-When all the options are set, we can run the conversion process ​and when the conversion process is finished we need to go to the "​Export"​ folder, clicking ​"View Export"​ button:+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:
  
 {{:​faq:​migration-toolkit/​view_export.png?​800|}} {{:​faq:​migration-toolkit/​view_export.png?​800|}}
  
-And 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**"​ optiondescribed 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 serverusing ftp client:+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:
  
 {{:​faq:​migration-toolkit/​hana_ftp.png?​800|}} {{:​faq:​migration-toolkit/​hana_ftp.png?​800|}}
Line 31: Line 31:
 ===== Running the Import Process ===== ===== Running the Import Process =====
  
-After copying all the files to the required ​place, we can initiate the import processby clicking the "Run Import"​ button on the "​Import"​ tab:+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:
  
 {{:​faq:​migration-toolkit/​imp_page.png?​800|}} {{:​faq:​migration-toolkit/​imp_page.png?​800|}}
  
-And our Migration and Modernization Toolkit ​will try to load all the definitions and data to the Sap Hana database.+And the tool will try to load all the definitions and data to Sap Hana database.