Hi ,
I am trying to connect to HANA database through data stage. I have installed hana client in my AIX sever . I have added the following in .odbc.in file .
[HANA]
Driver=/usr/sap/hdbclient/libodbcHDB.so
DriverUnicodeType=1
Description=Hana Conntion Test
HostName=19.51.189.12
LogonID=USERNAME
Password=PASS
PortNumber=30015
LoginTimeout=-1
QueryTimeout=-1
ConnectionRetryCount=3
Update the uvodbc.config
<HANA>
DBMSTYPE = ODBC
Connectivity TEST
./bin/dss
DataStage Command Language 9.1 Licensed Materials - Property of IBM
(c) Copyright IBM Corp. 1997, 2012 All Rights Reserved.
DSEngine logged on: Thursday, January 15, 2015 10:27
>LOGTO dstage1
>DS_CONNECT HANA
Enter username for connecting to 'HANA' DBMS [dsadm]: USERNAME
Enter password for USERNAME:PASS
SQLConnect error: Status = -1 SQLState = 08S01 Natcode = -10709
[ODBC] [SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;-10709 Connection failed (RTE:[89006] System call 'connect' failed, rc=79:Connection refused)
Can you guys help . What is the issue i am having ?
Thank in advance
Connect to HANA database through data stage?
Moderators: chulett, rschirm, roy
You mentioned you had installed a Hana client on your AIX server. Have you tried connecting from the AIX command line, via that client, with the same ID and password, with success? The ODBC error you got looks pretty generic, so it could be caused by any number of things.
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA