The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

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

Summary: 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.

Date: 22 Mar 2012
Level: Intermediate

Activity: 2066 views
Comments:

Get the download

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:

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

Download

Description	Name	Size	Download method
Article in PDF format	ID_628_Public_Whitepaper_IBM_InformationServer_Netezza.pdf	1.6MB	HTTP

Information about download methods Get Adobe® Reader®

Comments

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