On this Page
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.
The following are a few SnapLogic Snap Packs that can work with the Workday Prism Analytics Bulk Load Snap:
Configuring Views
Input view | One or two documents |
---|---|
Output view | One document |
Error view | One document |
The Snap does not support Delta Lake operations currently.
The Snap does not support using Workday Instance ID for creating data set/tables.
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 |
The maximum number of minutes for which you want the Snap 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. Default value: 30 Minimum value: 1 Maximum value: 9999999999999990 | 30 | 10 | |
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 | |
Check box | Deselected | N/A |
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 1
Pipeline 2