AWS Database Blog
Category: HAQM Simple Storage Service (S3)
How realtor.com maximized data upload from HAQM S3 into HAQM DynamoDB
This is a customer post by Arup Ray, VP Data Technology at realtor.com, and Daniel Whitehead, AWS Solutions Architect. Arup Ray would like to acknowledge Anil Pillai, Software Development Engineer at HAQM, for his pioneering contributions to this project during his former tenure at realtor.com as Senior Principal Data Engineer. realtor.com , operated by Move, Inc., […]
Integrating HAQM RDS for Oracle with HAQM S3 using S3_integration
HAQM RDS for Oracle gives you the full benefits of a managed service solution. You can use the lift-and-shift approach to migrate your legacy Oracle database to HAQM RDS for Oracle and, as a result, reduce the need to refactor and change existing application components. Data warehouse (DW) extraction is an integral part of most […]
Store SQL Server backups in HAQM S3 using AWS Storage Gateway
Customers like Alkami and Acadian Asset Management use AWS Storage Gateway to back up their Microsoft SQL Server databases directly to HAQM S3, reducing their on-premises storage footprint and leveraging S3 for durable, scalable, and cost-effective storage. Storage Gateway is a hybrid cloud storage service providing on-premises applications with access to virtually unlimited cloud storage. […]
Replicate data from HAQM Aurora to HAQM S3 with AWS Database Migration Service
In this blog post, I’ll cover how to use an AWS CloudFormation template to automate the configuration that allows you to replicate data between a relational database like HAQM Aurora to HAQM Simple Storage Service (HAQM S3). I’ll walk you through a sample CloudFormation template so that you can customize for your needs. The AWS […]
Client-Side Encryption and Decryption of Microsoft SQL Server Backups for Use with HAQM RDS
This blog post walks you through how to securely encrypt a Microsoft SQL Server backup file and restore the encrypted backup to an HAQM RDS for SQL Server instance. You perform this process using HAQM Simple Storage Service (HAQM S3) and AWS Key Management Service (AWS KMS). This post details the encryption and steps required […]
Migrate Delimited Files from HAQM S3 to an HAQM DynamoDB NoSQL Table Using AWS Database Migration Service and AWS CloudFormation
July 2023: This post was reviewed for accuracy. Recently, AWS Database Migration Services (AWS DMS) added support for using HAQM S3 as a source for your database migration. This new support means that you can now load data in comma-separated value (CSV) format from S3 into any supported target, whether or not the target has […]
Reading HAQM S3 Data from Oracle on HAQM EC2
When you’re working with AWS services, HAQM S3 is the first choice to store text data files. In the past, to access S3 data, first you’d download the files and then perform extract, transform, and load (ETL) to load the data into Oracle. This approach has two drawbacks. It takes time to download and perform […]
Use HAQM S3 to Store a Single HAQM Elasticsearch Service Index
September 8, 2021: HAQM Elasticsearch Service has been renamed to HAQM OpenSearch Service. See details. As detailed in our documentation, you can use the Elasticsearch API actions in HAQM Elasticsearch Service to take manual snapshots of your domain. You can easily back up your entire domain this way. However, did you know you can also […]