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

RDS component

How to conncet with the oracle db using the drivers...my data is in oracle and i want to load it into biqquery..so please help me to connect to it as I am new to Mattilion tool

1 Community Answers

Matillion Agent  

Laura Malins —

Hi Swetal

You can use the database query component in Matillion ETL for BigQuery. Details on configuring it are here:
https://bigquerysupport.matillion.com/customer/portal/articles/2147237?b_id=8914

The host will be the IP or endpoint name of your oracle RDS databse

You will also need to add the Oracle driver to Matillion, details are here:
https://bigquerysupport.matillion.com/customer/portal/articles/2406136-database-driver-management

We also have a video on how to use the Database Query component. It connects to a MySQL database but the concept is the same:
https://www.youtube.com/watch?v=PFdlJr4YH3Y

Thanks
Laura

Post Your Community Answer

To add an answer please login