I'm facing a new issue : i'm trying to import my own data to the HANA on AWS : so i've installed data services, patched to SP2 patch 4, and now trying to add HANA as a datastore in Data services.
Unfortunatly i can't manage to give the right settings : i'm facing an error : ODBC-Error
My procedure : New Datastore => Database type : HANA => ODBC Administration => So here i'm guessing i should add user or system data source , either way, the next steps are the same => Add => Select HDBODBC driver => then i'm asked about informations but i can't get it right :
Data Source Name : HDB ? imdbhdb ? some Amazon information ( AMI-id ? SAP HANA Developer Edition ? instance name ?) ? some setting to do in Hana studio ?
Description : no problem
Server:Port : Should i enter the elasticip:30x15 ? ec2-2x-xx-xxx-xxx.compute-x.amazonaws.com ? enter the private ip ?
Then i'm prompted for a username // password : which should i use : hdbadm ? root ? SYSTEM ?
( with the unselected option for ssh )
The error message is the following :
SAP HDB ODBC Connect
SQLSTATE : 08S01
NATIVE ERROR : -10709
MESSAGE TEXT : [SAP AG][LIBODBCHDB DDL][HDB]
Communication link failure;-10709 Connection failed (RTE:
System call 'connect' failed, rc=10060 : a connection attempt
If you managed to connect dataservices on HANA AWS please tell me !
Thanks a lot if you can help !