Workday Prism Analytics Bulk Load
On this Page
Overview
Use the Workday Prism Analytics Bulk Load Snap 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. 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 or table.
Prism API v3 support: The Workday Prism Bulk Load Snap supports v3 of the Workday Prism Analytics API, which operates with SQL-style tables rather than legacy base datasets.
Support for Ultra Tasks
Does not support Ultra Tasks.
Supported Version
This Snap Pack supports Prism API v1, v2, and v3.
v1 uses legacy base datasets.
v2 and v3 both use SQL-style tables.
Behavior change
Previously, the Snap relied on string-based version extraction from the configured API URL. This has been replaced with numeric version extraction, enabling integer-based comparisons for behavior branching across API versions. This change ensures better forward compatibility with future versions of the Prism API, reducing the possibility of future Snap failures when new versions are released (as long as endpoint structures remain stable).
The Snap now correctly handles tables in both v2 and v3. This avoids the need to manually convert base datasets to tables later, aligning the Snap with Workday’s shift away from legacy data models.
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
The Snap does not support Delta Lake operations currently.
The Snap does not support using Workday Instance ID for creating data set/tables.
Snap Views
| Type | Format | Number of Views | Examples of Upstream and Downstream Snaps | Description |
|---|---|---|---|---|
| Input | Document |
|
|
|
| Output | Document |
|
|
|
| Error | Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:
When you select the Enable debug checkbox, the information about the executed request and response is written to the error view in case of errors. Learn more about Error handling in Pipelines. | |||
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. | Workday Prism Analytics Bulk Load | Bulk Load Updated Data |
| Dataset/Table Name | String | The name of the dataset or table to which you want to upload the input documents. The dataset or table name must match with the dataset name in Workday Prism Analytics. This field can accept up to 255 alphanumeric and underscore characters. The string must start with a letter and cannot end with an underscore.
| N/A | Analytics dataset |
| Create Dataset/Table if Not Present | Check box | Select this check box to create an empty dataset or table if there is no corresponding dataset or table in Workday Prism Analytics. | Deselected | NA |
| Operation Type | Object | Specify whether you want to add or replace data in the existing dataset/table. Available options are:
| Append | NA |
| Bucket Completion Timeout | Integer | Specify the maximum number of minutes to wait for the bucket to complete the bulk upload. We recommend that you update this value depending on the size of the data that you want to upload. If the bulk load is not completed within the completion timeout period, the operation times out. A Workday bucket is a folder that contains all the files that you want to upload to Workday at a time. Once the Snap is able to connect to your Workday Prism Analytics account, it creates a bucket using the data that you provide to the Snap. Default value: 30 Minimum value: 1 | 30 | 100 |
| Connection Timeout | Integer | The number of seconds after which the Snap must abort while executing. Minimum value: 0 Maximum value: 999999999 | 30 | 30 |
| Maximum Retry Attempts | Integer | The maximum number of retry attempts that this Snap must make to connect with Workday Prism Analytics, after which the Pipeline will abort. Minimum value: 1 Maximum value: 9999999999999990 | 5 | 5 |
| Retry Request Interval | Integer | The number of seconds for which the Snap must wait between two retry requests. Minimum value: 0 Maximum value: 9999999999999990 | 3 | 3 |
| Loading | Check box | Loading | Deselected | N/A |
Loading
Troubleshooting
| Eror | Reason | Resolution |
|---|---|---|
| Failed to complete the bucket. | The connection timeout value might be small. | Set the Bucket Completion Timeout to a higher value, for example, 100. |
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
Snap Pack History
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2025 SnapLogic, Inc.