Dbase DBF File to Azure SQL

Praveen kumar raju Chamarthi 6 Reputation points
2021-10-01T04:25:20.607+00:00

Problem Statement : Dbase .dbf files to be exported to Azure SQL using Azure Data Factory.

Looking for a solution : How we can export .dbf files to Azure SQL using ADF. Is there any connectors and transformations for storing the data from Dbase files to Azure SQL ?

Please provide solution for this.

We are not looking for DBF file to SQL server and from SQL Server to Azure SQL .
Direct Connection from DBF file to Azure SQL is what we are looking for .

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,307 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Saurabh Sharma 17,291 Reputation points Microsoft Employee
    2021-10-01T22:07:59.467+00:00

    Hi @Praveen kumar raju Chamarthi ,

    Thanks for using Microsoft Q&A !!
    Unfortunately, you cannot import .dbf file directly to Azure SQL. You can convert your .dbf file to CSV using Custom Activity to a Blob then you can try importing CSV from your Blob to your Azure SQL instance using Copy Activity in ADF.

    Please refer to Use custom activities in an Azure Data Factory on creating a custom activity.

    Thanks
    Saurabh

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.