How to extract data from SAP Hana to SQL server using SSIS

Bala Narasimha Challa 466 Reputation points
2021-09-16T08:35:54.82+00:00

Hi Team,

How to get data from SAP Hana to SQL server using SSIS

Thanks in advance

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,139 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,496 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,581 Reputation points
    2021-09-16T08:43:51.837+00:00

    With SSIS you can utilize any OleDB or ODBC data provider, so install ODBC for SAP HANA to access it with SSIS.

    https://help.sap.com/viewer/e9146b36040844d0b1f309bc8c1ba6ab/3.2/en-US/734759c0c1c9440c857da0d366e47dda.html

    0 comments No comments

  2. ZoeHui-MSFT 34,591 Reputation points
    2021-09-17T02:58:17.973+00:00

    Hi @Bala Narasimha Challa ,

    As Olaf said that you may connect to SAP HANA via ODBC.

    Reference: Connect to SAP HANA via ODBC

    Regards´╝î

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October