Skip to content

Amazon RDS Data Source Overview

Audience: Data Owners, Users of AWS RDS Databases

Content Summary: This guide provides a basic overview of Immuta's integration with Amazon RDS databases as data sources. No special configuration is needed to register content in RDS databases as data sources within Immuta. Consequently, the standard query-backed data source creation guide may be used with RDS databases.

Overview

Amazon Web Services provides a managed database service, Amazon Relational Database Service (RDS), that supports a variety of database engines: Amazon Aurora, MariaDB, Microsoft SQL Server, MySQL, Oracle, and PostgreSQL. Immuta treats each of these as it does any other SQL-based technology, allowing the creation of data sources from any of the technologies using the procedures described in the Query-backed Data Source Tutorial without special handling. As Immuta does not require write access to databases, Immuta can connect to read replicas where applicable to reduce analytic query burden on primary database servers.

RDS Database Engine Support

The following RDS database engines and versions are supported. Any unsupported features are noted.

Database Engine Unsupported Features Supported Versions
Aurora (MySQL) N/A 5.6 - 5.7
Aurora (PostgreSQL) N/A 9.6 - 11.6
MariaDB N/A 10.0 - 10.3
Microsoft SQL Server N/A 11 - 14
MySQL N/A 5.5 - 8.0
Oracle N/A 11.2 - 19.0
PostgreSQL N/A 9.6 - 11.6