Data Population screen

Configures data population for an application.

Screen



Screen



Good to Know

How to Start

  1. Do one of these:
  2. On the Application Explorer screen, do one of these:
  3. Click Misc > Data Population .

Fields

Field Name Definition

Repository

Function:
Specifies whether to write the data to a database or a SharePoint list or library.
Accepted Values:
  • Microsoft SQL Server - Writes the data to a Microsoft SQL Server database.
  • Sharepoint - Writes the data to a SharePoint list.
Default Value:
None

Database

Function:
Specifies the access token that connects to your database.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Accepted Values:
A list of access tokens configured for your environment.
Default Value:
None
Accepts Process Data Variables:
No

Schema Name

Function:
Specifies your schema.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Accepted Values:
A schema name from the list.

When you select a database, the schemas associated with the database show in this field.

Default Value:
None

Add Token

Opens this Screen:
New Database Access Token
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Function of this Screen:
Configures a new access token for a database.

SharePoint

Function:
Specifies the access token that connects to your SharePoint site.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select SharePoint.
Accepted Values:
A list of access tokens configured for your environment.
Default Value:
None
Accepts Process Data Variables:
No

Add Token

Opens this Screen:
New SharePoint Access Token
To Open this Field:
  1. On the Data Population screen, in the Repository list, select SharePoint.
Function of this Screen:
Configures a new access token for SharePoint.

Table Names

Function:
Shows all the table names of the specified database.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Accepted Values:
A database table names selected from the database.
Default Value:
None
Accepts Process Data Variables:
No

Selected Table Names

Function:
Specifies the database table names.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Accepted Values:
The table names selected from the Table Names list.
Default Value:
None
Accepts Process Data Variables:
No

Site URL

Function:
Specifies the URL for your SharePoint site.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select SharePoint.
Accepted Values:
A valid SharePoint site URL
Default Value:
None
Accepts Process Data Variables:
Yes
Example:
  • http://[machine name]:[port]/sites/[site name]

    You must include the /sites in the Site URL for the site to be created successfully.

List Name

Function:
Shows the name of your SharePoint list.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Accepted Values:
The name of your SharePoint list.
Default Value:
None
Accepts Process Data Variables:
No

Selected List Names

Function:
Specifies the name and primary key of your SharePoint list.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select SharePoint.
Accepted Values:
  • Field Name - Specifies the name of your SharePoint list.
  • Primary Key - Specifies the primary key to be used for each list.
Default Value:
None
Accepts Process Data Variables:
No

Map Data

Opens this Screen:
Schema Mapper screen
Function of this Screen:
Maps SharePoint fields, form fields, web methods, or other input sources to an XML schema..