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
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
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.
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.
Are you sure it actually is a CData provider you use?
I can’t find a driver field.
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
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.