The OneCloud IBM Db2 BizApp enables OneCloud to integrate with the Db2 relational database system natively. Combining the ability to perform Db2 database operations across other applications, including Tableau and Power BI and performance management applications such as Anaplan, IBM Planning Analytics, Planful, and Oracle EPM, Workiva, and BlackLine allows OneCloud customers to tightly and bi-directionally integrate their data stored in Db2 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 IBM Db2 from the service drop-down and select the appropriate Runner, and use the IBM Db2 Connections Parameters to complete the setup.

📓 IBM Db2 Port

The default port for IBM Db2 is often one of the following: 446, 6789, or 50000. Usually, if the default port is being used by the database server, the :<port> value of the JDBC URL can be omitted.

📓 IBM Db2 Connection Parameters

Visit IBM Db2’s documentation to learn more about additional connection parameters that can be leveraged.

Connection Example

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?