How to Integrate a BI Tool with Your Project in ACC?

This tutorial will walk you through the process of integrating a BI (Business Intelligence) tool with your project. BI tools enable you to analyze and visualize your data effectively, providing valuable insights for informed decision-making.

Creating Google BigQuery Account​

Once you have set up the BI Tool within your project, the next step is to create a Google BigQuery account. Follow these steps:

1

Click the Go to console button.

2

You'll be directed to the console setup. Follow the on-screen instructions.

3

On the next page, click the Create Project button.

4

Enter a project name and select the location for storing data. Then, click the Create button.

5

After project creation, you'll need to generate a project ID for your Google project. The business-intelligence field should match the project name on ACC. The location from which this project receives data is displayed in the breakdown menu.

6

Once the project is created, a service-account.json file is generated. This file is crucial for transferring data to Google BigQuery. Make sure to add the information from this file using the CLI.

Below are the environment variables that must be added to the CLI:

• BI_TOOL_TOKEN: Enter an alphanumeric value of 16 characters following the token in "Token x16."

• BIGQUERY_PROJECT_ID: BigQuery project ID.

• BIGQUERY_DATASET: The name of the dataset on BigQuery.

• GOOGLE_APPLICATION_CREDENTIALS: JSON.

7

Click on the location where the data is received to display data on the page. This page dynamically shows data based on data transfer frequency.

To customize incoming data for reports, you can write queries in the relevant field.

ACC Setup Requirements​

1

Navigate to the App Store in the left-side menu and find the BI Tool application in the application catalog. Clicking on the application card will direct users to the project selection step.

2

Choose the project in which the BI Tool application will be installed, and then click on Configure Application Values. Clicking this button will direct users to the application value entry step.

3

At this stage, users should input the application values required for configuring the application. Enter the necessary values and click Save and Continue.

4

Once the application values have been entered, they will be reviewed in the final step, and users can initiate the application installation by clicking the Install button.

5

The BI Tool frontend and backend applications will be installed in the selected project. Users can monitor the deployment status of these applications on the project's detail page.