Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
raowaqasakram
Contributor III
Contributor III
‎2022-09-07 05:23 AM

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

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?

Labels (2)
Labels
156 Views
0 Likes
3 Replies
Daniel044
Contributor II
Contributor II
‎2022-09-07 07:14 AM

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

 

156 Views
0 Likes
raowaqasakram
Contributor III
Contributor III
‎2022-09-07 07:18 AM
Author

In response to Daniel044

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

156 Views
0 Likes
Daniel044
Contributor II
Contributor II
‎2022-09-08 01:06 AM

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

156 Views
0 Likes