https://community.qlik.com/t5/Talend-Studio/How-to-create-a-complex-SQL-query-with-multiple-database/m-p/2296027#M68732 <P>Hi everyone,</P><P></P><P></P><P>I'm looking for a way to create complex SQL queries in Talend. </P><P>Those queries have to connect to multiple schemas in order to join a table from a schema to another table in another schema.</P><P></P><P></P><P>I know I can do that with Tmap, but the problem is that I have a huge amount of data, and complex WHERE conditions too, so if the Tmap try to operate them it'll be in Java code and the performances will be degraded way too much.</P><P></P><P></P><P>Though, as far as I understand, the component tOracleInput can use only one connection at a time, is that correct ? If that is, is there any alternatives ?</P><P></P><P></P><P>Regards,</P><P>Eva</P> Fri, 15 Nov 2024 23:02:07 GMT Eva_Hamel 2024-11-15T23:02:07Z https://community.qlik.com/t5/Talend-Studio/How-to-create-a-complex-SQL-query-with-multiple-database/m-p/2296027#M68732 <P>Hi everyone,</P><P></P><P></P><P>I'm looking for a way to create complex SQL queries in Talend. </P><P>Those queries have to connect to multiple schemas in order to join a table from a schema to another table in another schema.</P><P></P><P></P><P>I know I can do that with Tmap, but the problem is that I have a huge amount of data, and complex WHERE conditions too, so if the Tmap try to operate them it'll be in Java code and the performances will be degraded way too much.</P><P></P><P></P><P>Though, as far as I understand, the component tOracleInput can use only one connection at a time, is that correct ? If that is, is there any alternatives ?</P><P></P><P></P><P>Regards,</P><P>Eva</P> Fri, 15 Nov 2024 23:02:07 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-a-complex-SQL-query-with-multiple-database/m-p/2296027#M68732 Eva_Hamel 2024-11-15T23:02:07Z https://community.qlik.com/t5/Talend-Studio/How-to-create-a-complex-SQL-query-with-multiple-database/m-p/2296028#M68733 <P>Ideally, I would like a component able to create very complex SQL queries (with sub-request, group, joins etc...) with a graphical mode. Is such a component exist? Maybe a third component I could use?</P><P>Eva</P> Wed, 13 Apr 2022 15:47:37 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-a-complex-SQL-query-with-multiple-database/m-p/2296028#M68733 Eva_Hamel 2022-04-13T15:47:37Z https://community.qlik.com/t5/Talend-Studio/How-to-create-a-complex-SQL-query-with-multiple-database/m-p/2296029#M68734 <P>Did you ever get a solution?</P> Wed, 07 Jun 2023 20:32:18 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-a-complex-SQL-query-with-multiple-database/m-p/2296029#M68734 bob_lemley 2023-06-07T20:32:18Z