---
title: "Using Databases in Enterprise Test Data"
slug: "using-databases-in-test-modeller"
description: "This documentation will take you from scanning your database, creating a definition and then creating versions."
tags: ["Learning Portal", "Test Data Automation", "Test Data Automation 101"]
updated: 2024-09-27T14:30:27Z
published: 2024-09-27T14:30:26Z
canonical: "knowledge.curiositysoftware.ie/using-databases-in-test-modeller"
---

> ## 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.

# Using Databases in Enterprise Test Data

Enterprise Test Data has a rich toolkit of database functions that help you understand, test, mask, synthesise, and mimic your database content, tables, and structures in all common database management systems.

Before you can use a database table in Enterprise Test Data, it needs to be scanned in, which imports the schema, and a definition needs to be created. The definition is what Enterprise Test Data uses to later apply database functions.

Definitions are structured packages that can hold and describe any number of versions of a database. Having versions of a file lets Enterprise Test Data compare and find the differences between versions, and mirror change over time.

Once you have a definition, the Data Activities can mask, compare, subset, clone, generate and analyse your data

This documentation will take you from scanning your database, creating a definition and then creating versions.

**In this documentation, we will use these tables:**

OT_Contacts, the customer contact table used by Example Corp.

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

OT_Employees, the table of employees

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

And a modified version of the OT_Employees file with hierarchy grades. We’ll use this to demonstrate definition version creation.

[OT_Employees with Grade.csv](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/OT_Employees%20with%20Grade.csv)![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681746868042.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

- [Connecting to a Database](/making-a-database-connection.md)
- [Scanning a Database](/creating-a-scan-of-the-database.md)
- [Create a List from the Database](/create-a-list-from-the-database.md)
- [Creating a Definition from an Existing Connection](/creating-a-definition-with-an-existing-schema.md)
- [Creating a Definition Without an Existing Connection](/creating-a-definition-without-an-existing-schema-1.md)
- [Creating a Definition From an Existing Schema](/creating-a-definition-without-an-existing-schema-adding-one-after.md)
- [Database Definition View Explained](/details-of-a-definition-explained.md)
- [Database Definition Structure Explained](/details-of-a-definition-structure.md)
- [Database Versions Explained](/database-versions.md)
- [Database Diagrams](/database-diagrams.md)