question

eva0307-4932 avatar image
0 Votes"
eva0307-4932 asked KranthiPakala-MSFT commented

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

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?

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @eva0307-4932 ,

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.

84982-image.png

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.



image.png (61.0 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @eva0307-4932 ,

Just checking in to see if the above suggestion was helpful. If this answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @eva0307-4932 ,

We still have not heard back from you. Just wanted to check if the above information was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·