•  Introduction to Netezza Connector
  •  Netezza Connector assets
•  Connections for Netezza
  •  Prerequisites
    •  Configure the Netezza JDBC Driver
    •  Configure the Netezza ODBC Driver
  •  Connect to Netezza
    •  Before you begin
    •  Connection details
    •  Advanced settings
  •  Database privileges
•  Mappings and mapping tasks with Netezza Connector
  •  Netezza sources in mappings
  •  Partitioning for Netezza sources
  •  Netezza targets in mappings
  •  Partitioning for Netezza targets
  •  Netezza target data update
    •  Update as insert
    •  Update else insert
  •  SQL statements
  •  Rules and guidelines for connection and mappings
•  Netezza ODBC SQL ELT optimization
  •  Full SQL ELT optimization
  •  Source SQL ELT optimization
  •  SQL ELT functions
  •  Netezza SQL ELT transformations
  •  Configuring a Netezza ODBC connection for SQL ELT optimization
    •  Configuring the Netezza ODBC driver on Windows
    •  Configuring the Netezza ODBC driver on Linux
    •  Creating an ODBC connection
  •  Configuring SQL ELT optimization
  •  Rules and guidelines for Netezza ODBC connection
•  Data type reference
  •  Netezza and transformation data types

Introduction to Netezza Connector

Netezza and transformation data types

DW_NETEZZA_CONN

DW_NETEZZA_CONN-CONN_NAME

DW_NETEZZA_CONN-CONN_DESC

DW_NETEZZA_CONN-CONN_TYPE

DW_NETEZZA_CONN-AGENTGROUPID

DW_NETEZZA_CONN-DATABASE

DW_NETEZZA_CONN-SCHEMANAME

DW_NETEZZA_CONN-SERVERNAME

DW_NETEZZA_CONN-PORT

DW_NETEZZA_CONN-USERNAME

DW_NETEZZA_CONN-PASSWORD

DW_NETEZZA_CONN-DRIVER

DW_NETEZZA_CONN-RUNTIME_ADDITIONAL_CONNECTION_CONFIGURATION

DW_NETEZZA_CONN-METADATA_ADDITIONAL_CONNECTION_CONFIGURATION