AWS Database Blog

Category: Database

Use SQL to map users, roles, and grants from Oracle to PostgreSQL

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 the source SQL dialect into the target SQL […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

How to Stream Data from Amazon DynamoDB to Amazon Aurora using AWS Lambda and Amazon Kinesis Firehose

Aravind Kodandaramaiah is a partner solutions architect with the AWS Partner Program Introduction 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 at any scale. Its flexible data model and reliable performance […]

Read More

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 […]

Read More

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 […]

Read More

Preventing Accidental Table Deletion in DynamoDB

Edin Zulich, AWS NoSQL solutions architect It’s easy to delete a table in Amazon DynamoDB, and that means that it’s easy to delete one by accident, too. Fortunately, you can minimize the risk of accidentally deleting a table using AWS Identity and Access Management (IAM), which provides authentication and access control for DynamoDB. As a […]

Read More

Wave: A Private Location App Running on Amazon RDS

By Pablo Clemente, CTO, Wave How many times have you endured the painful process of meeting up with someone and having to constantly text or call them to find out where exactly they are? Doing this is not only inefficient and frustrating, but also a potential danger for anyone who is driving or moving. Recently, […]

Read More

Eduphoria Uses Amazon Aurora to Give Educators Superpowers

Eduphoria is making great use of Amazon Aurora and other AWS database services. In this guest post, you can learn about how they use Amazon Aurora to scale their read workload while saving costs. This post was written by Aaron Dulaney, director of infrastructure operations at Eduphoria. At Eduphoria, we provide K–12 educators the tools […]

Read More