The OneCloud Amazon Redshift BizApp enables OneCloud to natively integrate with the Redshift system. Combining the ability to perform Amazon Redshift 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 Redshift with other apps.
For documentation on all available commands, see the Amazond Redshift Command Reference.
Need a specialized Amazon Redshift command?
If there are specific Amazon Redshift operations that your company is looking to perform, please contact firstname.lastname@example.org to discuss the requirements and we would be happy to consider adding the capability to the product.
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 Amazon Redshift from the service drop-down and select the appropriate Runner.
The username to authenticate with.
The password to authenticate with.
The connection url. (e.g jdbc:redshift://endpoint:port/database)
Amazon Redshift Connection Parameters
Visit Redshift's documentation to learn more about additional connection parameters that can be leveraged.
The following is an example of a working connection. Please substitute your own values.