Set Up Salesforce Extension
Learn how to set up, load data, and configure concepts for the Salesforce Extension.
Introduction
In this quick set up guide, you will learn how to seamlessly integrate your Salesforce data into the Visier platform. By following this guide, you'll learn how to set up, create, and run the tasks needed to extract the data from your source system. After loading data, you'll configure concepts to connect your data values to Visier's analytic model.
Objectives
First, you need to get the extension added to your tenant. Then, we will take you through setting up a data connector. After the data connector is created, we will show you how to schedule and monitor a data load by running a quick extraction job to generate a data version. Once the new data version is generated, you will configure selection concepts. Then, you can preview the solution to start analyzing the content. From there, you can start creating your own unique analyses, concepts, metrics, and more.
By the end of this tutorial, you will have successfully set up the extension to use in the solution.
You will learn how to:
- Set up a data connector
- Run a job to generate a data version
- Configure selection concepts
- Preview the data in the solution
Prerequisites
- A Visier account that has the following profiles. If you don't have an account, contact your administrator.
Data Engineer
-
A Visier account with a permission that allows the user to access guidebooks, analyses, the Explore room, and data access to view the data you’re loading. For more information, see Permission Management.
-
Ad Hoc Analysis
-
Create Analysis Context
-
Change Analysis Context
-
Guidebook
-
View Details
-
-
Your connector credentials. Contact your IT department to get your connector credentials. When you set up the data connector in Studio, you need to provide the following credentials to Visier so that we can retrieve data from your source system. To get the credentials, you need to create an integration user in Salesforce. For more information, see Salesforce.
Credential
Description
Example
Login Host
The URL of the Salesforce instance that was used to create the client application.
https://bluth-development.my.salesforce.com
Client ID
The unique identifier of the client application you created.
Wkph4nlbhOaHxYzeEipk
Client Secret
The client secret of the client application you created.
37J61DMMB666Q3J84GE0Q9YGBIKQJB
Username
The integration user's username.
integration.user@company.com
Password
The integration user's password.
Password1234
Steps
Add the Salesforce Extension module
Set up data connector
- In a project, on the navigation bar, click Data > Connectors.
- Click Create Connectors.
- Select a credential from the list or create a new one. To create a new credential, do the following:
- In Select or add credential, click Add new.
- Select Salesforce and click Next.
- In Authenticate Salesforce, set the Application to Custom.
- Enter your connector credentials and click Next. After you create the connector credential, a pop-up may appear from Salesforce. Enter the credentials for the integration user to connect the Salesforce account.
Result: The credentials are saved and ready to use. To finish the workflow, move on to steps 4 and 5.
- In Add Basic Information, type a display name and description for the connector.
- Click Create.
Run a quick onboarding extraction job
Quick onboarding automatically includes tables that are recommended for a selected topic. As part of this workflow, all the necessary data loading and data processing objects, such as data categories, sources, and mappings will be created. Then an extraction job will run to retrieve data through the connector.
- In the connector, click Quick onboarding.
- In the Quick onboarding dialog, do the following:
- In Data topic, select Salesforce Extension.
- In Data history, select Past 6 months. You can adjust the data history when needed.
- When finished, click Next.
- In the next page, click Run to start the extraction job. You can also click Back to change the job configuration before running the job.
- Review the progress of quick onboarding. Once complete, click Go To Jobs.
Monitor data load and generate new data version
- In the Jobs room, click the Refresh button
to track the status of your data extraction and get the most up-to-date load information. If successful, the data load job generates a new data version. Take note of the data version number.
- On the navigation bar, click Data > Data Categories.
- Confirm that the same data version shows under the Salesforce Extension data category. If the data version is different, see Set the Data Version.
Configure selection concepts
- On the navigation bar, click Model > Concepts.
- Search for the following selection concepts:
- Sales Process
- Sales Employee
- For each concept, navigate to the Configure tab.
- In the list of data members, select the values that are relevant to the selection concept. For example, for the Sales Employee selection concept, you may select job names such as Sales Executive and Senior Sales Executive.
Preview your project
- On the navigation bar, click Preview Solution.
Result: The preview of the solution will open in a new tab.
Next steps
You've successfully set up the Salesforce Extension! This tutorial walked you through how to set up, create, and run the tasks needed to extract the data from your source system. You also configured concepts to select the relevant data values.
Now, you can preview the solution to start analyzing the content. Check out the following analyses in the Visier Extensions Guidebook > Salesforce Extension topic:
- How is your organization's sales opportunity progressing?: Review whether you have the right people on the right opportunities to achieve your sales target.
- Learn About Sales Opportunity Metrics: Learn about the different types of sales opportunity metrics available in the Salesforce Extension.
- Sales Opportunity - Validation: Validate the configuration and counts for sales opportunity data.
From here, you can start creating your own unique analyses, concepts, metrics, and more. If you want to learn about the design decisions behind the Salesforce Extension, see How We Designed the Salesforce Extension.
Optional: Validate mappings
You can validate the mappings generated by the connector by doing the following:
- In a project, on the navigation bar, click Data > Mappings.
If you notice that some objects are unmapped, you may not have data for that column, or you may have a custom column that needs to be mapped. You can download the Salesforce Extension data dictionary to see the required, recommended, and optional fields for data loading.
For more information on the Mappings room, see Mappings.
Publish the project
At this point, you might choose to publish your project so that the changes are available in production. For more information, see Publish Project Changes. If you choose not to publish, only you and anyone with access to the project can see your changes.