Configuring iWay Service Manager to Support iWay Data Profiler Automation

How to:

To configure iWay Server Manager to support iWay Data Profiler automation:

  1. Navigate to the following directory:
    <idp_home>\idpweb\WEB-INF\lib\

    where:

    <idp_home>

    Is the location on your system where iWay Data Profiler is installed.

  2. Copy the following .jar files:
  3. Paste the .jar files to the following directory:
    <ism_home>\lib\

    where:

    <ism_home>

    Is the location on your system where iWay Service Manager is installed.

    Note: If the spring.jar and ibatis jar files already exist in your <ism_home>\lib directory, overwrite these versions.

  4. Start iWay Service Manager and create a Data Provider that points to the database that you are currently using for iWay Data Profiler.
Top of page
x
Procedure: How to Configure a Data Provider

To configure a Data Provider:

  1. Click the Data Provider link from the Providers section of the Server page.
  2. In the JDBC section, click New.
  3. Supply the following parameters:
    • Driver Class. The JDBC driver class can be a predefined database or you can enter your own driver class. Provide the Driver Class for the iDP database here.
    • Connection URL. Provides the targeted database URL that has been connected to your iDP
    • User. Provides a valid user name with respect to the Connection URL and Driver Class you have provided.
    • Password. Provides a valid password with respect to the Connection URL, Driver Class and User you have provided.
    • Initial Pool Size, Maximum Number of Idle Connections, and Maximum Number of Connections properties need to be set to numeric values.

  4. Click Add.
Top of page
x
Procedure: How to Configure a Listener for a Data Quality Profile

A file listener needs to point to the location from which it will read the .xml file generated by DQS for uploading into iWay Data Profiler.

A listener is a component that receives input for a channel from a configured endpoint.

  1. Click the Listener link from the Components section of the Registry page.
  2. On the Listeners page, click the Add button.
  3. Select File from the Listener Type drop down list:

    The configuration parameters pane for the File listener opens.

  4. Provide values for the following parameters:
    • Input Path: Refers to the location from which it will read the .xml.
    • Destination: Directory into which output files are stored.
    • Suffix In Filter: Should only be set to XML.
    • Accepts non-XML (flat) only: Selects the option as false, because input type is the XML file.

  5. Click Next.
  6. Provide values in the Name and Description fields and click Finish.
Top of page
x
Procedure: How to Configure a Listener for Data Quality Metrics

File listener needs to point to the location from which it will read the .txt file generated by DQS for uploading into iWay Data Profiler.

A listener is a component that receives input for a channel from a configured endpoint.

  1. Click the Listener link from the Components section of the Registry page.
  2. On the Listeners page, click the Add button.
  3. Select File from the Listener Type drop down list.

    The configuration parameters pane for the FILE listener opens.

  4. Supply the following parameters:
    • Input Path: Refers to the location from which it will read the .txt file.
    • Destination: Directory into which output files are stored.
    • Suffix In Filter: Should only be set to TXT.
    • Accepts non-XML (flat) only: Selects the option as true, because input type is the TXT file.

  5. Click Next.
  6. Provide values in the Name and Description fields and click Finish.
Top of page
x
Procedure: How to Configure a Listener for Data Quality Metrics

File listener needs to point to the location from which it will read the .txt file generated by DQS for uploading into iWay Data Profiler.

A listener is a component that receives input for a channel from a configured endpoint.

  1. Click the Listener link from the Components section of the Registry page.
  2. On the Listeners page, click the Add button.
  3. Select File from the Listener Type drop down list.

    The configuration parameters pane for the FILE listener opens.

  4. Supply the following parameters:
    • Input Path. Refers to the location from which it will read the .txt file.
    • Destination. Directory into which output files are stored.
    • Suffix In Filter. Should only be set to TXT.
    • Accepts non-XML (flat) only. Selects the option as true, because input type is the TXT file.

  5. Click Next.
  6. Provide values in the Name and Description fields and click Finish.
Top of page
x
Procedure: How to Configure the Data Profiler Service (XDDataProfilerAgent)

The Data Profiler Service (XDDataProfilerAgent) is a service that has been developed for iWay Data Profiler for automation purposes.

  1. Click the Services link from the Components section of the Registry page.
  2. On the Services page, click the Add button.
  3. From the Service Type drop-down list, select Data Profiler Agent {com.ibi.agents.XDDataProfilerAgent}.

    The Data Profiler Agent service pane opens, as shown in the following image.

    Supply the following Configuration Parameters:

    • Type: Select the DQS Profiling Output option for uploading a Data Quality Profile (XML).

      Note: Select the DQS Data Quality Metrics Output option for uploading a Metrics TXT).

    • DB Provider Name: Provide the data provider name already defined in iSM.

    Supply the following Data Profiler Credentials:

    • Data Profiler User Credentials: Select Credentials specified below from the drop-down list.
    • Data Profile Username: Use the iDP user name under which the Data Quality Profile/Data Quality Metrics will be inserted.
    • Data Profiler Password: Use the iDP password under which the Data Quality Profile/Data Quality Metrics will be inserted.

    Supply the following drill-through properties:

    • Allow DrillThrough: Select the option according to your requirement, that is, Data Quality Profile without drill-through functionality or with the users who have permission to upload drill-through Data Profiles or through the SREG value from the process flow.

      Note: For Data Quality Metrics, this value is not required. Leave the default selection as Do not update DrillThrough.

    Supply the following RollUp Properties:

    • Allow RollUp: Select the option according to your requirement, that is, Data Profile without rollups functionality or with the users who have permission to upload Data Profiles with rollup information or through the SREG value from the process flow.

      Note: For Data Quality Metrics, this value is not required. Leave the default selection as Do not update RollUp.

  4. Click Next.
  5. Provide values in the Name and Description fields and click Finish.
iWay Software