User Profile
Santhi1982
Copper Contributor
Joined Oct 25, 2023
User Widgets
Recent Discussions
Sharepoint Connector ADF
Hi, I am analyzing sharepoint connector which is used in ADF. I would like to know the limitations of using sharepoint connector in ADF in terms of Authentication type supported Specific connection configuration needed Copy a whole folder or multiple files from sharepoint the size of the file which can be downloaded Security/firewall issues Any other limitations or issues that we can expect218Views0likes0CommentsADF - Deployment Process
Hi, I want to know deployment strategies for ADF. Its single developer, currently working on ADF feature branch, integrated with azure devops repos. How do we push changes to main branch? Is there automated way to pull changes from feature branch to main? We are working in agile methodology. We will have different env for dev, prod. What is the best way to develop and deploy? Can we choose specific components for deployment?516Views0likes1CommentADF - Dynamically load all excel files from blog storage to Azure SQL DB
Hi, I have some 10+ excel files in azure storage container. I want to load these files dynamically. For each of these files , the sheetname is going to be different. I can maintain sheetname details in a separate azure sql table 'ExcelDetails'. How do I read all files dynamically and match with table data to fetch sheetname, and load the data into sql. Also I want to control the pipeline runs, maintain activity runs in a table 'etlControlTable' and run pipelines activities only for 'non processed files'. I am not sure how to go about this. Waht all activities and the flow in pipeline? Please guide me.426Views0likes0Comments
Recent Blog Articles
No content to show