Skip to Content
avatar image
Former Member

SSIS Source Connection + Linked Server + ODBC Connection to Connect SAP HANA System

Apr 17, 2018 at 12:46 PM | 101 Views

Hello Friends,

I want to get the data from sap hana system.

We have some MSSQL server SSIS packages.right now they using flat file source connection manager to get the data from files.

Now we want direct connection to connect sap system and get the data .

Can you please let me know what are the minimum settings and drivers i need to install in my VM.

I have installed all sap hana driver 64bit in my vm where i have sql server installed.

Please let me know if you need more input from me.

Microsoft SQL Server | SAP HANA
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Cherry Tian
    May 22, 2018 at 03:10 AM

    Hi, Sandeep

    Is the SAP Hana system you mean, the S/4 HANA or NW based system on HANA database?
    The minimum setting to connect a remote SQL Server from SAP application server,

    1, Install a ODBC driver on client side.

    2, Install a DBSL on client side. (If you are on NW based system)

    3, have a definition about the connection string on DBCO (If you are on NW based system)

    The client side host server should be either Windows or Linux. Please refer to the following note.

    1601608 - How to access an external Microsoft SQL Server database

    Best regards,

    Cherry

    Add comment
    10|10000 characters needed characters exceeded