RDS Connection

RDS is Relational Database service on Cloud. RDS sources can read in batch from the supported RDS Databases (i.e., RDS-Postgres, RDS-MYSQL, RDS-Oracle and RDS-MSSQL). The connection configuration properties of RDS are similar to those of relational databases (JDBC connectors) with one addition of SSL Security.

SSL Security can be enabled on RDS Databases.

System should be able to connect, read and write from SSL Secured RDS.

If security is enabled, it will be configured in Connection and automatically propagated to the respective channel.

Connection Configuration #

Connection Name: Name of the connection to be created.

Connection Type: Option to choose between either connecting securely using SSH Tunnel or, proceed with a direct connection.

If Connection Type value is SSH Tunnel, additional fields will bedisplayed as given below:

To know more about SSH Tunneling with Gathr, see SSH Tunneling.

SSH Key: The SSH key should be provided to authenticate the associated SSH host and SSH user.

SSH Host: Public IP address of your SSH host.

SSH Port: Port number used for SSH connections. The default SSH port is 22 unless otherwise specified.

SSH User: Default SSH username.

If Connection Type value is Direct Connection, then proceed by updating the following fields.

Enable SSL: The checkbox can be selected if SSL is enabled on RDS.

Upload Keystore File: If SSL is enabled, a keystore file has to be uploaded using this option.

Database Name/Service Name: Name of the database/service.

Host: RDS host name.

Port: RDS port number.

Username: Username of the RDS account.

Password: Password of the RDS account.

After entering all the details, click on the TEST button.

If the connection service identification and authentication details are provided correctly, a success message stating “connection available” is generated. Click on the CREATE button to save the changes.

If the details are incorrect or the server is down, you will get a message “Connection unavailable”.