Skip to main content
To homepage To homepage
Solved

Unable to connect SAP to ODX Server (Cdata connector)

G
Contributor

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!

Best answer by gediminas.juskenas

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

View original
Did this topic help you find an answer to your question?

5 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1031 replies
  • June 28, 2024

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
Contributor

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
TimeXtender Xpert
Forum|alt.badge.img+7
  • rory.smith
  • TimeXtender Xpert
  • 658 replies
  • July 1, 2024

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
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1031 replies
  • July 1, 2024

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
Contributor

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


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings