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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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