Post-Installation Configuration Tasks

In this section:

After you have successfully installed iWay Data Profiler (iDP), you must perform the following post-installation configuration tasks before you can begin using iDP:

  1. Copy the ojdbc7.jar database driver file to the iDP installation.

    For more information, see Copying the ojdbc7.jar Database Driver File to the iDP Installation.

  2. Modify the webconfig.xml file to point to the Oracle RAC Service Name.

    For more information, see Modifying the webconfig.xml File to Point to the Oracle RAC Service Name.

  3. Modify the dbcontext.properties file to point to the Oracle RAC Service Name.

    For more information, see Modifying the dbcontext.properties File to Point to the Oracle RAC Service Name.

  4. Modify the edastart file to define the ORACLE_HOME variable.

    For more information, see Modifying the edastart file to Define the ORACLE_HOME Variable.

  5. Start the WebFOCUS Reporting Server.

    For more information, see Starting the WebFOCUS Reporting Server.

  6. Add the iWay Data Profiler Server (idp) and iWay Data Profiler Client (idpweb) to the WebFOCUS Application Path.

    For more information, see Adding the iWay Data Profiler Server (idp) and iWay Data Profiler Client (idpweb) to the WebFOCUS Application Path.

  7. Configure a new JDBC connection to the Oracle adapter.

    For more information, see How to Create the JDBC Connection.

  8. Create Synonyms for iDP.

    For more information, see How to Create Synonyms for iWay Data Profiler.

  9. Create iDP tables for the idp_data repository.
  10. Load data into the iDP tables (idp_data repository).
  11. Configure iDP logger settings.

    For more information, see Configuring iDP Logger Settings.
Top of page
x
Copying the ojdbc7.jar Database Driver File to the iDP Installation
  1. Copy the ojdbc7.jar file to the following directory:
    <idp_home>/idpweb/WEB-INF/lib/

    where:

    <idp_home>

    Is the root directory where iDP Client (idpweb) was installed. For example:

    /home/iwayprs/ibi/apps
  2. Restart the web and application server where iDP is currently deployed (for example, Apache Tomcat).
Top of page
x
Modifying the webconfig.xml File to Point to the Oracle RAC Service Name
  1. Navigate to the following directory:
    <wf_client_home>/ibi/WebFOCUS80/config

    where:

    <wf_client_home>

    Is the root directory where the WebFOCUS Client was installed. For example:

    /home/iwayprs
  2. Edit the webconfig.xml file to modify the Oracle connection string for the IBI_Repos_DB_URL and IBI_Magnify_Repos_DB_URL parameters.
  3. Instead of @host_name:port_number:SID in the Oracle connection string, specify @host_name:port_number/service_name .

    For example:

    <context-param>
   <param-name>IBI_Repos_DB_URL</param-name>
   <param-value>jdbc:oracle:thin:@iwracosb:1521/ora102</param-value>
   <param-properties></param-properties>
   <display-order>020</display-order>
   <category-name>Repository</category-name>
</context-param>
<context-param>
   <param-name>IBI_Magnify_Repos_DB_URL</param-name>
   <param-value>jdbc:oracle:thin:@iwracosb:1521/ora102</param-value>
   <param-properties></param-properties>
   <category-name>Magnify</category-name>
   <licenses>MAGNIFY</licenses>
</context-param>

    In this example, ora102 is the Service Name of the Oracle RAC database.

  4. Save the webconfig.xml file.
  5. Restart the web and application server where iDP is currently deployed (for example, Apache Tomcat).
Top of page
x
Modifying the dbcontext.properties File to Point to the Oracle RAC Service Name
  1. Navigate to the following directory:
    <idp_home>/idpweb/WEB-INF/classes

    where:

    <idp_home>

    Is the root directory where iDP Client (idpweb) was installed. For example:

    /home/iwayprs/ibi/apps
  2. Edit the dpcontext.properties file to modify the Oracle connection string for the url and dqurl parameters.
  3. Instead of @host_name:port_number:SID in the Oracle connection string, specify @host_name:port_number/service_name .

    For example:

    url=jdbc:oracle:thin:@orac1:1521/ora102
    dqurl=jdbc:oracle:thin:@orac1:1521/ora102

    In this example, ora102 is the Service Name of the Oracle RAC database.

  4. Save the dpcontext.properties file.
  5. Restart the web and application server where iDP is currently deployed (for example, Apache Tomcat).
Top of page
x
Modifying the edastart file to Define the ORACLE_HOME Variable
  1. Navigate to the following directory:
    <wf_srv_home>/ibi/srv80/wfs/bin

    where:

    <wf_srv_home>

    Is the root directory where the WebFOCUS Reporting Server was installed. For example:

    /home/iwayprs
  2. Edit the edastart file to define the ORACLE_HOME variable.

    For example:

    export ORACLE_HOME=/home/ora112cl/instantclient_11_2
export TNS_ADMIN=$ORACLE_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME
  3. Save the edastart file.
  4. Restart the web and application server where iDP is currently deployed (for example, Apache Tomcat).
Top of page
x
Starting the WebFOCUS Reporting Server
  1. Navigate to the following directory on the command line:
    <wf_srv_home>/ibi/srv80/wfs/bin

    where:

    <wf_srv_home>

    Is the root directory where the WebFOCUS Reporting Server was installed. For example:

    /home/iwayprs
  2. Execute the edastart file as follows to run the process in the background:
    iwayprse@iwsuse11:~/ibi/srv80/wfs/bin>./edastart -start
Top of page
x
Adding the iWay Data Profiler Server (idp) and iWay Data Profiler Client (idpweb) to the WebFOCUS Application Path
  1. Ensure that the WebFOCUS Reporting Server is started.
  2. Enter the following URL in a browser to access the WebFOCUS Reporting Server Web Console:
    http://host_name:port

    where:

    host_name

    Is the name of the system where the WebFOCUS Reporting Server is installed and being hosted.

    port

    Is the port number where the WebFOCUS Reporting Server is listening. The default port is 8121.

    The WebFOCUS Reporting Server Web Console opens.

  3. Click Application Path on the ribbon.

    The Application Path pane is displayed, as shown in the following image.

  4. Add the iWay Data Profiler Server (idp) and iWay Data Profiler Client (idpweb) installation paths to the Application Path.
    <root>/ibi/apps/idp
    <root>/ibi/apps/idpweb

    where:

    <root>

    Is the root directory of the user account that was used to execute the iDP installation. For example:

    /home/iwayprs
  5. Ensure that these two paths appear first on the list. You can select each row and use the arrows to the right of the Application Path pane to reorder accordingly.
  6. Click Save.
Top of page
x
Configuring iDP Logger Settings

This section describes how to configure iDP logger settings for your environment.

  1. Log on to the iWay Data Profiler - Server Manager console using the following URL:
    http://hostname:port/idpweb/manager
  2. In the left console pane of the Data Profile Configuration menu, select Logger Settings.

    The Logger Settings pane opens, as shown in the following image.

    The Logger Path parameter specifies the path and name of the log file that will be generated for iDP

  3. Change the default Logger Path parameter value (C:\IDP.log) to point to a path and file name according to your requirements.

    For more information on the iDP logger settings, including available trace levels, see Configuring Logger Settings

  4. Click Save.
  5. Restart the application server for the changes you have made to take effect.
iWay Software