Extracting multiple tables from SQL server to SAP Data Servies

[former_member512864]

Hello guys,

I want to extract and load data from SQL Server to SAP HANA through SAP DATA SERVICES.

My source database contains more than 200 tables.

Is there a way to replicate multiple sources tables from SQL Server using SAP DATA SERVICES to multiple target tables ?

PS : I can aleardy transport one table a time through a job in dataservices

Thanks in advance for your help.

[Former Member · Accepted solution]

In one job with multiple data flows you can transport a lot of tables. If you don't execute transformations then you can use smart data access.

[former_member692398]

You can use SAP Data Service Workbench which can Replicate whole Source DB schema to Target DB Schema.

https://www.sap.com/documents/2016/11/446db4b5-947c-0010-82c7-eda71af511fa.html