Configure Data Population with Microsoft SQL Server

To configure data population to store data in Microsoft SQL Server, do the procedure in this topic.

Examples

• (Example) How Can I Map Repeating Schema Element to Data Population?
• Examples - Step-by-step use case examples, information about what types of examples are provided in the AgilePoint NX Product Documentation, and other resources where you can find more examples.

Good to Know

• If you want to use SharePoint for data population, your Sharepoint access token must use SharePoint user credentials. Authentication with the AgilePoint System Account is not supported for data population.

How to Start

1. Do one of these:
   • Create a Process-Based Application.
   • Open a process-based application.
2. On the Application Explorer screen, do one of these:
   • Open a Process.
   • Create a Process.
3. Click Misc > Data Population .

Procedure

1. On the Data Population screen, in the Repository field, select Microsoft SQL Server.
2. In the Database list, select your databae access token.

   To create a new access token, click Add Token . For more information, refer to Access Token for Database.

3. Drag the table name from the Table Names box to the Selected Table Names box.
4. Click Map Data.
5. On the Schema Mapper, map the table names to the schema.