https://community.qlik.com/t5/Talend-Studio/Replacement-for-tOracleInput/m-p/2204365#M5283 <P>&nbsp;</P> <UL> <LI>What has happened here is the tOracleInput component (available in v6.5.1) has been replaced with tJDBCInput in v7.1.1 forward</LI> <LI>This framework (gets data from Relational DB sources to Hive) is still running in v6.5.1</LI> <LI>We have modified it to use tJDBCInput and our expectation is that it works in the same way</LI> <LI>Here’s an example of what is happening:</LI> </UL> <UL> <LI>In the Source (Oracle) the date is stored as <STRONG>2020-06-05 12:39:19.345123</STRONG></LI> <LI>The default output of the date column using tJDBCInput component is <STRONG>Fri Jun 05 12:39:19 SGT 2020</STRONG></LI> <LI>If we cast it to a date datatype (in tJDBCInput)<STRONG>, </STRONG>the output is <STRONG>2020-06-05 12:39:19.345</STRONG> (trimming it)</LI> <LI>If we cast it to a string datatype (in tJDBCInput), the output is <STRONG>2020-06-05 12:39:19.345123</STRONG> (expected result)</LI> </UL> <P>&nbsp;</P> <P>The challenge here is all applications using Talend, when they upgrade to v7.3, will have to do the above or similar changes if they want to see the same output they were seeing in v6.5.1 and that too only after casting a “Date” datatype to “String”.</P> <P>&nbsp;</P> <P>How do I get the same format (<STRONG>2020-06-05 12:39:19.345123</STRONG>) as the source in 7.3?</P> Sat, 16 Nov 2024 02:13:02 GMT Anonymous 2024-11-16T02:13:02Z https://community.qlik.com/t5/Talend-Studio/Replacement-for-tOracleInput/m-p/2204365#M5283 <P>&nbsp;</P> <UL> <LI>What has happened here is the tOracleInput component (available in v6.5.1) has been replaced with tJDBCInput in v7.1.1 forward</LI> <LI>This framework (gets data from Relational DB sources to Hive) is still running in v6.5.1</LI> <LI>We have modified it to use tJDBCInput and our expectation is that it works in the same way</LI> <LI>Here’s an example of what is happening:</LI> </UL> <UL> <LI>In the Source (Oracle) the date is stored as <STRONG>2020-06-05 12:39:19.345123</STRONG></LI> <LI>The default output of the date column using tJDBCInput component is <STRONG>Fri Jun 05 12:39:19 SGT 2020</STRONG></LI> <LI>If we cast it to a date datatype (in tJDBCInput)<STRONG>, </STRONG>the output is <STRONG>2020-06-05 12:39:19.345</STRONG> (trimming it)</LI> <LI>If we cast it to a string datatype (in tJDBCInput), the output is <STRONG>2020-06-05 12:39:19.345123</STRONG> (expected result)</LI> </UL> <P>&nbsp;</P> <P>The challenge here is all applications using Talend, when they upgrade to v7.3, will have to do the above or similar changes if they want to see the same output they were seeing in v6.5.1 and that too only after casting a “Date” datatype to “String”.</P> <P>&nbsp;</P> <P>How do I get the same format (<STRONG>2020-06-05 12:39:19.345123</STRONG>) as the source in 7.3?</P> Sat, 16 Nov 2024 02:13:02 GMT https://community.qlik.com/t5/Talend-Studio/Replacement-for-tOracleInput/m-p/2204365#M5283 Anonymous 2024-11-16T02:13:02Z