Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Can I Write to an Oracle database?

Can i write the result of a Transformation to an on-premise Oracle database?
A more general question is what are the possible targets of write the output of a transformation?

3 Community Answers

Matillion Agent  

Craig Rouse —

Hi Klen,
Matillion targets Redshift, Snowflake and Big Query.
No option exists to write data back to on-premise databases.
Thanks,
Craig


douglas garcia —

Hi Craig,

"No option exists to write data back to on-premise databases."

Not even with a python script component?

Best regards,

Douglas


Matillion Agent  

Laura Malins —

Hi Klen

I think Craig meant Matillion doesn’t offer a native way to write back to on-premise databases and this is deliberate by design. Of course you can write a python script which can write back to Oracle and this can be run from the Python component within Matillion.

Another common approach customers take is you can output the data to S3 using an S3 Unload component and then another process can take that file and load the data into Oracle.

I hope that helps.

Thanks
Laura

Post Your Community Answer

To add an answer please login