DataMigrator Setup

How to:

Reference:

In addition to providing a graphical interface for designing flows, the DMC can also be used to perform the major setup and administrative tasks.

Note: When you install a Windows server on a computer where you are building flows, the DMC is installed automatically. For other server types or for access to remote Windows servers, the DMC must be installed separately.


Top of page

x
Reference: WebFOCUS Environments

The DMC allows you to configure the mid-tier environment for a WebFOCUS server.


Top of page

x
Reference: Requirements for Installing the Data Management Console

To install the DMC, you need the following:


Top of page

x
Procedure: How to Install the Data Management Console
  1. Close any open programs.
  2. Insert the iWay 77 Windows CD-ROM in your CD-ROM drive. The setup program will start automatically. If it does not, run SETUP.EXE.

    The setup program begins and the InstallShield Wizard opens.

  3. In the Choose Setup Language window, select a language and click Next.

    The License Agreement opens.

  4. Click Yes to accept the terms of the license agreement.

    If you do not accept the terms of this agreement, click No to exit the InstallShield Wizard.

    If you click Yes, the Software Registration window opens, as shown in the following image.

    Software Registration window

  5. Enter your user name, company name, and license key in the corresponding fields. Your license key is found on the packing slip you received with your iWay 77 Data Management Tools CD. Click Next.

    The InstallShield Wizard displays the Select Program Folder window, as shown in the following image.

    Select Program Folder window

  6. The default Program Folder name, as it will appear in the Windows Start menu, is IWAY 77 Client. If you wish to use a different folder name, enter it here. (You can also choose a folder from the Existing Folders list.) Click Next.

    The Select the Standard Location Prompt dialog box opens, as shown in the following image.

    Select Standard Location Prompt

  7. Select a radio button for a local or network drive installation and click Next.

    The Select Directories window opens, as shown in the following image.

    Select Directories window

  8. Accept the default root and product configuration directories, or browse to directories in which you prefer to install your software. Accept the default disk designation or, if applicable, choose another disk from the list.
  9. Click Next.
  10. The Configure Remote Server window opens. When you install the software, you can set up communication to a server. When you start the software, the server you identify here appears in the Server list in the navigation pane. If necessary, you will be able to enter additional server nodes as needed, after the installation is completed. The following image shows the Configure Remote Server window.

    Configure Remote Server window

    • In the Node box, enter the name of the DataMigrator Server.
    • In the Host box, enter the computer name or IP address where the DataMigrator Server is running.
    • In the Port box, enter the Port number of the DataMigrator Server. If you used the defaults when you installed your DataMigrator Server, the HTTP Listener port number is 8117 and the TCP Listener port number is 8116.
    • Optional. If you enter a User ID and password in the Security input boxes, the iWay client saves the entries, setting security to Explicit by default. You will not be prompted for them again from the DMC.
  11. Click Next.

    Files are copied to the designated locations. Percent of progress is noted during this process.

    Informational messages indicate that setup is configuring the product based on your specifications and that the program folder and icons are being created.

  12. Optionally, you can start the DataMigrator Server and Web Console, or start the Data Management Console as soon as the installation is complete.
  13. Click Finish.

Top of page

x
Procedure: How to Launch the Data Management Console and Connect to a Server

Note: For non-Windows server installations, the DMC is under iWay Software, iWay 77 DM Client, Data Management Console. For Windows server installations, the DMC is under iWay Software, iWay 77 DataMigrator Server, Data Management Console.

  1. From the Windows Program menu, choose iWay Software, iWay 77 DM Client, Data Management Console or iWay Software, iWay 77 DataMigrator Server, Data Management Console.

    The DMC opens with the available servers listed in the navigation pane on the left.

  2. Right-click on the server you wish to use and select Connect.

    The Enter Connection Information dialog box opens, as shown in the following image.

    Enter Connection Information dialog box

  3. If your server has security enabled, enter your user ID and password in the User Name and Password fields.

    Windows requires that your user name be no longer than 32 characters.

    Note: If you select Save Userid and Password, you do not need to reenter these credentials each time you connect, and the dialog box does not appear. However, you must reenter this information when you change your password for the server. To do so, right-click the server name in the navigation tree and select Properties to reopen the Remote Server Configuration dialog box.

  4. Click Connect.

    For data retrieval and processing to occur, you must perform this connection step each time you start the DataMigrator Server and the DMC.


Top of page

x
Procedure: How to Add a Node to Identify the Server to the Data Management Console

You can set up the DMC to connect to any number of servers in your enterprise.

When the DMC opens for Windows servers, the default LOOPBACK node is listed under Servers in the navigation pane. It does not appear if you open the DMC from a non-Windows installation.

Warning: Do not delete the LOOPBACK node, since it is required for internal processing.

To add another server node in this location:

  1. Right-click Servers and select Add Server Node.

    The Server Node Configuration dialog box opens, as shown in the following image.

    Server Node Configuration dialog box

    Note: The DMC connects to server nodes using an HTTP listener port and the properties specified in the Basic tab. Applications that connect using the EDA API, like Resource Analyzer/Governor, use a TCP listener port and the properties specified in the Advanced tab.

  2. In the Node Name field, enter a name for the Server node you wish to add.
  3. In the Host field, enter the computer name or IP address where the DataMigrator Server is running. For a server running on the same PC as the client, you can enter localhost.
  4. In the HTTP Listener Port field, enter the port number of the DataMigrator Server, which is 8117 if you used the installation defaults. This port listens to all incoming requests from the DMC.
  5. Optionally, use a Secured Sockets Layer (SSL) by selecting that check box.
  6. Optionally, enter a description of the node in the Node Description field.
  7. Security is set to Explicit by default. When this setting is in effect, the User ID and password you used to log on to Windows are not passed to the server. If security is required, you must enter it either at connection time or in the Security credentials fields to the right.

    Alternatively, for servers running on Windows, you can choose IWA, which passes the Windows User ID and password to the server when a connection is made.

    For information about configuration parameters, see Viewing Properties.

  8. Click OK.

    The node is added to the Server(s) tree, as shown in the next screen, as shown in the following image:

    Server tree

    You can test the connection between the DMC and the DataMigrator Server you have added.


Top of page

x
Procedure: How to Test the Server

Before you proceed, it is recommended to test the connection between the DMC and the DataMigrator Server.

To ensure that the server is running and that you are able to retrieve sample data:

  1. In the DMC, right-click the server name and select Test Server.

    If you can connect to the server, the Input Query dialog box opens, as shown in the following image. The default query is select CAR from car.

    Input Query dialog box

    You can change the test query, but the default, based on sample data delivered with your software, is sufficient to verify that you can retrieve data.

  2. Click Test.

    The answer set shown in the following image appears in the right pane of the DMC, behind the Input Query dialog box.

    Query answer set

  3. Click Close to close the Input Query dialog box and examine the test output.

iWay Software