5
Use Parameter in Password
Indicates that the password for the database user name is a session parameter,
$ParamName. Define the password in the workflow or session parameter file, and
encrypt it by using the pmpasswd CRYPT_DATA option. Default is disabled.
Password for the database user name. Must be in 7-bit ASCII.
Connect string used to communicate with the SAP HANA database.
Code page the Integration Service uses to read from a source database or write to a
target database or file.
Connection Environment SQL
Runs an SQL command with each database connection. Default is disabled.
Transaction Environment SQL
Runs an SQL command before the initiation of each transaction. Default is disabled.
Number of seconds the Integration Service attempts to reconnect to the database if
the connection fails. If the Integration Service cannot connect to the database in the
retry period, the session fails. Default value is 0.
Creating an ODBC Connection in the Workflow Manager
When you create a connection object, choose the connection type in the Connection Browser.
ODBC connections have connection subtypes. For SAP HANA, create a relational connection
with subtype ODBC.
1. Click Connections > Relational.
2. Click New.
3. Select a subtype of ODBC.
4. Click OK.
5. Configure the connection properties.
6. Click OK.
Create an ODBC Connection in the Administrator Tool, Analyst
Tool, or Developer Tool
Use the Administrator tool, Analyst tool, or Developer tool to create an ODBC connection to an
SAP HANA database. The method that you use to create the connection varies based on the tool.
ODBC Connection Properties for SAP HANA
When you create a connection, you must configure connection properties.
The following table describes the connection properties:
User name for the SAP HANA database.
Password for the user name.
Connection string to connect to the database.
Optional. Enter SQL commands to set the database environment when you connect to
the database. The Data Integration Service executes the connection environment
SQL each time it connects to the database.
Optional. Enter SQL commands to set the database environment when you connect to
the database. The Data Integration Service executes the transaction environment
SQL at the beginning of each transaction.
This property is reserved for future use.
(124 páginas)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais