How to: |
This section describes how to configure iWay Data Profiler on a Windows system with the following configuration:
To create base tables in Oracle 11g using Oracle Enterprise Manager:
The workspace for the connected server is displayed, as shown in the following image.
<dphome>\idpweb\sql\Oracle_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.
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.
<dphome>\idpweb\WEB-INF\lib\ojdbc6.jar
where:
Is the path on the file system where iWay Data Profiler is installed.
The Java Services status changes to active.
The Web Console opens.
Note: The WebFOCUS Reporting Server must be running in order to open the Web Console.
The Add Oracle 11g to Configuration pane opens, as shown in the following image.
Parameter |
Description |
---|---|
Connection Name |
idp The logical name used to identify this particular set of connection attributes. There is no default connection name. You must provide a value. |
TNS name |
idpv4 Service (TNS) name used as a connect descriptor to an Oracle database server across the network. It must point to a valid entry in the tnsnames file. Connection to a local database server can be entered as <local>. Note that <local> may not have a match in the tnsnames.ora file. |
Security |
Explicit There are three methods by which a user can be authenticated when connecting to an Oracle database server:
|
User |
The user name for Oracle 11g. This is the primary authorization ID. |
Password |
The password for Oracle 11g. The password is associated with the primary authorization ID. |
Select profile |
Select a profile from the drop-down list to indicate the level of profile in which to store the CONNECTION_ATTRIBUTES command. The global profile, edasprof, is the default. |
A message is displayed indicating that the connection is successfully added to the configuration.
The Oracle Adapter Test Completed Successfully pane is displayed, as shown in the following image.
The Web Console opens.
Note: The WebFOCUS Reporting Server must be running in order to open the Web Console.
Note: Select the synonym names individually from TBL_BUSINESS_ANALYSIS to TBL_User. Do not click the Select All button, which selects all of the check boxes in the table. It is highly unadvisable to perform this operation.
A message indicating that the synonyms are created successfully is displayed with a list of all of the created synonyms, as shown in the following image.
Values for the selected table is displayed, are shown in the following image.
iWay Data Profiler (iDP) supports integration with Oracle Real Application Clusters (RAC). Oracle RAC is a database clustering option that allows more than one instance to access an Oracle database.
A typical Oracle installation consists of a single Oracle instance that accesses a database on the same computer system. In contrast, RAC allows multiple instances on different computer systems (nodes in a cluster) to access the same database files simultaneously.
This section describes how to configure access to Oracle RAC databases using a System ID (SID).
Note: The configuration steps in this section should be used only if you need to change the Oracle SID value after iDP has already been installed. By default, the Oracle SID value to enable access for Oracle RAC can be specified during the initial iDP installation.
http://hostname:port/idpweb/manager
where:
Is the name of the application server system that is hosting the iDP application.
Is the port number where the application server is listening.
Is the specific name of the XML file that was created for iDP, as described in Integrating iWay Data Profiler With the Web and Application Server.
Note: The idpweb XML file can have a different name when more than one instance of iDP is installed to coexist with an earlier version of iDP.
You can also access iWay Data Profiler - Server Manager console, through the Server Manager link/icon on the iWay Data Profiler logon page.
After you have successfully logged into the iWay Data Profiler - Server Manager console, the following page is displayed.
The database properties for iDP are listed, as shown in the following image.
The drill-through and plan properties for iDP are listed, as shown in the following image.
The url= and dqurl= values of the Oracle connection string in the dpcontext.properties file are updated with the Oracle SID value that you specified (for example, ora1021), as shown in the following image.
The dpcontext.properties file is located in the following folder by default:
C:\ibi\apps\idpweb\WEB-INF\classes
You have now provided your iDP application access to a Oracle RAC using a SID value.
iWay Data Profiler (iDP) supports integration with Oracle Real Application Clusters (RAC). Oracle RAC is a database clustering option that allows more than one instance to access an Oracle database.
A typical Oracle installation consists of a single Oracle instance that accesses a database on the same computer system. In contrast, RAC allows multiple instances on different computer systems (nodes in a cluster) to access the same database files simultaneously.
To configure access to Oracle RAC databases using a Service Name (instead of an Oracle SID):
C:\ibi\apps\idpweb\WEB-INF\classes
For example:
jdbc:oracle:thin:@orac1:1521/ora102
In this example, ora102 is the Service Name of the Oracle RAC database.
You have now provided your iDP application access to a Oracle RAC using a Service Name value.
iWay Software |