This article has expired. Please visit the OneCloud Knowledge Base for the latest documentation.


Premium BizApp

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

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


Need a specialized IBM Db2 command?

If there are specific IBM Db2 operations that your company is looking to perform, please contact [email protected] to discuss the requirements and we would be happy to consider adding the capability to the product.

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 IBM Db2 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 jdbc:db2://host:port/database)


IBM Db2 Port

The default port for IBM Db2 is many times one of the following: 446, 6789, or 50000. Usually, if the default port is being used by the database server, the : 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

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

Updated 6 months ago


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.