Modifying project analysis database settings

You can customize the analysis database settings at the project level. When you modify the project-level analysis database settings, you override the default system settings. All new analysis jobs that are created in the project inherit the new settings.

1. Open an InfoSphere Information Analyzer project.
2. On the Overview navigator menu in the console, select Project Properties.
3. Select the Analysis Database tab.
4. Select the database to use for the analysis database in the Database Type field.
5. Confirm the host computer where the analysis database exists in the Host Name field.
6. Confirm the database name in the Database Name field.
7. Specify the port number to connect to the analysis database in the Port field.

   Table 1. Default port numbers for connecting to the analysis database

   Database type	Default port number
   DB2® database	50000
   Microsoft SQL Server	1433
   Oracle	1521

8. Enter the user ID and password to connect to the analysis database.
9. Verify that the default driver for the selected database type is automatically entered into the Database Driver field. If you use a different driver, such as ODBC DataConnect, you must specify the driver that you require.
   1. Click Restore System Settings to restore the settings at the InfoSphere Information Analyzer system level.
   2. Click Validate Client Connection to verify that the connection is valid.
10. If you do not use the native database drivers to connect to the analysis database, specify the URL for your driver in the following format:
    connType:databaseDriver://hostName:portNumber;databaseName=databaseName Where:

    connType

    The type of connection, for example JDBC or ODBC.

    databaseDriver

    The database driver to connect to the analysis database.

    hostName

    The host name of the computer where the analysis database is installed.

    portNumber

    The port number to connect to the analysis database.

    databaseName

    The name of the analysis database.

11. Select the DSN name for the InfoSphere Information Analyzer analysis database in the Analysis ODBC DSN field.
    Note: The DSN represents the specific DSN that is configured on the computer that runs InfoSphere DataStage® where the analysis operations will run. That DSN must be set up and configured to access the InfoSphere Information Analyzer analysis database.
    1. Click Restore System Settings to restore the settings at the InfoSphere Information Analyzer system level.
    2. Click Validate Engine Connection to verify that the connection is valid.
12. Optional: To use data rule output tables as data sources, select Include in Project Data Sources and select a host name and data source name. The analysis database must be associated with a data source to enable the automatic importing and registration of the reference tables. Data rule output tables are a type of reference table. The Host Name and Data Source Name fields contain the hosts and data stores that match the DSN that is specified for the IADB.
13. Click Save All after you specify your analysis database settings.