Best practices and performance guidelines for IBM InfoSphere Information Server running on Intel Xeon servers providing connectivity to IBM Netezza Data Warehouse servers

This article explains the comprehensive integration that is now available between IBM InfoSphere Information Server and IBM Netezza data warehouse appliance. The authors summarize the results of benchmarking tests focused on load and unload performance when using the InfoSphere Information Server connector for IBM Netezza.

22 March 2012

IBM® InfoSphere® Information Server, Intel® with the latest Intel Xeon® 4 and 8 socket capable Xeon E7 series processors, and IBM Netezza® Performance Server data warehouse appliance work together to deliver break-through analytics based on more trustworthy information. The IBM Netezza data warehousing appliance provides high-performance analytics to businesses. IBM InfoSphere Information Server helps ensure that information loaded into the IBM Netezza data warehouse appliance is comprehensive, accurate, timely, and in context. This allows clients to rapidly drive innovation and improve business results. IBM InfoSphere Information Server is hosted on Intel Xeon E7 series processors which provide a highly scalable and reliable computing platform aimed at mission-critical environments.

In this article

This paper is one of a series of papers intended to provide IBM InfoSphere Information Server customers with helpful performance tuning guidelines for deployment on Intel Xeon processor-based platforms. The authors tested connectivity between IBM InfoSphere Information Server running on Intel Xeon E7-4870 processors in a 4 socket configuration and an IBM Netezza 1000-12 data warehouse appliance. The goal was to optimize performance of the data transfer and load capabilities between these two platforms, which are critical for business intelligence. Part of this work involved the creation and optimization of the new Information Server connector for IBM Netezza. The article shows how to best utilize the new IBM Netezza connector to optimize performance between IBM Netezza appliances and Information Server and includes many of the important new features provided by this connector.

The paper includes the following:

  1. Overview of InfoSphere Information Server
  2. Overview of Intel Xeon Series E7 Processors and Intel 10GbE Ethernet Network Adapter
  3. Overview of IBM Netezza 1000 Series Data Warehouse appliance
  4. Benchmarking performance results of load and umload operations between InfoSphere Information Server and Netezza 1000 Series Data Warehouse Appliance
  5. Information Server jobs used for testing
  6. Standard practices and guidelines for effective performance

Download

DescriptionNameSize
Article in PDF formatID_628_Public_Whitepaper_IBM_InformationServer_Netezza.pdf1.6MB
static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=806445
SummaryTitle=Best practices and performance guidelines for IBM InfoSphere Information Server running on Intel Xeon servers providing connectivity to IBM Netezza Data Warehouse servers
publish-date=03222012