In this section:
How to: |
This section describes how to configure iWay Data Profiler on a Windows system with the following configuration:
To create base tables in Microsoft SQL Server using SQL Server Management Studio:
The workspace for the connected server is displayed, as shown in the following image.
<dphome>\idpweb\sql\MSSQL_IDP.sql
where:
Is the path on the file system where iWay Data Profiler is installed.
The script is executed and the tables are generated, as shown in the following image.
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.
The Web Console opens.
Note: The WebFOCUS Reporting Server must be running in order to open the Web Console.
The Java Services Configuration pane opens, as shown in the following image.
<dphome>\idpweb\WEB-INF\lib\sqljdbc.jar
<dphome>\idpweb\WEB-INF\lib\sqljdbc4.jar
where:
Is the path on the file system where iWay Data Profiler is installed.
The Java Services status changes to active.
This section describes how to create MS SQL JDBC connections for iWay Data Profiler.
The Web Console opens.
Note: The WebFOCUS Reporting Server must be running in order to open the Web Console.
The Add MS SQL Server 2005 to Configuration pane opens, as shown in the following image.
A message is displayed indicating that the Microsoft SQL Server was successfully added to the configuration.
The Microsoft SQL Server Adapter Test Completed Successfully message is displayed, as shown in the following image.
The following procedure describes how to create synonyms for iWay Data Profiler.
The Web Console opens.
Note: The WebFOCUS Reporting Server must be running in order to open the Web Console.
Note: Select the database name which was provided for the Schema at the time of installation.
Note: Clicking the Select All button selects all check boxes in the table.
A list of all the created synonyms is displayed, as shown in the following image.
The following section describes how to test the created synonyms.
iWay Software |