Install the 64-bit HANA ODBC driver and use the 64-bit ODBC data source in the ODBC connection. Create an ODBC connection of the SAP HANA ODBC subtype. In the session, you must use a relational reader.
In the PowerCenter Workflow Manager, click
Tools
Task Developer
.
Click
Tasks
Create
.
Select
Session
as the task type to create.
Enter the session name and click
Create
.
The
Mappings
dialog box appears.
Select the required mapping and click
OK
.
Click
Done
in the
Create Task
dialog box.
In the workspace, double-click the session you created.
On the
Mappings
tab, select
Sources
in the Transformations pane on the left.
Select the source as
Relational Reader
.
To select the source connection name in the
Connections
pane, click
Edit
.
The
Connection Object Definition
page appears.
Enter the source connection name.
Enter the username and password.
In the
Connect String
field, specify the 64-bit ODBC data source.
You must install the 64-bit HANA ODBC driver to use the 64-bit ODBC data source.
Select the ODBC subtype as
SAP HANA
.
If you do not select the ODBC subtype as SAP HANA, the session fails.
The following image shows the ODBC subtype selected for the connection:
Click
OK
.
In the
Properties
pane for the source connection, specify the
Owner Name
as
_SYS_BIC
.
The following image shows the owner name for the source connection in the