Netezza DBMS Data Integration and Synchronization

IBM Netezza DBMS is a relational database management system. Netezza's appliances use a proprietary Asymmetric Massively Parallel Processing (AMPP) architecture.

To connect to Netezza DBMS the data source entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:

Fig.: Example connection configuration to connect to Netezza DBMS. 

Netezza DBMS Specific Configuration Settings

​​Please note the following specific settings.

• Select the Odbc Data provider provider to connect. 
• You can use a connection string like this to connect:
  server=myServerAddress;database=myDataBase;user=myUsername;
• You can map your data fields to specific external source fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported).
• No installation or changes are required at the data source or data destination.
• You can make use of all SQL queries your data provider supports. You can also use stored procedures that returns records, exec myStoredProcedure().
• The primary key is normally set automatically, if available.
• You can use the connection for uni- or bi-directional synchronization. Several replication conflict solution strategies are offered.
• No need to open your local network for access from outside.
• Bi-directional sync is generally supported. You query must be updatable for this (note that most joins are not). You will also need write access rights for this.

Netezza DBMS Data Integration Scenarios

​​​​Just some ideas what to connect next:

• You will find 150+ more systems to connect to Netezza DBMS here.

Can't find what you are looking for? Take a look here or contact [email protected] for any help.

Netezza DBMS Data Integration - Known Issues and Workarounds

• Currently there are no known issues.
• For more detailed setting options please take a look at the Layer2 Cloud Connector User's Guide.

Ready to go next steps?