# Hi, I am doing basis ETL in Matillion. I am looking to extract data from oracle and write to a file. I am using database query to unload , but I don't see any option to write to file .. is there any connectors . Any guidance will be great help

**URL:** <https://matillioncommunity.discourse.group/t/hi-i-am-doing-basis-etl-in-matillion-i-am-looking-to-extract-data-from-oracle-and-write-to-a-file-i-am-using-database-query-to-unload-but-i-dont-see-any-option-to-write-to-file-is-there-any-connectors-any-guidance-will-be-great-help/1977>\
**Category:** Matillion ETL\
**Created:** [November 14, 2022, 4:37pm UTC](https://matillioncommunity.discourse.group/t/hi-i-am-doing-basis-etl-in-matillion-i-am-looking-to-extract-data-from-oracle-and-write-to-a-file-i-am-using-database-query-to-unload-but-i-dont-see-any-option-to-write-to-file-is-there-any-connectors-any-guidance-will-be-great-help/1977 "2022-11-14T16:37:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![lialvink](https://avatars.discourse-cdn.com/v4/letter/l/58f4c7/32.png) [@lialvink](https://matillioncommunity.discourse.group/u/lialvink)\
**Post date:** [November 14, 2022, 4:37pm UTC](https://matillioncommunity.discourse.group/t/hi-i-am-doing-basis-etl-in-matillion-i-am-looking-to-extract-data-from-oracle-and-write-to-a-file-i-am-using-database-query-to-unload-but-i-dont-see-any-option-to-write-to-file-is-there-any-connectors-any-guidance-will-be-great-help/1977/1 "2022-11-14T16:37:16Z")

</div>

Hi, I am doing basis ETL in Matillion. I am looking to extract data from oracle and write to a file. I am using database query to unload , but I don’t see any option to write to file … is there any connectors . Any guidance will be great help.

---

<div class="post-metadata">

**Author:** ![AnudeepK](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@AnudeepK](https://matillioncommunity.discourse.group/u/AnudeepK)\
**Post date:** [November 15, 2022, 4:08am UTC](https://matillioncommunity.discourse.group/t/hi-i-am-doing-basis-etl-in-matillion-i-am-looking-to-extract-data-from-oracle-and-write-to-a-file-i-am-using-database-query-to-unload-but-i-dont-see-any-option-to-write-to-file-is-there-any-connectors-any-guidance-will-be-great-help/1977/2 "2022-11-15T04:08:56Z")

</div>

Hi [@lialvink](https://matillioncommunity.discourse.group/u/lialvink)​ ,

May I know what destination you unloading the data to? If you are trying to unload the data to Azure/S3/GCP Storage , you do have connectors, " **Azure Blob Storage Unload**" , " **S3 Unload**" and **Cloud Storage Unload** respectively.

**Database query** allows you to copy data from one database (either on-prem/cloud) into another Cloud databases (Snowflake/Redshift/BigQuery etc). It also allows you to park the file in a TSV format at the Staging Plaform by setting up your Load options.,

Clean Staged Files : **Off**

Set File Prefix : **\<File Name\>**

 ![0694G00000OvQQMQA3_0D74G000008hMxNSAU](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/209fbaef506bfbd40aec42a330d70716472ca8b4.png)

---

<div class="post-metadata">

**Author:** ![lialvink](https://avatars.discourse-cdn.com/v4/letter/l/58f4c7/32.png) [@lialvink](https://matillioncommunity.discourse.group/u/lialvink)\
**Post date:** [November 28, 2022, 3:58pm UTC](https://matillioncommunity.discourse.group/t/hi-i-am-doing-basis-etl-in-matillion-i-am-looking-to-extract-data-from-oracle-and-write-to-a-file-i-am-using-database-query-to-unload-but-i-dont-see-any-option-to-write-to-file-is-there-any-connectors-any-guidance-will-be-great-help/1977/3 "2022-11-28T15:58:44Z")

</div>

Thank you Anudeep. I want to unload data from oracle to Azure blob . I don't see option for oracle database.

---

<div class="post-metadata">

**Author:** ![AnudeepK](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@AnudeepK](https://matillioncommunity.discourse.group/u/AnudeepK)\
**Post date:** [December 15, 2022, 11:17pm UTC](https://matillioncommunity.discourse.group/t/hi-i-am-doing-basis-etl-in-matillion-i-am-looking-to-extract-data-from-oracle-and-write-to-a-file-i-am-using-database-query-to-unload-but-i-dont-see-any-option-to-write-to-file-is-there-any-connectors-any-guidance-will-be-great-help/1977/4 "2022-12-15T23:17:46Z")

</div>

In this case, you can you Database Query Component to solve your problem. Set the following options.

This will generate a tab separated CSV file to your Azure Blob Storage. The only issue with this component is it allows you to generate a file with a defined prefix. The file will have a hex name defined to it.

&nbsp;

 ![0694G00000PTVNuQAP_0D74G000008hccVSAQ](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/50bf06c0a780eee5567ea45cfe6de5082c4260ff.jpeg)