> ## Documentation Index
> Fetch the complete documentation index at: https://help.peliqan.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Salesforce CRM Analytics

Salesforce CRM Analytics is a BI tool that allows you to work with data from Peliqan:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Salesforce%20CRM%20Analytics/image.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=dc8c7014d0cc09c0525e1383fc07eb06" alt="image.png" width="1200" height="644" data-path="images/Connect your BI, DB tool or iPaaS/Salesforce CRM Analytics/image.png" />

Make sure to use a **Bigquery** data warehouse in Peliqan, if you want to use Salesforce CRM Analytics as a BI tool.

Activate the Bigquery data warehouse under Connections. Click on “Add data warehouse”:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Salesforce%20CRM%20Analytics/Screenshot_2026-07-03_at_15.47.49.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=1eef003bbe464785ea969a6b3bbca3e1" alt="Screenshot 2026-07-03 at 15.47.49.png" style={{ width:"41%" }} width="872" height="1250" data-path="images/Connect your BI, DB tool or iPaaS/Salesforce CRM Analytics/Screenshot_2026-07-03_at_15.47.49.png" />

Click on “Provision now”, in the card “Peliqan Bigquery data warehouse”:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Salesforce%20CRM%20Analytics/Screenshot_2026-07-03_at_15.49.45.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=6b543d5dd0e3240dfe5c6cadebf0ae0b" alt="Screenshot 2026-07-03 at 15.49.45.png" width="1776" height="1386" data-path="images/Connect your BI, DB tool or iPaaS/Salesforce CRM Analytics/Screenshot_2026-07-03_at_15.49.45.png" />

Once the Bigquery data warehouse is ready, make sure to add new source Connections and select Bigquery as the target, so that your data resides in Bigquery.

Next, go to your Bigquery connection card:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Salesforce%20CRM%20Analytics/Screenshot_2026-07-03_at_15.48.03.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=441dc07e7e4b96aea51afa9a05245945" alt="Screenshot 2026-07-03 at 15.48.03.png" style={{ width:"47%" }} width="736" height="1096" data-path="images/Connect your BI, DB tool or iPaaS/Salesforce CRM Analytics/Screenshot_2026-07-03_at_15.48.03.png" />

Copy the password:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Salesforce%20CRM%20Analytics/Screenshot_2026-07-03_at_15.48.10.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=d1597b6801cbd0101f60f0df8341171c" alt="Screenshot 2026-07-03 at 15.48.10.png" style={{ width:"41%" }} width="404" height="156" data-path="images/Connect your BI, DB tool or iPaaS/Salesforce CRM Analytics/Screenshot_2026-07-03_at_15.48.10.png" />

The copied password will contain JSON, example:

```python theme={null}
{
  "type": "service_account",
  "project_id": "peliqan-bq-acme-1234",
  "private_key_id": "811cbb22c3c07fe01f9b98e658d3ef2990a84638",
  "private_key": "-----BEGIN PRIVATE KEY-----\nMIIEvg ... P7IqS4R1YS\n-----END PRIVATE KEY-----\n",
  "client_email": "peliqan-bigquery-peliqan--1234@peliqan-bq-acme.iam.gserviceaccount.com",
  "client_id": "114477637555534185679",
  "auth_uri": "<https://accounts.google.com/o/oauth2/auth>",
  "token_uri": "<https://oauth2.googleapis.com/token>",
  "auth_provider_x509_cert_url": "<https://www.googleapis.com/oauth2/v1/certs>",
  "client_x509_cert_url": "<https://www.googleapis.com/robot/v1/metadata/x509/peliqan-bigquery-peliqan--1234%40peliqan-bq-acme-1234.iam.gserviceaccount.com>",
  "universe_domain": "googleapis.com"
}
```

Follow the steps in Salesforce CRM Analytics, to add Bigquery:

[https://help.salesforce.com/s/articleView?id=analytics.bi\_integrate\_connectors\_googlebigquery\_standard\_sql.htm](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_googlebigquery_standard_sql.htm)

Use the values from the above JSON, each time “JSON file” is referenced in the above help article.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.