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

Copper Contributor

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.

1 Reply
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.