This is an old revision of the document!
Ispirer Home Page
Ispirer SQLWays Product Page
Request SQLWays
Sqlways.ini File - Section [SAPHANA]
This article describes sqlways.ini file [SAPHANA] section and options it contains.
Option name | Description |
---|---|
HOST | This option sets the host name where import will be done. |
DATABASE | This option sets the database name where import will be done. |
USER | This option sets user account that will be used to connect to Sap Hana database. |
PWD | This option sets password that will be used together with the user account to connect to Sap Hana database. |
PORT | This option sets port number that will be used to connect to Sap Hana database. |
TARGET_VERSION | This option sets the version number of the database where import will be done. |
BIN | This option sets the path to the native utility (hdbsql.exe) that will be used by SQLWays Wizard tool to make an import into the Sap Hana database. |
CHARACTER_SET | This option defines the encoding that will be used to store the extracted data in the files in export folder. |
GENERATE_CDS | This option allows to generate CDS files with extension .hdbschema when migrating tables to Sap Hana database. Possible values - “Yes”, “No” or Empty. Default value - “No” or Empty. |
CDS_NAMESPACE | This option allows to generate the required namespace in CDS files when migrating tables to Sap Hana database. |
COLUMN_STORE_TABLES | This option allows to convert tables from source database to COLUMN tables in Sap Hana. Possible values - “Yes”, “No” or Empty. Default value - “No” or Empty. |
APPLIANCE_DIR | In this option should be specified a path to the folder where CSV and CTL files will be moved after the conversion process in order to load the definitions and data into Sap Hana database. |
Example:
[SAPHANA] HOST=hostname DATABASE=test USER=postgres PORT=4444 CHARACTER_SET=UTF8
Ispirer Home Page
Ispirer SQLWays Product Page
Request SQLWays