Release Information

Introduction

Getting Started

Delphix Engine System Administration

Virtual Database Management with the Delphix Engine

Data Backup and Recovery

Delphix Modernization Engine

Delphix Masking

Virtualizing Unstructured Files in the Delphix Engine

Virtualizing Oracle E-Business Suite in the Delphix Engine

JetStream

Mission Control

Delphix Express User Guide

Reference


Documentation for Previous Versions of the Delphix Engine

Delphix Server 3.0 Documentation
Delphix Server 3.1 Documentation
Delphix Engine 3.2 Documentation
Delphix Engine 4.0 Documentation
Delphix Engine 4.1 Documentation
Delphix Engine 4.2 Documentation
Delphix Engine 4.3 Documentation

Skip to end of metadata
Go to start of metadata

Delphix allows you to provision all or a subset of data to a target you choose. Delphix can create a target database for you on your existing systems or in the cloud. While the target database will normally be the same type as the source, it can also be different – for example, Oracle to SQLServer. This power and flexibility will provide your development and testing teams with the ability to procure fresh secure data from a source environment and move it to their nonproduction environment any time they need it. Provisioning jobs perform extract and load functions only. Delphix does not transform data as part of this process.

Practical Subset Example

This section provides an example of when you might want to subset data. All the functionality for provisioning is done at the individual table level.
If you want to filter information based on customers, as part of the rule set you can filter as follows:

  1. Columns — Select a column or columns from a table when you don't want to load data to all the columns in a table.
  2. Filter — Specify a filter to run on the data before loading it to the target database.
  3. Join Table — Specify a SQL join condition so you can define primary key/foreign key relationships between tables.
  4. List — Select a list to use for filtering data in a table.
  5. Custom SQL — Use SQL statements to filter data for a table.

To change these filters, see Modifying Tables in a Rule Set.