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.