4
Create an ODBC Data Source on UNIX
On UNIX, you set the ODBCHOME, ODBCINI, and shared library environment variables. You
also add data source entries to the odbc.ini file found in the system $ODBCHOME directory.
Set the environment variables as follows:
ODBCHOME
Set the variable to the ODBC installation directory. For example:
setenv ODBCHOME /export/home/qamercury/Informatica/9.5.1/ODBC7.0
ODBCINI
Set the variable to point to the directory that contains the odbc.ini file. For example:
setenv ODBCINI /export/home/qamercury/MBUGB_ODBCINI/9.5.1/odbc.ini
LD_LIBRARY_PATH, LIBPATH, or SHLIB_PATH
Set the shared library environment variable to the directory where the SAP HANA ODBC
driver is installed. For example:
setenv LD_LIBRARY_PATH
".:${PM_HOME}:${JAVA_HOME}/lib:${ORACLE_HOME}/lib:/usr/sap/hdbclient:"
After you set environment variables, add data source entries to the odbc.ini file found in the
system $ODBCHOME directory.
For SAP HANA, add the following entry to the odbc.ini file:
[SAP HANA source]
Driver=/usr/sap/hdbclient/libodbcHDB.so
DriverUnicodeType=1
ServerNode=<server_node>:<port>
Note: The operating system user that runs Informatica processes must have read and execute
permissions on the SAP HANA ODBC driver file.
Step 3. Create ODBC Connections in Informatica Clients
To configure a connection to an SAP HANA database, you must create ODBC connections in the
Informatica client tools that you use. Create an ODBC connection for each SAP HANA database
with which the client communicates.
Create a Relational ODBC Connection in PowerCenter
In PowerCenter, you use the Workflow Manager to create connections. For SAP HANA, create a
relational connection of subtype ODBC.
ODBC Connection Properties for SAP HANA
When you create a connection, you must configure connection properties.
The following table describes the connection properties:
Name you want to use for this connection. The connection name cannot contain
spaces or other special characters, except for the underscore.
Read-only. Type of database. For SAP HANA, this property should be set to ODBC.
Database user name with the appropriate read and write database permissions to
access the database.
To define the user name in the parameter file, enter session parameter $ParamName
as the user name, and define the value in the session or workflow parameter file. The
Integration Service interprets user names that start with $Param as session
parameters.
(124 pages)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels