The Optim™ Directory
is a set of tables in which Optim stores
objects needed for processing and tracking processing status. Before
using Optim, you must use the Configuration program
to create or configure the Optim Directory
tables and stored procedures needed to access the Directory.
See the Installation and Configuration Guide for more information.
Note: For Teradata, you cannot create the Optim Directory in a Teradata database, so
you must create the Optim Directory
in another supported database, such as Oracle or DB2® with a Federation Server instance; and the
DB Alias in that database must point to the Teradata database.
Important Optim Directory
objects include the following:
- DB Aliases
- A DB Alias provides parameters needed to connect with a specific
database. It is used as a high-order qualifier for an object or table
name and tells Optim how to
access the appropriate database.
- Access Definitions
- An Access Definition identifies the set of related data to be
processed by Optim. It identifies
the database tables and their relationships, and provides criteria
to select specific rows within tables.
- Table Maps
- A Table Map defines the correlation between two tables or sets
of tables in an Insert, Update, Restore, or Compare Process and can
be used to exclude one or more tables from processing.
- Column Maps
- A Column Map defines the correlation between columns in two tables.
Additionally, a Column Map can be used to transform data, age dates
in tables, and exclude one or more columns from processing.
- Column Map Procedures
- A Column Map Procedure is a custom program that is referenced
by a Column Map and is used for special processing and data manipulation
that is beyond the scope of native Column Maps.
- Primary Keys
- Values in primary key columns uniquely identify each row in a
database table.
- Relationships
- A Relationship determines the parent or child rows to be processed
and the order in which they are processed.
- Processing Definitions
- A Processing Definition provides parameters needed to run a process,
including the names of generated files, the Access Definition used
for the process, and the source of processed data. You can sometimes
use parameters in a process definition to override parameters defined
for the Access Definition. Process definitions include the following
Request types: Archive, Compare, Convert, Delete, Edit, Extract, Insert,
Load, Report, and Restore.
- Utility Definitions
- A Utility Definition is used for some type of specialized processing.
Utility definitions include: Calendars, Storage Profiles, and Currency
Tables.
- Security Definitions
- A Security Definition provides parameters needed for Optim Security.
- Access Control Domains (ACDs) map
roles to network accounts.
- The (Default) ACD provides
Functional Security parameters.
- Access Control Lists (ACLs) provide
parameters used with Object Security.
- File Access Definitions (FADs) provide
parameters used with Archive File Security.
- Archive File Registrations
- Archive File Registrations provide all information needed to locate
and process data on archive files.
After one or more Optim Directories
are created, you can use the Optim Directory Editor to:
- Browse a list of Optim Directories available to the workstation.
- Establish or change the Default
Directory or connection for the workstation.
- View Optim Directory
attributes while connected.
- Modify the code page or connection
string for an Optim Directory
connection.
Contents
This
section describes the specifications on the Optim Directory
Editor.