AWS Database Blog
Set Up AWS DMS for Cross-Account Migration
Hemant Borole is a big data consultant at Amazon Web Services. AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS easily and securely. AWS DMS supports homogenous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora. For customers who use […]
Z-Order Indexing for Multifaceted Queries in Amazon DynamoDB: Part 1
Update from May 29, 2018: Today, we published Z-order indexing for multifaceted queries in Amazon DynamoDB: Part 2. TL;DR Using Z-order indexing, you can efficiently run range queries on any combination of fields in your schema. Although Amazon DynamoDB doesn’t natively support Z-order indexing, you can implement the functionality entirely from the client side. A single […]
Use SQL to map users, roles, and grants from Oracle to PostgreSQL
July 2023: This post was reviewed for accuracy. Many customers are undertaking the journey to open source relational database management system (RDBMS) databases. With the latest release of the AWS Schema Conversion Tool (AWS SCT), it’s easy to change your database engine. AWS SCT makes heterogeneous database migrations easier by automatically converting procedural code from […]
Introducing Data Extractors in AWS Schema Conversion Tool Version 1.0.602
We are pleased to announce the recent release of version 1.0.602 of the AWS Schema Conversion Tool (AWS SCT). The new version includes a new key capability—data migration agents that extract data from Oracle, MS SQL Server, Teradata, IBM Netezza, Greenplum and HPE Vertica data warehouses, prepare, optimize and upload it to Amazon Redshift. The […]
How to Build a Chat Application with Amazon ElastiCache for Redis
Sam Dengler is a Solutions Architect at Amazon Web Services In this blog post, we review concepts and architectural patterns relevant to a chat application. We also discuss implementation details for a chat client and server, and instructions to deploy a sample chat application into your AWS account. Background information Building a chat application requires […]
Migrating Oracle Database from On-Premises or Amazon EC2 Instances to Amazon Redshift
Ballu Singh and Pubali Sen are solutions architects at Amazon Web Services. AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS easily and securely. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases. The service supports homogenous migrations such as Oracle to […]
How to Stream Data from Amazon DynamoDB to Amazon Aurora using AWS Lambda and Amazon Data Firehose
February 9, 2024: Amazon Kinesis Data Firehose has been renamed to Amazon Data Firehose. Read the AWS What’s New post to learn more. We find that customers running AWS workloads often use both Amazon DynamoDB and Amazon Aurora. Amazon DynamoDB is a fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency […]
Events and Notifications in AWS Database Migration Service
We’ve recently added a new feature in AWS Database Migration Service (AWS DMS)—the ability to receive DMS events notifications, such as email messages, text messages, or calls to HTTP endpoints, through Amazon Simple Notification Service (Amazon SNS). You now can subscribe and receive notifications for two types of events—events related to DMS instances and events […]
Send Apache Web Logs to Amazon Elasticsearch Service with Kinesis Firehose
February 9, 2024: Amazon Kinesis Data Firehose has been renamed to Amazon Data Firehose. Read the AWS What’s New post to learn more. September 8, 2021: Amazon Elasticsearch Service has been renamed to Amazon OpenSearch Service. See details. We have many customers who own and operate Elasticsearch, Logstash, and Kibana (ELK) stacks to load and […]
How to Configure a Private Network Environment for Amazon DynamoDB Using VPC Endpoints
Gisung Lim is a security solutions architect at Amazon Web Services Korea and Sangpill Kim is an enterprise solutions architect at Amazon Web Services Korea. This blog post explains how to enhance the privacy and security of data transfers between Amazon DynamoDB and your corporate network using the new Amazon VPC Endpoints for DynamoDB (currently in public preview). With […]