Configuring iWay Data Profiler With MySQL Server 5.5

In this section:

This section describes how to configure iWay Data Profiler on a Windows system with the following configuration:
Top of page
x
Creating the Base Tables

This section describes how tables are created and iWay Data Profiler demo files are inserted in the database using the script included in the idpweb folder. Tables can be created using either the Command Line Interface or the Graphical User Interface.
x
Procedure: How to Create Tables and Insert iWay Data Profiler Demo Files Using the Command Line Interface
  1. From the Windows Start menu, select All Programs, MySQL, MySQL Server 5.5, and then MySQL Command Line Client.
  2. Enter the database password and click Enter.

    The MySQL prompt is displayed.

  3. Enter the following command: 
    mysql>\. <dphome>\idpweb\sql\mysql_idp.sql

    where:

    <dphome>

    Is the path on the file system where iWay Data Profiler is installed.

    The iWay Data Profiler tables are now created in the MySQL database.
x
Procedure: How to Create Tables and Insert iWay Data Profiler Demo Files Using the Graphical User Interface
  1. From the Windows Start menu, select All Programs, MySQL, and then MySQL Query Browser.
  2. Enter the user name and password, and click Enter.
  3. From the File menu, select Open Script, as shown in the following image.

    The Open Script dialog box is displayed.

  4. Navigate to the following directory: 
    <dphome>\idpweb\sql\mysql_idp.sql

    where:

    <dphome>

    Is the path on the file system where iWay Data Profiler is installed.

  5. Click Execute to run the script.

    The iWay Data Profiler tables are now created in the MySQL database.
Top of page
x
Configuring Java Services

You must start the client workspace and ensure that the DEFAULT listener is available before configuring Java Services. For more information, see the WebFOCUS Installation and Configuration documentation.
x
Procedure: How to Configure Java Services
  1. From the Windows Start menu, select All Programs, Information Builders, WebFOCUS 80 Server, then click Web Console.

    The Web Console opens.

    Note: The WebFOCUS Reporting Server must be running in order to open the Web Console.

  2. From the Workspace, navigate to Configuration/Monitor, expand Java Services, double-click DEFAULT, and ensure that it is active.
  3. In the left pane, expand Java Services, right-click DEFAULT, and select Properties from the context menu.

    The Java Services Configuration pane opens, as shown in the following image.

  4. Click the Class path tab.
  5. In the right pane, set the IBI_CLASSPATH to: 
    <dphome>\idpweb\WEB-INF\lib\mysql-connector-java-5.1.12-bin.jar

    where:

    <dphome>

    Is the path on the file system where iWay Data Profiler is installed.

  6. Click Save and Restart the Java Services.

    The Java Services status changes to active.
Top of page
x
Creating MySQL JDBC Connections for iWay Data Profiler

This section describes how to create MySQL JDBC connections for iWay Data Profiler.
x
Procedure: How to Create MySQL JDBC Connections for iWay Data Profiler
  1. From the Windows Start menu, select All Programs, Information Builders, WebFOCUS 80 Server, then click Web Console.

    The Web Console opens.

    Note: The WebFOCUS Reporting Server must be running in order to open the Web Console.

  2. Click Adapters in the menu bar.
  3. In the left pane, expand Adapters, Available, SQL, MySQL, and select MySQL (Unicode Optional).
  4. In the left pane, right-click MySQL (Unicode Optional), and select Configure from the context menu.

    The Add MySQL to Configuration pane opens, as shown in the following image.

  5. Provide the following values for the connection parameters:
    • Connection Name: idp
    • URL: For example, jdbc: mysql://localhost:3306/idp_data
    • Security: Explicit
    • User: The user name for MySQL.
    • Password: The password for MySQL.
  6. Click Configure.

    A message is displayed indicating that MySQL was successfully added to the configuration.

  7. To test the connection, right-click the idp connection node under the MySQL folder and select Test from the context menu.

    The MySQL Adapter Test Completed Successfully message is displayed, as shown in the following image.
Top of page
x
Creating Synonyms for iWay Data Profiler

The following procedure describes how to create synonyms for iWay Data Profiler.
x
Procedure: How to Create Synonyms for iWay Data Profiler
  1. Right-click the Connection node idp and select Create Synonym from the context menu.
  2. Select the Tables and Views check box.
  3. Click Next in the right pane.
  4. Click the ellipsis (...) button in the Application field and select idp in the Select Application window, as shown in the following image.

  5. Click OK.
  6. Check the Overwrite existing synonyms check box and click the Select All button.

    Note: Clicking the Select All button selects all of the check boxes in the table.

  7. Click Create synonym, as shown in the following image.

    A list of all the created synonyms is displayed, as shown in the following image.
Top of page
x
Testing Created Synonyms

The following section describes how to test the created synonyms.
x
Procedure: How to Test Created Synonyms
  1. Click the Applications tab from the menu bar.
  2. Under Application Directories in the left pane, expand idp.
  3. Right-click any available table in the left pane and select Sample Data from the context menu to view the values in the table, as shown in the following image.

iWay Software