Example: Run the
PrismAnalytics
Sample Assembly
This example demonstrates how to use the
PrismAnalytics
component to send CSV data to Workday Prism Analytics. Source CSV files are provided
in the assembly project. For the purposes of this example, copy these files to an
SFTP server for retrieval by the sample assembly.Security: These domains in the Integration functional area:
- Integration Build
- Integration Configure
- Integration Event
- Register a Prism API client and copy values that thePrismAnalyticscomponent requires.
- In Workday, access theRegister API Client for Integrationstask.
- Register an API client withPrism Analyticsas itsScope (Functional Area). Select theInclude Workday Owned Scopecheck box.
- Copy theClient IDandClient Secretvalues.
- From the related actions menu, select .
- Select aWorkday Accountto associate with the refresh token. The account must have permission to create Prism tables in Workday.
- Generate a refresh token and copy the value.
- Obtain Workday REST API Endpoint.
- Access theView API Clientsreport.
- Copy theWorkday REST API Endpointvalue. Delete thehttps://at the beginning and the/ccx/api/v1/<tenant_name>at the end.
- On the Studio toolbar, select .
- On theProject Nameswindow, clickFinish.
- On theProject Explorerview, expand thePrismAnalyticsfolder and double-click theAssemblyfolder.
- Copy the provided sample CSV files to your SFTP server.
- In thePrismAnalyticsproject folder, expand .
- Copy these files to your SFTP server:
- states.csv
- states2.csv
- states3.csv
- states4.csv
- states5.csv
- On the Assembly Editor toolbar, clickShow annotations.
- On theCloud Explorerview, clickConnection Details.
- Select theSandboxenvironment and enter these values on theConnectionswindow:
Option Description TenantThe name of your tenant.UsernameThe username credentials for your tenant.PasswordThe password credentials for your tenant. - ClickApply and Close.
- On theProject Explorerview, right-click thePrismAnalyticsfolder and selectDeploy to Workday.
- On theDeploy to Workdaywindow, select theSandboxenvironment and clickFinish.
- On theCloud Explorerview, launch 1 of the integrations in this sample.
- Expand theSandboxnode.
- Expand thePrismAnalyticsCollectioncollection node.
- Expand thePrismAnalyticsproject node.
- Right-click a workday-in transport node and selectLaunch Integration. Example:SingleCSV.
- ClickLaunch.
Workday Prism Analytics creates a
table
using the CSV data you supplied.