Salesforce Einstein Analytics With a CSV File or a Database¶

Caution

Salesforce has renamed Salesforce Wave Analytics as Salesforce Einstein Analytics. However, Jitterbit Design Studio still retains the original name of Wave Analytics. Both terms are used here as appropriate.

Note

To obtain this Jitterpak, contact Jitterbit Support. The Jitterpak is unsupported and is to be used only for reference with Design Studio.

Overview¶

The Jitterbit Salesforce Wave Analytics (Einstein Analytics) Connector provides any Salesforce/Jitterbit customer the ability to analyze any data external to Salesforce such as SAP, Microsoft AX, or custom on-premises databases by leveraging Jitterbit's connectors, Transformation Wizard, and its support for standard protocols. The Jitterbit Salesforce Wave Analytics (Einstein Analytics) Connector leverages all existing components of Jitterbit. Any Jitterbit user designing Jitterbit projects and operations can easily augment their existing projects and inject the required external data into Salesforce Einstein Analytics.

Requirements¶

Jitterbit Design Studio Version 8.6.0.1 or higher
Access to Einstein Analytics (Wave Analytics) in Salesforce.com
Download the Wave Analytics Jitterpak (Project) provided by Jitterbit Support.
For more information on the Dataset format, please refer to the Salesforce Wave Analytics documentation.

Setup¶

For video instructions, click on the picture below:

Set Up Your Einstein Analytics¶

Login to your Salesforce.com org where you have access to Einstein Analytics
Using the menu at the top right hand corner, navigate to Einstein Analytics (shown here with the original name Wave Analytics)

attachment

Click the "Create" button to create an "App"

attachment

Name your app "JBDemo".

Set up Your Jitterbit Project¶

Import the Jitterpak in Jitterbit Studio
Navigate to "Jitterbit Connect" section of the left panel:
1. Enter your Salesforce Username
2. Enter your Salesforce Password
3. Enter your Salesforce Security Token, if required
4. Test the Salesforce Login
5. Save your connection
6. Deploy
Navigate to Targets section on the left Panel:
1. Select the Salesforce Org you set up in the previous step
2. Enter the "Container Name" or "App Name" (as it is called in Salesforce) you set up while preparing your Einstein Analytics environment
Test the connection
Save
Navigate to "Operations on the left Panel"
Double-click on "Customer CSV Dataset"
Click on Deploy button on the top ribbon and deploy everything
Click on the lightning bolt to execute the operation
Log into your Salesforce instance and the data should now be available for analysis