

Location Connection for Aurora PostgreSQL.NOTE: The port may have been changed from the default by an administrator. The default database listener port that must be opened for TCP/IP connection is 5432. Amazon designed Aurora to work in conjunction with MySQL 5.6, and PostgreSQL, built for the cloud service. It is recommended to restrict access to only the Local Data Processing system that requires access, rather than allowing broader or public access. Amazon Aurora is a cutting-edge relational database service, created, and offered by AWS in 2014. If the Local Data Processing system connecting to Aurora PostgreSQL runs in the same VPC as Aurora PostgreSQL, you can use the internal rather than public IP address for the service to allow access. When directly connected from a Local Processing Hub Server, the connection must be allowed for the Local Processing Hub Server. If a High-Volume Agent (HVA) is in place, then communication must be enabled for the system where the HVA is running. To enable the Local Data Processing capture or integrate process to connect to Aurora PostgreSQL, you must allow inbound traffic on the database listener port to the system running the Local Data Processing process.

This section describes the requirements, access privileges, and other features of Fivetran Local Data Processing when using Amazon Aurora PostgreSQL for replication.įor information about compatibility and supported versions of Aurora PostgreSQL with Local Data Processing platforms, see Supported Platforms.įor the Capabilities supported by Local Data Processing with Aurora PostgreSQL, see Capabilities for Aurora PostgreSQL.įor information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see Data Type Mapping. Edit on GitHub Aurora PostgreSQL Requirements link
