topic Re: tMSSqlOutput: Can you specify the database schema for the update table in Talend Studio

tMSSqlOutput: Can you specify the database schema for the update table

Anonymous — Thu, 25 Aug 2016 16:49:24 GMT

I don't see any way to specify the name of the database schema which the table to update stored in. Not all of my tables are in the default dbo schema.

UPDATE: A possible workaround is to create a synonym in the dbo schema to the desired table but I shouldn't have to make a database change just to accommodate the tool. And in many cases, this type of change isn't an option.

Re: tMSSqlOutput: Can you specify the database schema for the update table

Anonymous — Fri, 26 Aug 2016 03:48:12 GMT

Hi,
We see that you are using an existing connection from your screenshot.
Did you follow up document:TalendHelpCenter:Centralizing database metadata to set up DB connection and retrieve specified table schema?
Best regards
Sabrina

Re: tMSSqlOutput: Can you specify the database schema for the update table

Anonymous — Fri, 26 Aug 2016 17:31:43 GMT

You seem to be confusing the meanings of schema. What you're referring to is the expected structure of the data.

However, in many RDBMS's ( Oracle & MSSQL but not MySQL ), tables are organized in a hierarchy underneath a database schema. So I have a table named StepHistory which is located in the Job schema. So I reference it as job.StepHistory.

Some parts of this application are aware of this structure but it doesn't appear that MSSqlOutput is schema aware.

For example, this dialog get's it correct.

Re: tMSSqlOutput: Can you specify the database schema for the update table

Anonymous — Mon, 29 Aug 2016 08:31:16 GMT

Hi,
You can specify the name of the database schema on Database connection on repository.
Best regards
Sabrina

Re: tMSSqlOutput: Can you specify the database schema for the update table

Anonymous — Mon, 29 Aug 2016 15:02:43 GMT

It's not ideal since I need to create a new connection for every schema, but this method does work. Thank you.

Re: tMSSqlOutput: Can you specify the database schema for the update table

Anonymous — Tue, 30 Aug 2016 10:03:49 GMT

Hi,
Or you can connect your DB by using tmssqlXXX components directly(Built-in) without DB metadata.
Best regards
Sabrina