This chapter describes how to link PostgreSQL as an external data source to the Morph platform.

​
How to set it up.

To set up a connection to PostgreSQL, open the Connection Settings modal from the Connections tab on the Home screen, click the Create New Connection button and select PostgreSQL.

​
Connection configuration (Account)

This section describes the entries in the Account section. Enter the following connection configuration items as required and press the Create button in the bottom left-hand corner of the scroll down side panel.

  1. Host
    • IP address or hostname of the database server (e.g. db.example.com). localhost or 127.0.0.1 is invalid; make sure it is accessible from the static IP address of the Morph platform (54.150.149.0).
  2. Username
    • User name used to connect to the database server.
  3. Password
    • Password used to connect to the database server.
  4. Database
    • Name of the database you want to connect to.
  5. Port
    • Port number of the database server you want to connect to.
  6. SSH Host
    • IP address or hostname when going through a stepping-stone server (relay host). localhost or 127.0.0.1 is invalid; make sure it is accessible from the Morph platform’s fixed IP address (54.150.149.0).
  7. SSH Username
    • User name used to connect to the stepping-stone server.
  8. SSH Password
    • Password to be used when connecting to the stepping-stone server. Not required when using a private key (SSH Private Key) with the public key authentication method.
  9. SSH Port
    • Port number of the stepping-stone server.
  10. SSH Private Key
    • Private key used when connecting to a stepping-stone server. Not required if a password is used.
  11. SSH Passphrase
    • Enter if a passphrase has been set for the private key (SSH Private Key). Not required if a password is used.

​
Complete the connection settings.

Once you have completed the Account section and pressed the Create button in the bottom left-hand corner of the screen, you can now enter the Connection slug to complete the connection settings.

  1. Connection slug
    • Uniquely identifies the connection to the external data source and cannot be empty. Use only letters, numbers and underscores as desired.

When the connection settings appear in the Connections list, the configuration is complete.

MySQLAWS Athena