In this video, we will show you how to migrate historical data from Oracle database to S3, run Amazon Athena Ad hoc query to validate and explore your data in S3 and use Amazon Athena federated query to join OLTP data and historical data to provide you a single view of your data.
The reference documents as below:
Amazon RDS for Oracle – https://go.aws/2Xt6jUx
Using an Oracle database as a source for AWS DMS – https://go.aws/3DXl7KU
Query your Oracle database using Athena Federated Query and join with data in your Amazon S3 data lake – https://go.aws/3vAnekQ
More AWS videos – http://bit.ly/2O3zS75
More AWS events videos – http://bit.ly/316g9t4
Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform, offering over 200 fully featured services from data centers globally. Millions of customers — including the fastest-growing startups, largest enterprises, and leading government agencies — are using AWS to lower costs, become more agile, and innovate faster.
#AWS #AmazonWebServices #CloudComputing
Publisher: Amazon Web Services
You can watch this video also at the source.