Sync data from your warehouse to your Workday Adaptive Planning modeled sheets.
|Supported Sync Modes
|Import data to a selected modeled sheet
|Modeled sheet docs
For more information about sync modes, refer to the sync modes docs.
Go to the Destinations overview page and click the Add destination button. Select Workday Adaptive Planning and click Continue. You can then authenticate Hightouch to Workday Adaptive Planning by entering the following required fields into Hightouch:
- Workday Username
- Workday Password
Once you've entered these fields, click Continue. Give your destination a descriptive name and Finish the destination connection setup.
Once you've set up your Workday Adaptive Planning destination and have a model to pull data from, you can set up your sync configuration to begin syncing data. Go to the Syncs overview page and click the Add sync button to begin. Then, select the relevant model and the Workday Adaptive Planning destination you want to sync to.
The Workday Adaptive Planning destination allows you to Mirror your data to a spreadsheet or insert new rows with Insert mode.
Mirror mode replaces the entire selected sheet's contents with the rows from your model. Ensure that your sheet doesn't contain data that shouldn't be overwritten if you select this mode.
You can insert rows into or completely replace the selected modeled sheet with data from your model. To begin, select the sheet you want to sync data to and its version.
In Insert and Mirror mode, Workday Adaptive Planning automatically generates an identifier for every new record synced, so there is no need to match an existing record.
Hightouch lets you sync sheet fields via field mapping. You can map data from any of your model columns to your modeled sheet fields. Workday Adaptive Planning requires the following fields, so you must map them to complete your configuration:
- Asset Class
Ensure your model columns data types match the data types of the fields you want to sync to.
Workday Adaptive Planning uses numbers to represent boolean values. Use
If you encounter an error or question not listed below and need assistance, don't hesitate to . We're here to help.
Workday Adaptive Planning uses the pipe symbol (
|) to separate the sheet's columns.
Make sure your data does not contain any pipe symbols since it will cause a mismatch
in the header and row data.
Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.
Hightouch can alert you of sync issues via Slack, PagerDuty, SMS, or email. For details, please visit our article on alerting.