Ispirer Ispirer
 


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 performed.
INSTANCE_NUMBER This option sets the instance number of the server where import will be performed.
DATABASE This option sets the database name where import will be performed.
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 performed.
BIN This option sets the path to the native utility (hdbsql.exe) that will be used by SQLWays Wizard tool to perform 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 generating 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 generating the required namespace in CDS files when migrating tables to Sap Hana database.
COLUMN_STORE_TABLES This option allows converting tables from source database to COLUMN tables in Sap Hana.
Possible values - “Yes”, “No” or Empty. Default value - “No” or Empty.
APPLIANCE_DIR A path to the folder where CSV and CTL files will be moved after the conversion process should be specified in this option in order to load the definitions and data into Sap Hana database.
COMMAND_SEPARATOR A command separator that will be used in the generated sql files should be specified in this option. A user can specify its own separator.
Default value - ”#”.

Example:

[SAPHANA]
HOST=hostname
DATABASE=test
USER=postgres
PORT=4444
CHARACTER_SET=UTF8


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/sqlways-ini/saphana-section.txt · Last modified: October 05, 2018, 08:29:25 AM by darya.prikhodkina
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement