A DataMigrator Server must be installed and configured
for DataMigrator. The server houses and executes the data and process
flows from which a data warehouse, data mart, or other data targets
are constructed. The server consists of the following components:
- Engines for
data sorting, transformations, e-mail notification, scheduling,
and security rules.
- Read and write
adapters, which are used to extract and load the data.
- Metadata or
synonyms (.mas and .acx files) that describe column information
and access rules to data sources and/or data targets.
- Data flows, which are procedures that
contain the necessary instructions for extracting, transforming,
and loading the data targets. These procedures are built by the DMC
and stored on the server in two files:
- A procedure with the extension .fex,
which is ready to run.
- A file with
the extension .etg, which contains detailed information needed for the
graphical display.
- Process flows,
which contain the necessary instructions for interleaving data flows with
other objects. Like data flows, these instructions are built by
the DMC and stored on the server as .fex and .etg files.
- DataMigrator
internal tables, containing the DM log and run-time statistics.
- Stored procedures,
which contain instructions for specific tasks. These procedures are
edited using the text editor of the DMC.
- iWay remote
server (optional). Access to a remote server is required when source data
is on a different platform from the DataMigrator Server. Adapters
to extract the source data reside on the remote server (subserver).
Though optional, one or more subservers are used at many DataMigrator
sites.
The following figure illustrates a DataMigrator Server environment
in which both the data source and the data target reside on the
DataMigrator Server.
The following figure illustrates a DataMigrator Server environment
in which the data target (whether a data warehouse, data mart, or
another type of target) resides on the DataMigrator Server and the
data source resides on a remote server (subserver).