In this Article:

• Overview
• Pre-Requisites
• Detailed Steps
  • Step 1: Add Netezza as a Source
  • Step 2: Environment Assignment
  • Step 3: Configure Connection
  • Step 4: Save Connection Information
  • Step 5: Scan the Data Source

Overview:

This article outlines the steps required to configure Netezza as a source in DvSum Data Intelligence (DI). It details the process of adding and authenticating the Netezza source, as well as running scans to retrieve data.

Pre-Requisites

1. Netezza Performance Server Deployment:
   • IBM Cloud or On-Premises
2. Server Status:
   • Netezza server must be operational
3. SAWS Version:
   • 1.2.9 or above
4. Required Permissions for System Tables:
   • _V_TABLES
   • _V_RELATION_COLUMN
   • _V_DATATYPE
   • _V_RELATION_KEYDATA
   • _V_DATSBASE
   • _V_SCHEMA

Enabling General Query Log for MySQL
Before configuring MySQL as a source, ensure that the general query log is enabled for your MySQL server. This is essential for tracking data lineage and obtaining insights into usage patterns. For more information, refer to the Enabling General Query Log for Data Sources article.

Detailed Steps

Step-by-Step Configuration

Step 1: Add Netezza as a Source

• Navigate to Administration > Data Sources > ⊕ Add Source.
• Select Netezza as the source type.
• Provide a name for the source and click Save.

Step 2: Environment Assignment

If Environments are enabled in the application, users can assign the Data Source to an Environment (for example, Development, UAT, or Production) and associate it with a Logical Source.

Environment assignment helps organize Data Sources across different deployment stages, while Logical Sources represent the same business dataset across multiple environments. Together, they support environment-aware asset promotion and management.

To assign an Environment and Logical Source:

1. Open the Data Source details page --> Settings --> General.
2. Select the appropriate Environment.
3. Select or create a Logical Source, if applicable.
4. Save the changes.

For detailed information about configuring and managing Environments and Logical Sources, refer to the Environment Management article.

Step 3: Configure Connection

1. After saving, you will be redirected to the connection settings page
2. Enable the checkbox for On-premise Web Service and select the Gateway, or use DvSum Web Services (default).

Note: For more information regarding Cloud Gateway, click here.

         3. Enter the required Host, Port, DB Login, and Password.

         4. Click Authenticate to verify the connection. 

Note: For more information regarding On-premise Web Service installation, click here.

          5. After authentication, the Database section will appear, allowing you to select the database for                    scanning.

6. Choose whether to scan all schemas or limit the scan to specific schemas.

•  
  •  
    •  
      • If limiting to specific schemas, select one or multiple schemas from the Available Schemas list and move them to Selected Schemas.

When the option to limit to specific schemas is selected, a list of available schemas will be displayed. The user can choose one or multiple schemas from the Available Schemas list and move them to the Selected Schemas tab on the right.

Step 4: Save Connection Information

1. After authentication and schema selection, scroll to the top.

2. Click Done > Save.

3. Click Test Connection to verify the setup.

Note: When adding or editing a Data Source, if incorrect details or invalid credentials are entered, it will still allows to save the Data Source. However, authentication will fail, and the Data Source will be marked as unusable with a red icon. The Data Source will not be usable until the correct credentials are provided.

The connection is saved, but it cannot be used until valid authentication details are updated.

Step 5: Scan the Data Source

1. Navigate to the Scan History Page.

2. Click Scan Now to initiate a job.

After the scan is complete, click on the Scan Name to open the Scan Summary page. This page will display all the insights from the scan, including the number of new tables and columns retrieved from the schemas selected earlier.

Next, analyze the tables and columns discovered during the scan by navigating to "Data Dictionary" in the left sidebar. The table listing view will appear. Click on the "Recently Refreshed" tab to view the tables identified in the recent scan. Click on the table names for more details.