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 |