DataFactory: How can I trigger several Tables into MSSQL

• oniki11

  Valued Member

  Points: 62

  More actions

  June 23, 2023 at 8:51 am

  #4217425

  Hi everybody,

  I am learning Azure DF modeling.

  Currently we have connected a SAP System and I can already see the Tables I need.

  We have also connected a SQL DB and if I create a Pipeline I can copy the data of 1 SAP Table and use as SINK our MS SQL DB. When I run the pipeline, the table gets created.

  I have now ~20 SAP Tables and wondering how I can create 1 Pipeline which will automtically create those 20 Tables (structures) and copy the data.

  Thank you.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  June 24, 2023 at 9:10 am

  #4218216

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Emperor100

  SSCrazy

  Points: 2205

  More actions

  July 7, 2023 at 3:32 am

  #4228951

  Using ADF, you can create source, sink, and watermark datasets. You can pass a list of source table names as a parameter to the pipeline. The pipeline will then iterate through the list of source table names using a ForEach activity for Initial load(s).

  For performing delta loading for each table you can then create a second pipeline.

  =======================================================================

• July 27, 2023 at 4:13 pm

  This was removed by the editor as SPAM