There are a manner or component to Migrate Multiple Database on Multiple Servers to Consolidate the data in one Concentration Database on SQL Server ?
If not There are a form to execute TRANSACT SQL code to call Stored Procedures to make this kind of automation.
Thanks In Advance.
Please have a look at talend t<DB>Row component in order to execute the stated SQL query on your specified database.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.