How to Provision Tables from a Source Environment

The following table describes how to create a task to provision tables from a selected source environment. For example: Extract 5 tables from Production and load them to the UAT environment:

Scenario

Example

Source

Subset

Test Data Store

Target

Extract Business entities and referential (related) tables

Extract 10 customers and the customer_type table from Production.

Select the Entities & referential data option

N/A

Y

N

Extract tables only

Extract 5 tables from Production.

Select the Tables option

Optional

Y

N

Extract and load Business entities and referential (related) tables.

Extract 10 customers and the customer_type table from Production, and load them to the UAT environment.

Select the Entities & referential data option

N/A

Y

Y

Extract and load tables only

Extract 5 tables from Production, and load them to the UAT environment.

Select the Tables option

Optional

Y

Y

Load Business entities and referential (related) tables

Get from the Test Data Store 5 entities and one table pre-extracted from Production, and load them to the UAT environment.

Select the Entities & referential data option

N/A

Y

Y

Load tables only

Get from the Test Data Store 2 tables pre-extracted from Production, and load them to the UAT environment.

Select the Tables option

Optional

Y

Y

Previous

How to Provision Tables from a Source Environment

The following table describes how to create a task to provision tables from a selected source environment. For example: Extract 5 tables from Production and load them to the UAT environment:

Scenario

Example

Source

Subset

Test Data Store

Target

Extract Business entities and referential (related) tables

Extract 10 customers and the customer_type table from Production.

Select the Entities & referential data option

N/A

Y

N

Extract tables only

Extract 5 tables from Production.

Select the Tables option

Optional

Y

N

Extract and load Business entities and referential (related) tables.

Extract 10 customers and the customer_type table from Production, and load them to the UAT environment.

Select the Entities & referential data option

N/A

Y

Y

Extract and load tables only

Extract 5 tables from Production, and load them to the UAT environment.

Select the Tables option

Optional

Y

Y

Load Business entities and referential (related) tables

Get from the Test Data Store 5 entities and one table pre-extracted from Production, and load them to the UAT environment.

Select the Entities & referential data option

N/A

Y

Y

Load tables only

Get from the Test Data Store 2 tables pre-extracted from Production, and load them to the UAT environment.

Select the Tables option

Optional

Y

Y

Previous