Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
attunsup_microsoft
Partner - Contributor
Partner - Contributor

SSIS packages containing Oracle source/ destination are failing.

+From the past 2 days Customer's SSIS packages are failing to connect to oracle database.

++ We performed a UDL test using oracle provider for oledb using 32-bit and 64-bit which was successful.

++ When Cx is trying to connect using attunity, they are getting below error.

attunsup_microsoft_0-1705499824905.jpeg

 

++Asked Cx to reinstall attunity 4.0 drivers.

++Upon installing attunity 4.0 drivers, creates a new SSIS package and changed the target server version to SQL Server 2016 and found that the oracle source and destination components are not visible in SSIS toolbox.

++So, asked Cx to install attunity 5.0 drivers as well. Then, we were able to see the oracle components in toolbox.

++ Tried to connect to oracle database and again Cx got the same error.

++ Cx is trying to connect to oracle 19c.

++ In Microsoft webpage we found that attunity 4.0 supports  oracle 10.x, 11.x,12c

attunsup_microsoft_1-1705499824908.jpeg

 

++ Need to know whether attunity 4.0 supports oracle 19c or not.

Labels (2)
0 Replies