I'm trying to daily load a bunch of tables on Azure SQL DW using Azure Data Factory but I need some help converting DBF tables (to CSV would be nice) prior to loading them up. Can anyone indicate a good way to do this?
You can leverage the custom activity in ADF to covert the DBF files to CSV first. Here's the pointer on how to leverage the custom activity: https://azure.microsoft.com/en-us/documentation/articles/data-factory-use-custom-activities/ . After the CSV files are created use the copy activity in ADF to copy them to Azure SQL DW.