PostgreSQL
PostgreSQL
Follow these steps to connect PostgreSQL to your CData Connect Cloud account:
-
Open the Connections page of the CData Connect Cloud dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type PostgreSQL into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
In the Server field, enter the host name or IP address of the PostgreSQL server.
-
Select the Authentication method, then proceed to the relevant section and follow those instructions.
Password
-
In the User field, enter the PostgreSQL username for authentication.
-
Enter the user password in the Password field.
-
(Optional) Enter the name of the PostgreSQL Database. If none is entered, the user’s default database is used.
-
(Optional) Specify the port for connecting to the PostgreSQL server in the Port field. This is set to 5432 by default.
-
In PostgreSQL, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add PostgreSQL Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
AzureAD
-
In the User field, enter the PostgreSQL username for authentication.
-
Enter the Azure Tenant Id to connect to.
-
(Optional) Enter the name of the PostgreSQL Database. If none is entered, the user’s default database is used.
-
(Optional) Specify the port for connecting to the PostgreSQL server in the Port field. This is set to 5432 by default.
-
Click Sign in to connect securely through OAuth. This action opens the PostgreSQL sign-in page in a new tab.
-
Log into your PostgreSQL account and provide the requested permissions (if applicable).
-
In PostgreSQL, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add PostgreSQL Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
AzurePassword
-
In the User field, enter the PostgreSQL username for authentication.
-
Enter the user password in the Password field.
-
Enter the Azure Tenant Id to connect to.
-
(Optional) Enter the name of the PostgreSQL Database. If none is entered, the user’s default database is used.
-
(Optional) Specify the port for connecting to the PostgreSQL server in the Port field. This is set to 5432 by default.
-
In PostgreSQL, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add PostgreSQL Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
AWSIAMRoles
-
In the User field, enter the PostgreSQL username for authentication.
-
Enter the AWS Access Key associated with the AWS root account.
-
Enter the AWS Secret Key associated with the AWS root account.
-
Enter the AWS Role ARN for the authenticating User Id.
-
(Optional) Enter the AWS External Id only if emulating a different role.
-
(Optional) Enter the name of the PostgreSQL Database. If none is entered, the user’s default database is used.
-
(Optional) Specify the port for connecting to the PostgreSQL server in the Port field. This is set to 5432 by default.
-
In PostgreSQL, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add PostgreSQL Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect Cloud and PostgreSQL, see this information page.