Analyzer preferences let you configure some general environment settings, and include the following:
Analyzer general settings govern high-level operation of the Analyzer environment. To access these settings, select
> , then select in the left navigation area.Table 2-1 Analyzer Preferences
Setting |
Description |
---|---|
|
When this option is selected, Designer closes all currently open editors when switching perspectives. For example, when switching from Analyzer to Designer, all Analyzer editors close automatically. |
The Connections preferences page lets you manage the Java* Libraries that Analyzer needs to communicate with different applications. You can add and remove Java libraries (typically .jar files) from this page.
The Data Browser preferences page lets you manage how the Data Browser displays the data records in a data set instance. To access these settings, select
> , then select > in the left navigation area.Table 2-2 Analyzer Preferences - Data Browser
Setting |
Description |
---|---|
|
Enables/disables displaying a warning dialog box about having more than 12 attributes with multiple values in a data set definition. Use this dialog box to limit the attributes displayed in the Data Browser to improve performance during data inspection and analysis. |
|
Specifies the number of records to display on a page in the Data Browser. |
Analyzer database settings configure the database that Analyzer uses to organize and store its data. To access these settings, select
> , then select > in the left navigation area.You can also select the
icon in the Data Set Instances view.Table 2-3 Analyzer Preferences - Database Settings
Setting |
Description |
---|---|
|
Specifies the database alias that Analyzer uses. |
|
Opens the New Alias dialog box so you can configure a new database alias. The new alias requests the same information that is displayed in the Database Settings page. |
|
Deletes the currently selected database alias. However, you must have at least one database alias for Analyzer to run. |
|
Specifies the driver that Analyzer uses to access the database. Analyzer 1.1 supports either an internal HSQLDB, or an external MySQL* database. |
|
Enables SSL connections between Analyzer and an external MySQL database used as the Analyzer database. To use SSL, the MySQL JDBC* library must be version 5.1.6 or higher. For example, mysql-connector-java-5.1.6-bin.jar. NOTE:MySQL must be configured to use SSL before enabling |
|
Specifies the JDBC URL where you can access the database. When you are using the internal HSQLDB, this field is not configurable. |
|
Specifies the database name. |
|
Saves the password in a local system. If it is a local database (HSQLDB), the password is by default stored locally. If it is an external database (MYSQL), user can select/deselect this option. |
|
Specifies a valid username with which Analyzer can access the database. |
|
Specifies the database access password for the specified user. |
|
Specifies the path to the database’s JDBC libraries. You must provide a classpath if you are using an external database with Analyzer. |
|
The class name for the driver. |
|
Tests the database connection by using the specified database parameters. |
|
Resets the database settings to Analyzer’s default (internal database) configuration. |
Matching settings define the default configuration for Analyzer’s matching analysis. To access these settings, select
> , then select > in the left navigation area.Table 2-4 Matching Preferences
Setting |
Description |
---|---|
|
Specifies the uniqueness threshold that a matching key/data set combination must achieve before Analyzer can run a matching analysis. Analyzer supports values between 95 and 100 percent. |
Reporting settings define the default configuration for the various reports you can generate from Analyzer. These are global settings that apply to all of your Analyzer projects. To access these settings, select
> , then select > in the left navigation area.The Reporting settings page includes four tabs, one for each type of report you can generate. For more information about Analyzer reports, see Section 3.11, Auditing and Reporting.
The Data Browser report settings lets you specify the following default settings.
Table 2-5 Data Browser Report Settings
Setting |
Description |
---|---|
|
Specifies a name for the Data Browser report you are generating. The default title is Data Browser Report. |
|
Specifies optional details describing the report. |
|
Displays the report suitable for landscape printing (11” x 8.5” rather than 8.5” x 11”). |
|
Allows cell data to wrap around within the report column. If you deselect this option, data that exceeds the width of the report column is truncated. |
|
Specifies that the report should include icon indicators for added, modified, and deleted data cells. |
|
Specifies that the report should indicate data cells that failed the analysis in red and with a failure icon. |
The Analysis report settings lets you specify the following default settings.
Table 2-6 Analysis Report Settings
Setting |
Description |
---|---|
|
Specifies a name for the Analysis report you are generating. The default title is Analysis Report. |
|
Specifies optional details describing the report. |
|
Displays the report suitable for landscape printing (11” x 8.5” rather than 8.5” x 11”). |
|
Allows cell data to wrap around within the report column. If you deselect this option, data that exceeds the width of the report column is truncated. |
|
Specifies that the report should include a section that summarizes the analysis results across all analyzed data sets. This option is available only when the analysis results include data from multiple data sets. |
|
Displays a graphical representation of the results of each metric in the analysis. |
|
For each metric in the analysis, displays a list of the failed records. |
|
Specifies a maximum number of records to display that failed the analysis. This setting is active only when is selected. |
The Uniqueness report settings lets you specify the following default settings.
Table 2-7 Uniqueness Report Settings
Setting |
Description |
---|---|
|
Specifies a name for the Uniqueness report you are generating. The default title is Uniqueness Report. |
|
Specifies optional details describing the report. |
|
Displays the report suitable for landscape printing (11” x 8.5” rather than 8.5” x 11”). |
|
Allows cell data to wrap around within the report column. If you deselect this option, data that exceeds the width of the report column is truncated. |
|
Displays a statistical summary of the report data, including number of records, duplicate count, a uniqueness measure, and the total number of duplicate records. |
|
Displays a graphical (bar graph) representation of the report data. |
|
Displays a list of the duplicate values along with the number of times the value occurs in the data set instance. |
|
Specifies the maximum number of duplicate values to display. This setting is active only when is selected. |
The Matching report settings lets you specify the following default settings.
Table 2-8 Matching Report Settings
Setting |
Description |
---|---|
|
Specifies a name for the Matching Value report you are generating. The default title is Matching Report. |
|
Specifies optional details describing the report. |
|
Displays the report suitable for landscape printing (11” x 8.5” rather than 8.5” x 11”). |
|
Allows cell data to wrap around within the report column. If you deselect this option, data that exceeds the width of the report column is truncated. |
|
Displays a statistical summary of the report data, including number of records, duplicate count, a uniqueness measure, and the total number of duplicate records. |
|
Displays a graphical (bar graph) representation of the report data. |
|
Displays a list of unmatched values from the matching analysis. |
|
Specifies the maximum number of unmatched values to display. This setting is active only when is selected. |
|
Displays a list of matched values from the matching analysis. |
|
Specifies the maximum number of matched values to display. This setting is active only when is selected. |