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.
Hi @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>
Thank you Anudeep. I want to unload data from oracle to Azure blob . I don't see option for oracle database.
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.
