question

balanarasimhac-1495 avatar image
0 Votes"
balanarasimhac-1495 asked Zoehui-MSFT commented

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

Hi Team,

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


Thanks in advance

sql-server-generalsql-server-integration-services
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.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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

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.

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

Hi @balanarasimhac-1495,

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



· 1
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.

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·