Salesforce CRM Analytics

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

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”:

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

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:

Copy the password:

The copied password will contain JSON, example:

{
  "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 Use the values from the above JSON, each time “JSON file” is referenced in the above help article.

Basics

Advanced

AI

For Partners