---
title: "Create a List from the Database"
slug: "create-a-list-from-the-database"
description: "This documentation article shows you how to create a list from a database in Test Modeller."
tags: ["Learning Portal", "Test Data Automation", "Test Data Automation 101"]
updated: 2024-09-27T14:30:27Z
published: 2024-09-27T14:30:27Z
canonical: "knowledge.curiositysoftware.ie/create-a-list-from-the-database"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.curiositysoftware.ie/llms.txt
> Use this file to discover all available pages before exploring further.

# Create a List from the Database

[Embedded content](https://www.youtube.com/embed/WIbb5vIk4wg?&wmode=opaque&rel=0)

Lists are a flat file structure in Enterprise Test Data which allow users to create flat data lists in a spreadsheet format. In this article, we'll discuss how to create a list from data which exists in the backend database.

#### 1. Create a new List

Creating a list of the database imports the data into a spreadsheet-style table Enterprise Test Data. This section details how to do that.

Begin in the Data Lists pane, by clicking on Data Lists in the Modeller section of the Navigation Panel. The Lists pane opens. There will be several lists already there, that were shipped with the product. Click on the **New List** button.

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681747491159.png)

#### 2. Import Details

The New List box appears. Fill in as follows:

- **Name:** an appropriate name for the list
- **Type:** select General
- **Application:** Select the most appropriate application. If this is a new installation, the only option will be “Default”
- **Description:** an appropriate description for the list
- **External Provider:**Switch this to **Yes**
- **Provider Type:** Select SQL

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681747516259.png)

- **Server:** Click on the cog icon on the right of the bar to get a list of connected VIP servers and select the most appropriate one from the dropdown

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681747536511.png)

- **Process:**This should default to SQLtoList
- **Connection:** Click on the cog icon on the right of the bar to get a list of connections. Select the one you made earlier.
- **Used Table:** Enter the name of the table you want to import.
- **Used Columns:**enter the column names you want in your list, separated by commas. There is no wildcard option to select all columns.

Set any other settings as you need

Then click on OK

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681747542783.png)

This starts a VIP process to import the data from the table. You can see the progress in VIP Executer.

#### 3. Review List

When the VIP process completes, the Lists pane shows the newly created List.

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681747549064.png)

Clicking on the List name shows the imported data.

**![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681747555936.png)**

Enterprise Test Data is Curiosity's next generation solution for Test Data Management. The all-in-one platform for enterprise test data needs. Understand complex data, remove sensitive information, and generate rich data for your entire organisation.

## Related

- [Using Databases in Enterprise Test Data](/using-databases-in-test-modeller.md)