Skip to main content
Solved

Unable to connect SAP to ODX Server (Cdata connector)

  • 28 June 2024
  • 5 replies
  • 32 views

Hello,

I have difficulties connecting to SAP Hana (2.00.067.01) database using ODX Server version 20.10.47.64.

I have a following connection string for the SAP connection: 

DRIVER={HDBODBC};UID=XXXXXX;PWD=XXXXXX;SERVERNODE=XX.XX.XX.XX:32215

Machine where ODX Server resides has available connection to SAP HANA (using IP and Port i am able to telnet it). When i try to input the data into data source connection info in TimeXtender (either manually or as connection string) I am getting following errors:

 

  • If the connector is SAP HANA 2022/23 the error is following:

 

  • If the connector is SAP HANA 2019/20/21 the error shows that i am not connected

 

Is this a connectivity issue or am i doing something wrong / missing something? Note that i am not using DRIVER={HDBODBC} in connection string and i am not specifying any database to connect to. The above connection string works in Azure Data Factory.

 

Thank you!

5 replies

Thomas Lind
Rank
Userlevel 6
Badge +5

Hi @gediminas.juskenas 

Is this the one you use?

You should always use the newest one, the older ones will not be fixed if they have an issue.

I checked the specific guide for this https://cdn.cdata.com/help/SNJ/ado/pg_connection.htm. I can’t see it mentioning that you need to state the options you mentioned.

Are you sure it actually is a CData provider you use?

I can’t find a driver field.

 

G
Rank

Hi Thomas, thanks for the prompt response. I have tried to use all the connectors from 2019 until 2023.

Driver parameter was required for Azure Data Factory, but since there is no option for that on ODX server, i am not using driver parameter at all. The only parameters i input are under “Authentication” section. The error with SAP HANA 2023 connector looks like this:

I get the same result if i remove Database value, enable/disable “Include System Objects” option. And if i change “Use SSL” to True it drops me instantly. Hence the question - if everything should look good here. Since if yes - then there is some sort of firewall issue, even though i can ping the HANA database

rory.smith
Rank
Userlevel 6
Badge +7

Hi @gediminas.juskenas ,

I have not used CData against SAP Hana (for ECC / ERP it is pretty bad from a performance perspective) but your SAP instance may be behind a SAP router (or the equivalent if HANA is different there). You should be able to install some kind of SAP application to connect from the ODX Server machine - that will tell you if the networking side is OK.

Thomas Lind
Rank
Userlevel 6
Badge +5

Hi @gediminas.juskenas 

It looks like it can’t locate the server, so I also think it is some firewall or location issue.

You mentioned using ADF, was that to connect to SAP HANA or something else?

If you have a ODBC SAP HANA provider you can install somewhere, it may also be a possibility of gaining access.

 

G
Rank

Hi, thanks for the reply, i will investigate with our network team and post findings here, maybe that will be relevant to somebody in the future

Reply


Terms and ConditionsCookie settings