question

DebbieEdwards-1726 avatar image
0 Votes"
DebbieEdwards-1726 asked UdhayasankariVelumani-3454 edited

Can you import a DAT File using Data Factory (Into a SQL database)?

Im trying to export data from a DAT file and I am wondering if its possible, I cant find any documentation about this anywhere?

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.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered VaibhavChaudhari edited

No, I don't think so. Below document doesn't show DAT file format in the list.

supported-file-formats-and-compression-codecs



===============================================
If the response helped, do "Accept Answer" and upvote it -- Vaibhav

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.

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered UdhayasankariVelumani-3454 edited

Hi @DebbieEdwards-1726,


Welcome to Microsoft Q&A platform and thanks for your query. As pointed out by Vaibhav, DAT file format is currently not supported in ADF.


But, feel free to leave a feedback in ADF user voice forum and please do share the feedback link here once it is created, as it would help other users to up-vote and/or comment on your feature request suggestion.


ADF user voice forum: https://feedback.azure.com/forums/270578-azure-data-factory





Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.


· 2
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.

I have created some feedback for this but the request is quite urgent. Is there anything you can do in the way of a custom connector. Or failing this and I cant use Data Factory, is there another solution I could use?

0 Votes 0 ·

If your dat file will be in blob storage, first create linked service for blob storage and then choose CSV file format in the data set, then provide the delimiter as ~ symbol. After that You can choose Header as first row in the check box.

Then try to open the preview data view, you can able to get the data.


Enjoy.

0 Votes 0 ·
KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @DebbieEdwards-1726,

Thanks for your response. Unfortunately I don't see other options except using custom activity and writing your own logic to achieve your requirement in ADF. To move data to/from a data store that Data Factory does not support, or to transform/process data in a way that isn't supported by Data Factory, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline.

Please refer to this doc to explore about custom activity in ADF: Use custom activities in an Azure Data Factory pipeline

I see that you have already shared a feature request feedback in user voice forum. I am sharing it here, as other user users with similar idea can up-vote and/or comment on your suggestion as well as to increase the priority of the feature request.

Feedback link: https://feedback.azure.com/forums/270578-data-factory/suggestions/41060782-create-a-new-linked-service-connector-for-dat-file

Hope this info helps.



Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.


· 2
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 @DebbieEdwards-1726,

Just checking to see if the above info was helpful? If you have further query, do let us know.

Thanks

0 Votes 0 ·

Hi @DebbieEdwards-1726,

Following up to see if the above info was helpful. Do let us know if you have any further query.



Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.

0 Votes 0 ·