Post reply

DataFactory: How can I trigger several Tables into MSSQL

  • 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.

  • 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.

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply