https://community.qlik.com/t5/Data-Movement-Streaming/SSIS-packages-containing-Oracle-source-destination-are-failing/m-p/2162447#M1743 <P>+From the past 2 days Customer's SSIS packages are failing to connect to oracle database.</P> <P>++ We performed a UDL test using oracle provider for oledb using 32-bit and 64-bit which was successful.</P> <P>++ When Cx is trying to connect using attunity, they are getting below error.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="attunsup_microsoft_0-1705499824905.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/127223iEF7CD5BA1E46430B/image-size/medium?v=v2&amp;px=400" role="button" title="attunsup_microsoft_0-1705499824905.jpeg" alt="attunsup_microsoft_0-1705499824905.jpeg" /></span></P> <P>&nbsp;</P> <P>++Asked Cx to reinstall attunity 4.0 drivers.</P> <P>++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.</P> <P>++So, asked Cx to install attunity 5.0 drivers as well. Then, we were able to see the oracle components in toolbox.</P> <P>++ Tried to connect to oracle database and again Cx got the same error.</P> <P>++ Cx is trying to connect to oracle 19c.</P> <P>++ In Microsoft webpage we found that attunity 4.0 supports &nbsp;oracle 10.x, 11.x,12c</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="attunsup_microsoft_1-1705499824908.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/127222iCE766A2D9F4998CB/image-size/medium?v=v2&amp;px=400" role="button" title="attunsup_microsoft_1-1705499824908.jpeg" alt="attunsup_microsoft_1-1705499824908.jpeg" /></span></P> <P>&nbsp;</P> <P>++ Need to know whether attunity 4.0 supports oracle 19c or not.</P> <P><LI-WRAPPER></LI-WRAPPER></P> Wed, 19 Mar 2025 22:43:16 GMT attunsup_microsoft 2025-03-19T22:43:16Z https://community.qlik.com/t5/Data-Movement-Streaming/SSIS-packages-containing-Oracle-source-destination-are-failing/m-p/2162447#M1743 <P>+From the past 2 days Customer's SSIS packages are failing to connect to oracle database.</P> <P>++ We performed a UDL test using oracle provider for oledb using 32-bit and 64-bit which was successful.</P> <P>++ When Cx is trying to connect using attunity, they are getting below error.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="attunsup_microsoft_0-1705499824905.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/127223iEF7CD5BA1E46430B/image-size/medium?v=v2&amp;px=400" role="button" title="attunsup_microsoft_0-1705499824905.jpeg" alt="attunsup_microsoft_0-1705499824905.jpeg" /></span></P> <P>&nbsp;</P> <P>++Asked Cx to reinstall attunity 4.0 drivers.</P> <P>++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.</P> <P>++So, asked Cx to install attunity 5.0 drivers as well. Then, we were able to see the oracle components in toolbox.</P> <P>++ Tried to connect to oracle database and again Cx got the same error.</P> <P>++ Cx is trying to connect to oracle 19c.</P> <P>++ In Microsoft webpage we found that attunity 4.0 supports &nbsp;oracle 10.x, 11.x,12c</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="attunsup_microsoft_1-1705499824908.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/127222iCE766A2D9F4998CB/image-size/medium?v=v2&amp;px=400" role="button" title="attunsup_microsoft_1-1705499824908.jpeg" alt="attunsup_microsoft_1-1705499824908.jpeg" /></span></P> <P>&nbsp;</P> <P>++ Need to know whether attunity 4.0 supports oracle 19c or not.</P> <P><LI-WRAPPER></LI-WRAPPER></P> Wed, 19 Mar 2025 22:43:16 GMT https://community.qlik.com/t5/Data-Movement-Streaming/SSIS-packages-containing-Oracle-source-destination-are-failing/m-p/2162447#M1743 attunsup_microsoft 2025-03-19T22:43:16Z