This pane contains fields for entering credentials to connect to your database and SSH server. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector. This section enumerates the options in the Credentials and Details panes in the PostgreSQL SSH Connector page. The SSH keys need to be the DES or RSA keys generated by OpenSSL. Note: Domo does not support the SSH keys generated using ssh-keygen.
#POSTGRES SSH TUNNEL FULL#
For the full list of IP addresses, see Whitelisting IP Addresses for Connectors. The username and password for the UNIX accountīefore you can connect to a PostgreSQL database, you must also whitelist a number of IP addresses on your database server on the port you want to connect to. The PostgreSQL database hostname or IP address The port number for the PostgreSQL database The username and password you use to log into your PostgreSQL database To connect to a PostgreSQL database via an SSH tunnel and create a DataSet, you must have the following: This connector is appropriate for pulling database information into Domo.Įase of Use (on a 1-to-10 scale with 1 being easiest) Contact your IT administrator for assistance. Note: Depending on your network's structure, your IT administrator may need to whitelist any IP addresses necessary for the data connector to retrieve data.