question

PraveenkumarrajuChamarthi-1992 avatar image
0 Votes"
PraveenkumarrajuChamarthi-1992 asked SaurabhSharma-msft commented

Dbase DBF File to Azure SQL

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered SaurabhSharma-msft commented

Hi @praveenkumarrajuchamarthi-1992,

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.


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @praveenkumarrajuchamarthi-1992,
Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Thanks
Saurabh

0 Votes 0 ·

Hi Saurabh,

Thanks for your input for the question posted.
Still we are exploring the solution provided by you.
As per document provided by Dbase where python version 3.2 or 2.7 will be supported for dbf libraries.
Latest version of python not supporting dbf libraries . Hence still exploring whether to use Azure Batch or Azure Databricks.

I WIll keep posted once finding the solution.

Thanks and Regards
Praveen

1 Vote 1 ·
SaurabhSharma-msft avatar image SaurabhSharma-msft PraveenkumarrajuChamarthi-1992 ·

Hi @praveenkumarrajuchamarthi-1992,

Sure. Please let us know in case you have any questions.

Thanks
Saurabh

0 Votes 0 ·