Skip to Content
0
Former Member
Aug 05, 2016 at 06:48 AM

SAP HANA connection via SSIS

539 Views

Hello SAP Expert,

I want to get data from SAP HANA and Move to Amazon Redshift via SSIS.

Steps Performed:

1. Created 32 bit ODBC connection to SAP HANA and it is successful on Windows 8 OS

2. Created 64 bit ODBC connection with Amazon Redshift and it is successful on Windows 8 OS

3. Downloaded and installed SSDT 2012 (SSIS)

4. Created SSIS package and trying to connect SAP HANA. Connection is tested successfully but no tables are showing off.

If we write SQL query then it prompt to change password of SAP HANA

Please find the attached screenshot for the same.

Thanks,

Rajiv Singh

Attachments

SAPIssue_3.PNG (31.3 kB)
SAPIssue_2.PNG (16.4 kB)
SAPIssue_1.PNG (32.4 kB)