Help Desk

Submit a ticket My Tickets

MySQL BizApp

Premium BizApp

The OneCloud MySQL BizApp enables OneCloud to natively integrate with the MySQL relational database systems. Combining the ability to perform MySQL 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 MySQL with other apps. 

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 MySQL from the service drop-down, select the appropriate Runner, and use the My SQL Connection Parameters to complete the setup.

MySQL Port

The default MySQL port is 33060 but could be different depending on your environment.

MySQL Connection Parameters

Visit the MySQL 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.

What's Next?

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

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.