💡 Remember to activate the Connection for the desired Environments.

With the OneCloud Google BigQuery BizApp, natively integrate with the Google BigQuery system. Combining the ability to perform Google BigQuery 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 easily and bi-directionally share their data stored in Google BigQuery with other applications.

Connection Setup

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

Input

Type

Detail

Notes

Username

Text Field

Your BigQuery Project ID

The Project ID can be found by clicking the Project selector in the top bar of the BigQuery UI.

Username

Text Field

Your service account credentials JSON file

This file gets generated when creating your service account. See the following link for more details: https://cloud.google.com/iam/docs/creating-managing-service-accounts

Connection Example

Please substitute your own values.

💡 Remember to activate the Connection for the desired Environments.

Did this answer your question?