Data Stores in Adobe Workfront Fusion

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.

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 500 MB allotment, the default size is the amount of unallocated storage.

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

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.