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.
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
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:
Default Value: A default value can be set that is used when generating the Dataset data file. Note that Numeric data types cannot be null or an empty string when generating a Dataset file. Setting a default value will ensure that a Dataset is generated and uploaded successfully. Date types can be null, but a default value to override a null can be supplied. Default date values must be in the format of YYYY-MM-DD.
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:
A Salesforce Wave Analytics Dataset target is used when transforming data into a Dataset used in Salesforce Einstein Analytics.
The target provides these properties: