3
read source data from SAP HANA when you run a session. The Integration Services use
ODBC to communicate with SAP HANA databases.
To configure connections to SAP HANA, complete the following tasks:
1. Install the SAP HANA ODBC driver.
2. Create ODBC data sources.
3. Create ODBC connections in the Informatica client tools.
After you create ODBC connections in the client tools, you can create objects that represent SAP
HANA data structures such as tables and views.
Step 1. Install the SAP HANA ODBC Driver
SAP HANA ODBC drivers are packaged with the SAP HANA client software. Install the client
software for the SAP HANA database system. The client software includes the drivers needed to
connect to the database. Install the SAP HANA database client, version 1.00.49 or later.
Download the SAP HANA client software from the SAP Software Download Center. You must
have an account with SAP to download the software.
In the United States, you can download the SAP HANA client from the following site:
https://hanadeveditionsapicl.hana.ondemand.com/hanadevedition/
Install the SAP HANA client software on the following machines:
Servers where the PowerCenter Integration Service or the Data Integration Service run.
Machines where Informatica client software is installed.
Step 2. Create ODBC Data Sources
After you install the necessary components, you must create an ODBC data source for each SAP
HANA database to which you want to connect.
A data source contains connection credentials that you need to locate and access the database,
such as database name, user name, and database password.
Create ODBC data sources on the following machines:
Servers where the PowerCenter Integration Service or the Data Integration Service run.
Machines where Informatica client software is installed.
When you create an ODBC data source, you must also specify the driver to which the ODBC
driver manager sends database calls. The ODBC driver varies based on the operating system
platform.
The following table lists the SAP HANA ODBC driver for different platforms:
libodbcHDB
The file extension varies based on the UNIX platform.
Create an ODBC Data Source on Windows
On Windows, you use the ODBC Data Source Administrator to create an ODBC data source.
1. Select Start > Administrative Tools > Data Source (ODBC).
2. Click the System DSN tab.
3. Create an ODBC data source with driver HDBODBC for 64-bit Windows or driver
HDBCODBC32 for 32-bit Windows.
(124 pages)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels