This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
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?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 84%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUV%3C/text%3E%3C/svg%3E)
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.
Hi @Debbie Edwards ,
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.
Hi @Debbie Edwards ,
Just checking to see if the above info was helpful? If you have further query, do let us know.
Thanks
Hi @Debbie Edwards ,
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.