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 Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,703 questions
SQL Server | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,441 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 41,491 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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.