ETL and Data Integration tools - Modern ETL software for everyone

Hello

I am loading data from oracle into MS Server.
There are multiple MS server databases.

How can I populate all of them with one data transformation script?

Love your product BTW.
Marc

Answer is obvious why do not connect to all your database and load all the data at the same time?

Mike

This will not work

We are pushing list of products to our shops together with prices

It does not take a lot of time to do that.

However there are more than 100 shops/sql server database.

Not all databases are available all the time and not all of the require updating.

We have a table with all conenction details to the servers required pushing new data.

Any other suggestions?

Marc

Good news it is possible.

You would need to use variables to achieve that

Have a look at the documentation related to variables.

Also check our tutorials and samples.


Mike