Sisense Setup Guide
Sisense is a business intelligence solution.
Setup instructions
Sisense V7.2 and lower
Download P12 file
In the Fivetran dashboard, go to the Destinations page.
Select your managed BigQuery destination.
Go to the BI Tools tab, then click + BI Tool.
On the Select your BI tool page, select Sisense.
Select Version as V7.2_and_lower.
Click Download file to download the P12 file.
Click Save.
Make a note of the Service Account, User Email, and Project ID. You will need them to configure Sisense.
Connect BigQuery to Sisense
- Add a Data Source Name (DSN).
- Authenticate the connection as a service.
- In the Email field, enter the user email you found in Step 1.
- In the Key File Path field, enter the file path of the downloaded P12 key file.
- Select the project with the Project ID you found in Step 1.
- Follow Sisense's instructions to add DSN.
- Download the Sisense Google BigQuery ODBC Driver, add it your ElastiCube Manager, and connect to BigQuery using the new DSN.
Sisense V7.3 and higher
Authorize Fivetran
In the Fivetran dashboard, click BI Tools, then click + BI Tool.
On the Select your BI tool page, select Sisense.
Select Version as V7.3_and_higher.
Click Authorize. Select the Google account you want to use. You will be redirected back to Fivetran.
Click Save.
Make a note of the Service Account and Project ID. You will need them to configure Sisense.
Connect BigQuery to Sisense
- Connect BigQuery to Sisense.
- Enter the Project ID you found in Step 1.
- Follow Sisense's instructions to connect BigQuery.