Forum Discussion
yesh3350
May 23, 2023Copper Contributor
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 fe...
ynguyenluat
Jun 13, 2023Copper Contributor
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.