The two principal components of DataMigrator are the iWay DataMigrator Server, which includes the Web Console, and the Data Management Console.
DataMigrator Server is typically installed on the platform where your data target (a data warehouse, data mart, or another type of target) will reside. Your first task is determining that location. The following list of tasks assumes that your source data resides on that same platform.
Note: At many sites, source data is on a different platform from the one on which the DataMigrator Server is installed. If this is the case at your site, you need to install, configure, and test one or more remote servers, using the process described in Remote Server Setup At a Glance.
The DMC can be installed on each Windows computer that will be used to build flows or on a shared network drive.
This step identifies the name and port of the DataMigrator Server you will be connecting to and adds the server name(s) to the DMC server list. See How to Add a Node to Identify the Server to the Data Management Console.
Tip: If, during the installation of the DMC, you configured it to access the DataMigrator Server, this step is optional. When installing a Windows server, a default LOOPBACK node is configured. This node should not be deleted.
Note: If all of your source data is stored on remote servers, omit this step and Step 8 and proceed to Step 9.
Note: If you are using more than one data source for the same adapter, repeat Step 8 as many times as necessary before going to Step 9. If, however, you have data sources in a variety of adapters, repeat Step 7 and Step 8, then proceed to Step 9.
This step is necessary if the data target is of a different database type than the data source(s) or if all of your data is on remote servers. After completing this step, proceed to Step 10.
Note: If you have more that one data adapter for your data targets, repeat Step 9 as many times as necessary.
Step 9 is not necessary if the data target(s) and data source(s) are of the same database type. Proceed from Step 8 to Step 10.
Note: This step assumes that you are moving data to existing target tables. If you are building new target tables in the DMC, this step is not required.
Note: Authorize any users who will be using DataMigrator from the Data Management Console or Web Console. For details, see Authorizing DataMigrator Server Usage and Administration.
For detailed information about the Web Console pages used to set up DataMigrator for local data access, see Performing Server Administration Tasks and the Server Administration for UNIX, Windows, OpenVMS, IBM i, and z/OS manual.
iWay Software |