Help Desk

Submit a ticket My Tickets

Postgres BizApp

Premium BizApp

The OneCloud PostgreSQL BizApp enables OneCloud to natively integrate with the Postgres relational database system. Combining the ability to perform Postgres database operations across other applications including Tableau and Power BI and performance management applications such as Anaplan, IBM Planning Analytics, Host Analytics, and Oracle EPM, allows OneCloud customers to tightly and bi-directionally integrate their data stored in Postgres with other apps.

For documentation on all available commands, see the Postgres Command Reference.

Need a specialized Postgres Command?

If there are specific Postgres operations that your company is looking to perform to discuss the requirements and the possibility to incorporate the capability into OneCloud.

Connection Setup

To enable OneCloud to interact with a relational system, you’ll need to navigate to the connection manager to create a connection.

From here, choose PostgreSQL from the service drop-down and select the appropriate Runner. 

UsernameTextFieldThe username to authenticate with.
PasswordTextFieldThe password to authenticate with.
Connection URLTextFieldThe connection URL (e.g postgresql://localhost:5432/sample)

PostgreSQL Port

The default PostgreSQL port is 5432 but could be different depending on your environment.

PostgreSQL Connection Parameters

Visit the PostgreSQL Documentation portal to learn more about additional connection parameters that can be leveraged.

Connection Example

The following is an example of a working connection. Please substitute your own values.

Brian is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.