Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
sqlways:command-line:sqlways-ini:saphana-section [July 12, 2018, 01:49:29 PM] – alexandr.kirpichny | sqlways:command-line:sqlways-ini:saphana-section [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
\\ | \\ | ||
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
====== Sqlways.ini File - Section [SAPHANA] ====== | ====== Sqlways.ini File - Section [SAPHANA] ====== | ||
This article describes sqlways.ini file [SAPHANA] section and options it contains. | This article describes sqlways.ini file [SAPHANA] section and options it contains. | ||
^ Option name ^ Description | ^ Option name ^ Description | ||
- | | **HOST** | This option sets the host name where import will be done. | | + | | **HOST** | This option sets the host name where import will be performed. | |
- | | **DATABASE** | This option sets the database name where import will be done. | | + | | **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. | | **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. | | **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. | | **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. | | + | | **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 make an import into the Sap Hana database. | | + | | **BIN** | This option sets the path to the native utility (hdbsql.exe) that will be used by SQLWays Wizard tool to perform |
| **CHARACTER_SET** | This option defines the encoding that will be used to store the extracted data in the files in export folder. | | | **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 | + | | **GENERATE_CDS** | This option allows |
- | | **CDS_NAMESPACE** | This option allows | + | | **CDS_NAMESPACE** | This option allows |
- | | **COLUMN_STORE_TABLES** | This option allows | + | | **COLUMN_STORE_TABLES** | This option allows |
- | | **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. | | + | | **APPLIANCE_DIR** | A path to the folder where CSV and CTL files will be moved after the conversion process |
- | | **COMMAND_SEPARATOR** | In this option should be specified a command separator that will be used in the generated sql files. | + | | **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 - "#" |
Line 31: | Line 32: | ||
CHARACTER_SET=UTF8 | CHARACTER_SET=UTF8 | ||
- | \\ | + | |
- | [[http:// | + | |
- | [[http:// | + | |
- | [[http:// | + |