How to create batch process to upload Oracle DB data to AWS Data Exchange?

122 Views Asked by At

I am looking for scope where i can send data from oracle db to AWS Data exchange without any manual intervention?

1

There are 1 best solutions below

0
On

In January 2022, AWS Data Exchange launched support for data sets backed by Amazon Redshift; the same guide referenced by John Rotenstein, above, shows you how you can create a data set using Amazon Redshift datashares. If you are able to move data from the Oracle database to Amazon Redshift, this option may work for you.

AWS Data Exchange just announced a preview of data sets using AWS Lake Formation, which allows you to share data from your Lake Formation data lake, which has support for Oracle databases running in Amazon Relational Database Service (RDS) or hosted in Amazon Elastic Compute Cloud (EC2). Steps to create this kind of product can be found here.