Im trying to export data from a DAT file and I am wondering if its possible, I cant find any documentation about this anywhere?
Im trying to export data from a DAT file and I am wondering if its possible, I cant find any documentation about this anywhere?
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
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.
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?
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.
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.
Just checking to see if the above info was helpful? If you have further query, do let us know.
Thanks
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.
4 people are following this question.