DataStage with Netezza

srini.dw · Post by **srini.dw** » Wed Sep 19, 2012 12:44 am

Hi Guys,

Please need your help.
Does anyone here use Datastage with Netezza?
When I use Informatica 9.1.0 with Netezza, we would need the PowerExchange for Netezza license.
Please let me know if we use DataStage with Netezza, do we need any license.

Thanks,

PaulVL · Post by **PaulVL** » Wed Sep 19, 2012 9:32 am

Your IBM contact would be the one telling you about any licencing requirements your company may encounter.

Given that IBM bought Neteeza and they are aggresively marketing it, the connectivity to Neteeza may very well be integrated within the 8.7 or upcoming 9.1 tools. Again, go ask IBM. (or look at their website)

Mike · Post by **Mike** » Wed Sep 19, 2012 9:56 am

There's nothing special for Netezza. It's just another supported database out of the box (at least as far back as version 8.1 since I've used it with 8.1, 8.5 and 8.7). The new Netezza Connector was released after 8.7 became GA, so you have to download that separately, which I highly recommend.

Mike

vmcburney · Post by **vmcburney** » Wed Sep 19, 2012 5:20 pm

Unlike Informatica there is not cost to the Netezza license for DataStage, just like there is no cost to the Teradata, Oracle, DB2 stages.

There is however a license cost for Balanced Optimizer - the tool integrated into the Designer that lets you push processing onto the Netezza box. This is licensed according to the PVUs of your DataStage server. There is an example in this excellent DeveloperWorks Article with screenshots on how the Netezza pushdown works.

The other option is the special license for Information Server for Data Warehouse. This is the best value for money data integration stack on the market. It gives you DataStage plus Balanced Optimizer plus Services Director (SOA) plus InfoSphere CDC (database replication) plus some metadata tools.

There is a license restriction - Netezza should be the primary target of all data integration, however it has no restriction on the number of PVUs or environments or users. You get real time replication of unlimited sources, unlimited DataStage environments and unlimited developers.

Assuming you have Netezza because of very high data volumes the best addition to the architecture is CDC - the ability to replicate your highest volume transaction data instead of using ETL. For a Telco this could be CDR records, for a utility it could be smart meter data. This significantly reduces the burden on source systems and ETL. The rest of the data can come through the ETL layer.

There is also the Data Warehouse Data Quality add on that gives you Information Analyzer and QualityStage - again without any user limitations so you get unlimited data profiling and data quality rules so you can set up a Warehouse data quality firewall - Information Analyzer rules bound to DataStage jobs.