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

Bala Narasimha Challa 466 Reputation points

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

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

    0 comments No comments

  2. ZoeHui-MSFT 34,591 Reputation points

    Hi @Bala Narasimha Challa ,

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

    Reference: Connect to SAP HANA via ODBC



    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