I am looking for a best programmatic way to extract data from Azure Data Lake to MSSQL database, which is installed on a VM within Azure.
Currently I am considering following options:
- Azure Data Factory
- SSIS (Using Azure Data Lake Store Connection Manager)
- User-Defined Outputter Example1, Example2
- Custom C# code that reads Azure Data Lake data and inserts it into SQL Server DB
Any other good ways I am missing?