topic Windows authentication MSSQL connection define in Talend Cloud in Talend Studio

Windows authentication MSSQL connection define in Talend Cloud

yome1 — Sat, 16 Nov 2024 05:00:58 GMT

Hello,

I have define a connection with windows authentication in my studio for an MSSQL database.

Login and Password parameters are set as empty. This is working fine. The jtds jar as been installed on my machine and the remote engine as well.

From the studio, i am able to run the job on the remote engine (using the target exec feature) and connect to my database.

Unfortunately when i define the connection in Talend Cloud and try to run the job on the remote engine from Management console i got this error :

tDBInput_1 (JobName)
java.sql.SQLException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed.

Seems like the connection is done correctly but the query is not understood?

Any ideas

Thank you.

Guillaume

Re: Windows authentication MSSQL connection define in Talend Cloud

Anonymous — Mon, 19 Aug 2019 09:22:01 GMT

Hello,

Are you able to configure DB connections in Talend Cloud? How did you switch the connection from cloud to Talend studio?

Let us know if this article helps

https://community.talend.com/t5/Design-and-Development/Talend-Cloud-Contextualization/ta-p/139077

Best regards

Sabrina

Re: Windows authentication MSSQL connection define in Talend Cloud

yome1 — Mon, 19 Aug 2019 14:28:42 GMT

Hello,

I just tried with a different query and i was able to make it works without changing the connection. I will troubleshoot and share if i can found something valuable to explain this.

Guillaume

Re: Windows authentication MSSQL connection define in Talend Cloud

yome1 — Mon, 19 Aug 2019 15:43:39 GMT

Hello,

Actually, i forgot to transmit the context to my subjob. As i was using the context reference with "context.database_table" into my request that is why i got the error.

Thank your for your help.

Guillaume