0

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

Ashish Patil
  • 1
  • 1
    In reading [Publishing Products - AWS Data Exchange User Guide](https://docs.aws.amazon.com/data-exchange/latest/userguide/publishing-products.html), it seems that the data files need to be in Amazon S3. Therefore, you would need to find a way to automate the export of the data from Oracle to S3 objects. – John Rotenstein Jan 21 '21 at 08:57
  • Is [this](https://aws.amazon.com/blogs/big-data/publish-and-update-data-products-dynamically-with-aws-data-exchange/) option for you? – amitd Jan 21 '21 at 09:44
  • yes this was helpful...one way to do it...trying to find any rest call to aws dataexchange to load data directly in dataexchange – Ashish Patil Jan 21 '21 at 11:18

1 Answers1

0

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.

jbchan
  • 26
  • 2