Hi,
I got a data source with multiple databases(22) with equal tables, views, etc.
TX ver 20.10 I was able to add databases in the "Additional Connections" for the “SQL Server data source”.
How about the new TX version.. can I do the same? It would save me a lot of work when selecting tables and setting up incr load rules
regards,
Bjørn A.
Best answer by Thomas Lind
Hi
You can clone a data source in the portal and in the program itself.
In the portal.
In the program.
When you clone a data source in the program you will copy the incremental settings and so.
You can point at the other version by clicking change and pointing at the cloned data source of the portal.
Once you have done this for all 22 data sources you can use the Mapping Set feature to merge all of them together as one.
+5Hi
You can clone a data source in the portal and in the program itself.
In the portal.
In the program.
When you clone a data source in the program you will copy the incremental settings and so.
You can point at the other version by clicking change and pointing at the cloned data source of the portal.
Once you have done this for all 22 data sources you can use the Mapping Set feature to merge all of them together as one.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
