Skip to Content

Data Services copying multiple tables easily

Hi I have about 30 tables to copy from one db to another..

I can create manually a flow for each...but is there a way to

a) generate Multiple flows automatically

b) or parametise the a flow's source and destination table to run from a list of tables..

Ideally I want to select multiple tables and then select the destination and it does the rest..


Thanks mike

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jun 07, 2017 at 11:36 AM

    Use DS Workbench.

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks yes it works .. the missing link .. in DS tookkit ..copy multiple table without having to hand create each table flow!

      So for those who don't know in windows Start button -> Data Services 4.2 -> DS workbench

  • Jun 07, 2017 at 04:40 AM

    USE DS Workbench - . Windows -> START -> SAP dataservices 4.2 -> DS workbench -> replication wizard

    If you don't have DS work bench this try the below..

    Alternative..

    IN DS designer - For small number of tables up to 30.. A data service flow allows multiple source AND MULTIPLE DESTINATION in one flow. This method you only have to do one data flow per 20 tables And no typing just drag and drop.

    Method...

    1) in a data flow, you can drag and drop to the flow canvas multiple sources at once. You can do about 20-30 without running out of canvas

    2) If possible create the source tables in the destination db ( using plain old sql - if you can confidently generate compatible tables and column types) . If not you will have to manually create a template table destinataion for each source DS.

    2a) Import these table defs into the DEST data source

    3) for each DEST table drag it from the dest data source 'tables' list to the canvas and connect it to the source. You must do this one by one. .If you do not have the dest tables - you will have to create template tables for each.Also note, you do not need a query in between just connect the source to the dest ,

    4) The run the flows ( each flow can do about 20 - 30 ) tables.

    5) Not sure if you rerun the flow it will append another copy of the data, if so you might need to delete the data from the DEST tables (etc ) using SQL etc..

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 07, 2017 at 01:26 PM

    Hi Mic,

    You can take a dataflow, drag and drop all 30 tables in workarea make them source, and take 30 temp tables(or if tables already created in target database export them and drag and drop to work area, make them target ) and connect the source to target directly and run the job.

    Above step is assuming that you want to directly dump the data with one to one mapping and no transformation needed.

    If you there is any transformation required use query transform on for each source table and then connect the same to target table and done.

    Let me know, if I'm missing something here.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 08, 2017 at 04:32 AM

    Thanks

    Gokul Gawande I worked that out see my post above..Seems strange that services can't do or can do alot of tables ..?

    Dirk Venken DS Workbench - YES IT WORKS.. THANKs - a way to copy many tables. For those who don't know . Windows -> START -> SAP dataservices 4.2 -> DS workbench -> replication wizard

    Add comment
    10|10000 characters needed characters exceeded