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