Omni-Gen™ for Supplier User's Guide > Loading Sample Data

Loading Sample Data

How to:

This section describes how to load sample data for Omni-Gen™ for Supplier.

Procedure: How to Creating a Database Connection

Before continuing, you must first create a database connection, which is used by the Data Quality (DQ) plans.

Note: The database connection you create in iWay DQS must match the database properties that you defined for the combined Omni-Gen Server (OGS) and Remediation database during the Omni-Gen™ for Supplier installation. For example, the database name must match in both areas. To review the installation, see Step 20 in How to Install Omni-Gen Server and Omni Governance Console on Windows.

To create a database connection:

  1. Right-click Databases and select New Database Connection from the context menu, as shown in the following image.

    The Edit Database Connection dialog opens, as shown in the following image.

  2. From the Database type drop-down list, select the same database you specified to use for the combined Omni-Gen Server (OGS) and Remediation database during the Omni-Gen™ for Supplier installation.
  3. Enter OmniGenDatabase as the connection name followed by the connection parameters (including your user name and password).

    All of the connection parameters (including the database name) must match the database properties you defined for the combined Omni-Gen Server (OGS) and Remediation database during the Omni-Gen™ for Supplier installation.

    If your database type is not available in the drop-down list, create it by:

    1. Clicking Manage.
    2. Selecting your database type (for example, MS SQL).
    3. Clicking Add.
  4. Click Test Connection to verify your connection parameters.

    A success message is displayed if your database is accessible and all of your connection parameters are valid, as shown in the following image.

  5. Click OK and then Finish to complete the process of adding a database connection.

Procedure: How to Accessing the Sample Data

After Omni-Gen™ for Supplier is installed, sample data, including Data Quality (DQ) plans that you can edit and run, is available in the following location: 

C:\omnigen\OmniGenData\OmniSupplier\OmniGen

The following image shows the contents of this folder.

Open iWay Data Quality Server (DQS) and verify or change the perspective in the upper-right corner to iWay DQS, as shown in the following image.

There are two ways you can access the sample data for Omni-Gen™ for Supplier:

  1. Using the File Explorer tab.

    Simply browse to the following folder in the File Explorer tab:

    C:\omnigen\OmniGenData\OmniSupplier\OmniGen

    Double-click 01_LoadRamp.plan or 02.0_LoadRampControl.plan, which opens the selected plan as a tab in your workspace area. You can modify, save, and run the sample DQ plans as required.

  2. Importing the \OmniGen folder into your workspace.
    1. Right-click DQ Projects in the File Explorer tab and select Import from the context menu.

      The Import dialog opens.

    2. Expand General, select Existing Projects into Workspace, and then click Next.

      The Import Projects pane opens.

    3. Ensure Select root directory is selected and click Browse to the right of this field.
    4. Browse to the following folder:
      C:\omnigen\OmniGenData\OmniSupplier\OmniGen
    5. Ensure the \OmniGen is selected and then click Finish.

      The project is loaded as OmniGenForSupplier2-loadRamp, which contains a subfolder called data, and two DQ plans (01_LoadRamp.plan and 02.0_LoadRampControl.plan).

    6. Double-click 01_LoadRamp.plan or 02.0_LoadRampControl.plan, which opens the selected plan as a tab in your workspace area, as shown in the following image.

      You can modify, save, and run the sample DQ plans as required.

Procedure: How to Loading the Omni-Gen Relational OnRamp Tables

You must now load the sample data to the Omni-Gen Relational OnRamp tables and execute the job to process the data using Omni-Gen.

To load the Omni-Gen Relational OnRamp:

  1. In the File Explorer tab, double-click 01_LoadRamp.plan, as shown in the following image.

    The plan appears in the workspace area, as shown in the following image.

  2. Right-click anywhere in the white space area of the opened plan and select Run from the context menu, as shown in the following image.

    Once the process is complete, a success message is displayed, as shown in the following image.

    If you encounter any errors, then you must verify if you require a schema in your SQL statement by double-clicking on each of the JDBC Writer steps and changing the Table Name as required.

    Note: Due to the maximum Oracle column name length, the load plan JDBC Writer attribute to column name mapping must be modified to account for the shortened column names.

    To process the data, continue in iWay DQS to load the sample data from the ramp into Omni-Gen.

  3. Double-click 02.0_LoadRampContol.plan, as shown in the following image.
  4. Right-click anywhere in the white space area of the opened plan and select Run from the context menu, as shown in the following image.

    You are prompted to save changes.

  5. Click Yes.

    Once the process is complete, a success message is displayed.

    During the process, you can switch to the Omni Console (Processing --> Work Orders) to verify that the work order is set to ACTIVE, as shown in the following image.

    Note: It may take some time to process the data based on the system availability. When you refresh the screen, you should see that all work orders have been processed successfully.