Data Stores in Adobe Workfront Fusion

A data store, similar to a database or a simple table, can store data from scenarios, making it possible to transfer data between individual scenarios or scenario runs. You can use a data store to store new data from various systems during synchronization.

The data store modules enable you to take the following actions on records in your Adobe Workfront Fusion data store:

  • Add
  • Replace
  • Update
  • Retrieve
  • Delete
  • Search
  • Count

For information on using data store modules, see Data store modules.

For a video introduction to data stores in Workfront Fusion, see:

Access requirements

You must have the following access to use the functionality in this article:

Adobe Workfront plan*
Pro or higher
Adobe Workfront license*
Plan, Work
Adobe Workfront Fusion license**

Current license requirement: No Workfront Fusion license requirement.

Or

Legacy license requirement: Workfront Fusion for Work Automation and Integration

Product

Current product requirement: If you have the Select or Prime Adobe Workfront Plan, your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article. Workfront Fusion is included in the Ultimate Workfront plan.

Or

Legacy product requirement: Your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article.

To find out what plan, license type, or access you have, contact your Workfront administrator.

For information on Adobe Workfront Fusion licenses, see Adobe Workfront Fusion licenses.

Create a data store in Workfront Fusion

Set up the data store

Before you can use a data store in a module, you must create the data store in Workfront Fusion.

NOTE
Your organization has a limited number of available data stores. If you attempt to create more data stores than you have available, Workfront returns a Maximum stores reached error.
For more information, see Maximum stores reached error in this article.
  1. Log in to your Workfront Fusion account.

  2. Click Data stores in the left navigation panel.

  3. Click Add data store in the upper-right corner of the screen.

  4. Enter settings for the new data store.

    A bolded title on a field in a Workfront Fusion module indicates a required setting.

    table 0-row-2 1-row-2 2-row-2 layout-auto html-authored no-header
    Data store name Enter a name for the data store.
    Data Structure

    A data structure is a list of the columns for a table. This list indicates the column name and data type.

    Do one of the following:

    • Select a data structure that has been already created

    • Add a new data structure

      Click Add to create a new data structure.

      For more information, see the Set up the data structure section in this article.

    • Leave the field empty

      If you don't select or add a data structure, the database will only contain the primary key. Such a database type is useful if you want to save keys only and are interested in knowing only whether or not a specific key exists in the database.

    Data storage size in MB

    Allocate the size for the data store from your total internal data storage.

    The default value is 10 MB. If you have less than 10 MB of unallocated Data Store space from your 95 MB allotment, the default size is the amount of unallocated storage.

    Note: The reserved amount can be changed at any time.

Set up the data structure

  1. When creating or editing a data store, click Add.

  2. In the Add data structure box that displays, configure the following fields:

    table 0-row-2 1-row-2 2-row-2 layout-auto html-authored no-header
    Data structure name Enter a name for the new data structure.
    Specification

    Do one of the following to set up your data store's columns.

    • Click Add item to specify the properties of one column manually.

      Enter the Name and Type for the data store column and define corresponding properties.

    • Click Generator to determine the columns from the sample data you provide.

      Example:

      For example, the following JSON sample data creates three columns: name, age, and phone number. Phone number is a collection of mobile and landline phone numbers.

      {

      "name":"John",

      "age":30,

      "phone number": {

      "mobile":"987654321",

      "landline":"123456789"

      }

      }

      The empty columns in the data store view:

      You can then add values to the data store manually or by using the Workfront Fusion data store modules.

    Strict Enable this option to ensure that the payload matches the data structures. Payloads that contain extra items not specified in the data structure are rejected.

Edit an existing data store

You can edit the properties and contents of an existing Data Store in the Data Store area of Workfront Fusion.

Edit the properties of a data store

The properties of a data store include the data structure that the data store uses, as well as the data store’s size.

  1. Click Data Store in the left navigation panel to open the Data Store area.

  2. Click Edit next to the data store that you want to edit.

  3. (Optional) If you want to change the data structure used by this data store to another existing data structure, select it from the Data structure drop-down.

    Or

    (Optional) If you want to change the data structure used by this data store to an entirely new data structure, see Set up the data structure in this article.

  4. (Optional) Change the size of the data store by entering the new size into the Data storage size in MB field.

  5. Click Save.

Edit the contents of a data store

  1. Click the Data Store icon in the left navigation panel to open the Data Store area.
  2. Click Browse next to the data store that you want to edit.
  3. (Optional) Reorder columns by dragging them to the desired location.
  4. (Optional) Edit a single cell by clicking the Edit icon in that cell, then entering the desired value.
  5. (Optional) Add a new item to the data store by clicking Add, then entering the information for the new item.
  6. Click Save.

Troubleshooting

Restoring lost data from a data store

There is currently no tool which can automate restoring lost data.

Workaround

  1. Examine all execution logs of scenarios where items were inserted to the data store.

    For more information on examining execution logs, see View a scenario’s execution history in Adobe Workfront Fusion.

  2. Copy the data.

  3. Insert the data into your data store again.

    For information on inserting data into a data store, see Edit the contents of a data store in this article.

Out of space error

An Out of Space error occurs because your previously created data stores have already been assigned your allocated data store storage.

Workaround

  1. Edit any of your existing data stores to use less space. This frees up space for your new data store.

    For more information, see Edit the properties of a data store in this article.

NOTE
We recommend that you do not assign all of your space to a single data store unless you are certain you will not require more data stores.

Maximum stores reached error

A Maximum stores reached error occurs because your organization has used all of its available data stores. An organization has a number of available data stores equal to twice the number of available scenarios. Therefore, the total number of available data stores depends on the plan you have purchased.

For example, if your organization has purchased a plan with 15 scenarios, the organization can have up to 30 data stores.

Workaround

To reduce the number of existing data stores, consider doing one of the following:

  • Combine existing data stores
  • Delete unused data stores
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43