topic Re: Using multiple database schemas in MSSQL connection in Talend Studio

Using multiple database schemas in MSSQL connection

Anonymous — Thu, 27 Oct 2016 19:27:40 GMT

I have a single MSSQL database with multiple database schemas (note: different than Talend object schemas). In my connection I have the host, port, database, user name, password, etc set. I left the schema blank because when I use the Retrieve Schema (Talend schema) I can actually see the tables/objects across all schemas (my schemas are log, fin, ops, etc). So when I add a table as a tMSSqlOutput I'm getting a "table does not exist" because I haven't specified the database table schema. I can easily modify the built in property, but I don't want to do that because I may change the connection string later and don't want to have to change every job (thus, the purpose of the Repository!). So then I tried changing the name from "MyTable" to "ops.MyTable" and it still doesn't exist - I assume it's a syntax thing.

So the question is - how do I use multiple database schemas for MS SQL without using a built in connection for every one of them?

Thanks!

Re: Using multiple database schemas in MSSQL connection

Anonymous — Fri, 28 Oct 2016 03:58:11 GMT

Hi,
Could you please take a look at tContextLoad component which is used to modify dynamically the values of the active context?
Please refer to the related scenario in component reference:TalendHelpCenter:tContextLoad to see if it is what you are looking for.
Best regards
Sabrina

Re: Using multiple database schemas in MSSQL connection

Anonymous — Fri, 28 Oct 2016 04:13:43 GMT

Provide a user specific query and provide the table name in there in place of in the table text box.