Windows authentication MSSQL connection define in Talend Cloud

[yome1]

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

[Anonymous]

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

[yome1]

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

[yome1 · Accepted solution]

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