ADF connection with onPrem SAP HANA- getting the error- ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Question

Hi Team,

While connecting to source (on prem) SAP HANA, I am seeing the error- ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified .

Only username, password and hostname is provided, gateway is not yet created. is there anything else except gateway to be created for testing connectivity?

Answer 1

Hi @Eva Baishya ,

Thanks for reaching out.

As mentioned in the public documentation prerequisites section, in order to use SAP HANA Connector you need to:

1. Set up a Self-hosted Integration Runtime. See Self-hosted Integration Runtime article for details.
2. Install the SAP HANA ODBC driver on the Integration Runtime machine. You can download the SAP HANA ODBC driver from the SAP Software Download Center. Search with the keyword SAP HANA CLIENT for Windows.

Please also refer to the linked service properties section of the doc which has info about the required/mandatory fields to establish the connection.

Please note that specifically, this SAP HANA connector supports:

• Copying data from any version of SAP HANA database.
• Copying data from HANA information models (such as Analytic and Calculation views) and Row/Column tables.
• Copying data using Basic or Windows authentication.
• Parallel copying from a SAP HANA source. See the Parallel copy from SAP HANA section for details.

Hope this helps. Do let us know if you have further query.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.