Skip to main content

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.

 

Hi ​@bjorn 

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.

 


Hi ​@Thomas Lind 

 

Fantastic!  Thank you :-)

 

best regards,

Bjørn A.


Reply