On this Page
Overview
The Workday Prism Analytics Bulk Load is a write-type Snap that you can use to upload multiple records/files from many cloud or on-premise sources (such as ERP, CRM, and other databases) to derive analytical reports on the input data. SnapLogic integrates Workday Prism Analytics's Utilize Data Load API, enabling you to use the Workday Prism Analytics Bulk Load Snap in conjunction with other standard-mode Snaps that SnapLogic supports. This Snap comes with OAuth 2.0 authentication to secure your data.
This Snap accepts documents from the input view, creates a batch CSV file, and also compresses and uploads the same to an existing or new dataset.
Modes
- Standard: Works with Standard Pipelines.
- Ultra: Does not work in Ultra Pipelines.
- Spark: Not supported in Apache Spark.
Expected Input and Output
- Input:
- First input: A document with data that can comprise numbers, text, Boolean, and date/time stamps.
- Second input: A schema definition. Ensure that you pass name and type data types in the schema definition.
- Output: A document that states the number of records processed and can contain the ID, name, bucket size, state, and processed files.
The following are a few SnapLogic Snap Packs that can work with the Workday Prism Analytics Bulk Load Snap:
- Binary
- Transform
- REST
- Microsoft Dynamics AX/CRM
- MS Dynamics 365 for Sales
- Salesforce
Configuring Views
Input view | One or two documents |
|---|---|
| Output view | One document |
| Error view | One document |
Limitations and Known Issues
- Max bucket size: 3GB (compressed)
- Maximum size of a single file is 256MB (compressed; handled internally by Workday Prism Analytics Snap)
- Max size of all files across buckets: 100GB (compressed)
- Max files per bucket: 100
- Max concurrent file uploads: 10
- Max buckets: 100 (in a rolling 24 hour period)
- File names are not modifiable but are replaceable
- JCC logs do not contain Retry messages in case of network failures
Snap Settings
| Parameter Name | Data Type | Description | Default Value | Example Value |
|---|---|---|---|---|
| Label | String | Enter a name for the Snap. This needs to be unique within the Pipeline. | None | Workday Prism Analytics Bulk Load |
| Dataset Name | String | Enter the dataset name. This needs to match with the dataset name in Workday Prism Analytics. Can have up to 255 alphanumeric and underscore characters, starting with a letter, but cannot end with an underscore. Ensure that the user has at least read permission for the dataset in Workday Prism Analytics. | None | Analytics dataset |
| Create dataset if not present | Check box | Select this check box to create an empty dataset in SnapLogic, in case there is no existing dataset in Workday Prism Analytics. | Deselected | NA |
| Operation type | Object | Specify whether you want to add or replace data in the existing dataset. Available options are:
| Append | NA |
| Connection timeout | Integer | Enter the timeout value in seconds after which the Pipeline will abort while executing. | 30 | 30 |
| Maximum retry attempts | Integer | Enter the maximum retry attempts for this Snap to connect with Workday Prism Analytics after which the Pipeline will abort, while executing. | 5 | 5 |
| Retry request interval | Integer | Enter the time interval (in seconds) for this Snap to connect with Workday Prism Analytics, between two retry requests. | 3 | 3 |
| Snap execution | Check box | Select one of the three modes in which the Snap executes. Available options are:
| Deselected | NA |
Example
This use case demonstrates a Pipeline that derives how many opportunities in Microsoft Dynamics CRM converted into revenue in the preceding 3, 6, and 12 months. This data is derived by integrating Dynamics CRM/AX with Workday Prism Analytics using a host of SnapLogic Snaps. You can download the following pipeline and configure the respective accounts and data files to explore this use case.
Pipeline Example
Preview Outputs
Pipeline 1
Pipeline 2
Downloads