I have an OData URL with 200+ tables and I need to create all the tables in a SQL database and copy data daily to the SQL database.

An additional requirement is to be able to easily change the destination database (switching between dev, test, and prod).

I was instructed to use SSIS packages to accomplish this, but I don't think this is an optimal solution.

My thoughts were either using a python SDK for azure data factory, or a program I found online called skyvia.

Open to all solutions. Thanks in advance.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.