Forum Discussion

yesh3350's avatar
yesh3350
Copper Contributor
May 23, 2023

All the tables in oracle are not loading into Azure SQL DB

Hello, in our org someone created these Pipeline which fetches source data from the Oracle ERP system and dump files to ADLS. After that, the pipeline processes files to Azure SQL Server. but only few tables are loading into Azure sql db. I have no idea what condition they put in pipeline or where.

 

when I tick untick table there I can see all the tables but not all pulling into azure sql db.

Can anyone help me on this problem how to get all tables into azure sql db.

  • ynguyenluat's avatar
    ynguyenluat
    Copper Contributor
    Jun 13, 2023
    In this kind of scenario, ADF developers usually use a parameter table or file for storing the desired tables. You should find a LookUp activity to fetch this list of tables before the copy activity in your pipeline (your dataset is parametrized). Have a look at the request in the setting of the lookup.

Resources