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, email 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).