SAP HANA connection via SSIS

[Former Member]

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

[Former Member]

Hello SAP team,

Now we have created new user id and password and I am able to see SAP tables and view its data in SSIS preview.

But when I run my package it fails saying unable to establish ODBC connection.

Steps I performed to resolve this issue:

1. Tried created 32 and 64 bit SAP ODBC connection but no success.

2. Open SSIS as an administrator but still no success.

3. Ran package in 32 bit but still no success.

@SAP Team:

Can you help me apart from read access, do I need to provide any other access to have ODBC connection on SAP HANA.

Please check the screenshot to understand the issue better.

[Former Member]

I got the solution.

Issue was credential was flushing at runtime.

So create dynamic connection using Expression property.