Jitterbit Salesforce Wave Analytics (Einstein Analytics)

NOTE: 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.

Salesforce Einstein Analytics is designed to provide the ability for any Salesforce end-user to analyze data and build personalized charts and dashboards. It is designed to be mobile-ready and provides a platform to build powerful analytical apps.

The Jitterbit Salesforce Wave Analytics (Einstein Analytics) provides any Salesforce-Jitterbit customer the ability to analyze data external to Salesforce—such as SAP, Microsoft AX, or custom on-premises databases—by leveraging Jitterbit’s connectors, Transformation Wizard, and support for standard protocols. The Jitterbit Salesforce Wave Analytics 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.   

Key Components

The key components of the Jitterbit Salesforce Wave Analytics (Einstein Analytics) are:

Jitterbit Salesforce Wave Analytics (Einstein Analytics)

Transformation Wizard: Target Type Salesforce Wave Analytics Dataset

Salesforce Wave Analytics (Einstein Analytics) Dataset

The structure and content of the data used in Salesforce Wave Analytics (Einstein Analytics) is defined in Jitterbit Design Studio using the Salesforce Wave Analytics Dataset file format, as shown in this example:

You can define these properties for each item in a Dataset's format:

Salesforce Wave Analytics Dataset Transformation

A Salesforce Wave Analytics Datasets transformation target type allows you to use the Jitterbit Harmony transformation engine and generate a Salesforce Einstein Dataset. You use the Transformation Wizard to step you through the process to create the Dataset:



Here, a source text document is specified and its definition is displayed:



The wizard includes the ability to create a new Dataset structure/format based on either the selected source structure or an existing Dataset:


The Dataset structure is designed to be reusable, similar to the Jitterbit Harmony File Format feature, and can be reused across multiple operations. The Dataset includes the metadata JSON which will be attached to the Dataset when it is uploaded to Salesforce.

A transformation maps the source file to the Dataset target. After automating is complete, you manually add any additional mappings required:

Salesforce Wave Analytics Dataset Target

A Salesforce Wave Analytics Dataset target is used when transforming data into a Dataset used in Salesforce Einstein Analytics.

The target provides these properties: