topic Re: Dynamic compatibility of jobs with different DBMS like MsSQL , MySQL , Postgres in Talend Studio

Dynamic compatibility of jobs with different DBMS like MsSQL , MySQL , Postgres

raowaqasakram — Fri, 15 Nov 2024 22:34:45 GMT

I have create a job in which I have used "tDBOutput - Microsoft SQL Server" to store the data into into MS-SQL DB.

I have providing the connection details (ip, port, username, password, db) etc from context variables.

Now my requirement is to provide connection details from context var and the job should automatically loads the data into target DB whether it would be MSSQL, MySQL or any other.

How to pass the DBMS type in context variables and the job should dynamically set the target DB based on this type?

Re: Dynamic compatibility of jobs with different DBMS like MsSQL , MySQL , Postgres

Daniel044 — Wed, 07 Sep 2022 11:14:44 GMT

I'm happy to see the issue is now solved. Thank you for updating us with the outcome.

Re: Dynamic compatibility of jobs with different DBMS like MsSQL , MySQL , Postgres

raowaqasakram — Wed, 07 Sep 2022 11:18:49 GMT

@James Furman dear , where the issue is resolved? Do you have any link to the article?

Re: Dynamic compatibility of jobs with different DBMS like MsSQL , MySQL , Postgres

Daniel044 — Thu, 08 Sep 2022 05:06:11 GMT

Yeah this is one of the most requested feature from the community but not sure when will the idea be implemented.