The OneCloud PostgreSQL BizApp enables OneCloud to integrate with the Postgres relational database system natively. 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, Planful, and Oracle EPM, allows OneCloud customers to tightly and bi-directionally integrate their data stored in Postgres with other apps.

Connection Setup

To enable OneCloud to interact with a relational system, navigate to the Connection manager to create a Connection. From here, choose PostgreSQL from the service drop-down, select the appropriate Runner, and use the PostgreSQL Connection Parameters to complete the setup.

📓 PostgreSQL Port

The default PostgreSQL port is 5432, but it could be different depending on the 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.

⚠️ This BizApp requires the installation of a Java runtime. For best system compatibility please install Java 8.

💡 Remember to activate the Connection for the desired Environments.

Did this answer your question?