Using multiple database schemas in MSSQL connection
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?
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
