IBM Netezza

You need to set up multiple configuration properties when you create a resource to extract metadata from IBM Netezza databases.

Objects Extracted

Enterprise Data Catalog extracts metadata of the following objects from an IBM Netezza resource:

•Column

•Database

•Data type

•Distribution key

•Distribution key column

•Expression

•External table

•Foreign key

•Materialized view

•Primary key

•Schema

•Sequence

•Stored Procedure

•Synonym

•Table

•Unique key constraint

•View

Permissions to Configure the Resource

Configure the LIST privilege for the Netezza user to extract metadata from a Netezza database. The LIST privilege grants the Netezza user access to all database objects in the Netezza database through Enterprise Data Catalog. If required, you can assign database permissions to limit access to individual database objects.

Configure SELECT permissions for the Netezza user account on the following system views:

•_V_TABLE_DIST_MAP

•_V_TABLE

•_V_DATABASE

•_v_relation_keydata

•_v_relation_column

•_v_view

•_v_synonym

•_v_datatype

•_v_sequence

Prerequisites

Download the JDBC driver JAR file from the Internet and copy the files to the NetezzaScanner directory in the <INFA_HOME>/services/CatalogService/ScannerJars/externalDependencies directory. You need not restart the Catalog Service.

Alternatively, you can perform the following steps to complete the prerequisites:

1. Download the JDBC driver file and copy the file to the <INFA_HOME>/services/CatalogService/ScannerBinaries directory.

2. Open the <INFA_HOME>/services/CatalogService/ScannerBinaries/CustomDeployer/scannerDeployer.xml file and add the following lines in the file:

<ExecutionContextProperty>
<ExecutionContextProperty isLocationProperty="true" dependencyToUnpack="netezza.zip">
<PropertyName>NetezzaScanner_DriverLocation</PropertyName>
<PropertyValue>scanner_agents/netezza/Drivers</PropertyValue>
</ExecutionContextProperty>

3. Save the scannerDeployer.xml file.

4. Restart the Catalog Service.

Resource Connection Properties

The following table describes the connection properties for the IBM Netezza resource type:

Property	Description
Host	Host name or IP address of the machine where the database management server runs.
Port	Port number for the Netezza database.
User	Name of the user account used to connect to the Netezza database.
Password	Password for the user account used to connect to the Netezza database.
Database	ODBC data source connect string for a Netezza database. Enter the data source name of the Netezza DSN if you created one.

The following table describes the Additional and Advanced properties for source metadata settings on the Metadata Load Settings tab:

Property	Description
Enable Source Metadata	Select to extract metadata from the data source.
Schema	Specifies a list of semicolon-separated database schema.
Source Metadata Filter	You can include or exclude tables and views from the resource run. Use semicolons (;) to separate the table names and view names. For more information about the filter field, see Source Metadata and Data Profile Filter.
Case Sensitive	Specifies that the resource is configured for case insensitivity. Select one of the following values: - True. Select this check box to specify that the resource is configured as case sensitive. - False. Clear this check box to specify that the resource is configured as case insensitive. The default value is False.
Memory	Specify the memory value required to run a scanner job. Specify one of the following memory values: - Low - Medium - High Note: For more information about the memory values, see the Tuning Enterprise Data Catalog Performance article on How To-Library Articles tab in the Informatica Doc Portal
JVM Options	JVM parameters that you can set to configure scanner container. Use the following arguments to configure the parameters: - -Dscannerloglevel=<DEBUG/INFO/ERROR>. Changes the log level of scanner to values, such as DEBUG, ERROR, or INFO. Default value is INFO. - -Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value should be a number. - -Dscanner.yarn.app.environment=<key=value>. Key pair value that you need to set in the Yarn environment. Use a comma to separate the key pair value. - -Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when pmem is enabled. Default value is 1. - -DskipExternalDatabaseObjects=true. Excludes all external objects such as schema, table, database and view.
Track Data Source Changes	View metadata source change notifications in Enterprise Data Catalog.

You can enable data discovery for an IBM Netezza resource. For more information about enabling data discovery, see the Enable Data Discovery topic.

You can enable composite data domain discovery for an IBM Netezza resource. For more information about enabling composite data domain discovery, see the Composite Data Domain Discovery topic.