Advanced import filter

By default, Dataedo imports all objects from the documented database. However, you may configure which objects you want to import. You may define it based on:

• Object type
• Schema name pattern
• Object name pattern

To define a filter, enter advanced options by checking the Advanced settings checkbox and clicking the Connect button.

To clear the previous filter, click Clear filter on the next screen.

There are two sets of rules - Include rules and Exclude rules. To add a rule, click the Add include/exclude pattern link underneath. To remove any specific rule, click Remove next to it.

Include rules

Include rules define your set of objects - each rule adds objects to your set of objects to import.

There is a logical OR operator between include rules.

Exclude rules

Each exclude rule subtracts objects from your set of imported objects defined by include rules.

There is a logical AND operator between exclude rules and a NOT operator before each rule.

Exclude rules are more important than include rules.

Patterns

• 'temp' means all objects which name is 'temp'
• 'temp%' means all objects that name starts with the string 'temp'
• '%temp' means all objects that name ends with the string 'temp'
• '%temp%' means all objects that have the string 'temp' in their name

Examples

Example 1: Tables only

The example below imports tables from all schemas.

Example 2: Specific schema only

The example below imports all objects (tables, views, stored procedures, views) from the 'hr' schema.

Example 3: Specific prefix

The example below imports all objects that names begin with the 'cust' prefix.

Example 4: Exclude stored procedures and functions

The example below imports all objects but excludes any stored procedures and functions.

Example 5: Advanced

The example below imports tables and views plus functions from the 'hr' schema but excludes any object from the 'admin' schema and any object which name ends with 'temp'.