[ www.netezza.com ]
Currently Being Moderated
3

Netezza Migrator.jpg

It may have been the result of a misunderstanding or a comment heard out of context. But whatever the background for the commentary, let me simply state that Netezza is completely committed to the success of the Netezza Migrator and all the other Netezza products and functionality launched at Enzee Universe 2010 this past week. Migrator eliminates a potential barrier to TwinFin™ adoption (i.e., migration costs) and logically should lead to easier acceptance and broader system sales for Netezza. Furthermore, our partnership with EnterpriseDB at both the corporate and technical levels has been and remains extremely solid and strong.

As I stated in the
announcement of the product, “The Netezza Migrator product allows organizations to make data warehouse migration decisions independent of proprietary software lock-in. Organizations using data integration and BI applications with embedded Oracle-proprietary database constructs, interfaces and utilities can now more easily manage their migration from Oracle to a TwinFin appliance. The Netezza Migrator will allow our customers to achieve the performance, scale and cost advantages of their TwinFin systems while maintaining their prior investment in proprietary software.” The Netezza Migrator is specifically designed to reduce the time, complexity and costs required of our customers to move their IT applications to the Netezza TwinFin platform.

With Migrator, Netezza’s customers will be able to extract themselves from the dreaded “Oracle lock-in” of functions and procedures written using Oracle-proprietary techniques and they can decide which of their applications to migrate directly to Netezza and just when, at their own pace. Its capabilities go well beyond the extremely limited capabilities provided by Oracle’s own ‘Database Gateway for ODBC’. Migrator provides an Oracle compatible wrapper around Netezza that is optimized in ways that Oracle could never hope, nor deign, to provide with its "Heterogeneous Services" functionality: including support for Netezza syntax pushdown, high speed API, and Netezza user defined functions.

Migrator makes it even easier for Netezza’s customers to move all of their data warehouse from Oracle to Netezza. In short, this is something we feel is extremely valuable for Netezza and particularly “liberating” for our customers.



Add a comment Leave a comment on this blog post.
Jun 27, 2010 9:08 PM steven.rogers steven.rogers    says:

Migrator could be a nice tool when it works as announcement stated. You did not say much about the Data migration though. I have read the referenced post in dbms2 blog about Migrator where it had raised valid questions.
Does Migrator eliminate that barrier finally or people will continue having a hard time dealing with it?    Regards, Steven

Jun 30, 2010 8:27 AM Phil Francisco Phil Francisco    says in response to steven.rogers:

@Steven: Since Netezza Migrator’s primary purpose is to aid companies in moving their Oracle proprietary PL/SQL, DLL, and DML to Netezza and not as an ETL tool, we understand the issue raised by the commenters on DBMS2 (Todd Fin and others) who asked about load rates. Migrator was designed to be suitable for many incremental data movement scenarios with the convenience of being driven via Oracle SQL and making use of Netezza's high-speed load/unload API.

 

When many terabytes of data movement are required from Oracle into Netezza, we recommend the use of third party tools capable of reading the Oracle data and/or log files directly since the Oracle SQL interface is typically far too slow for such tasks and not suitable for log-based CDC.

Jun 30, 2010 11:33 PM Jeff Feinsmith Jeff Feinsmith    says in response to Phil Francisco:

In addition, Netezza Migrator's version of EDB*Loader (Oracle SQL*Loader compliant API) has direct integration with nzload, allowing for full-throttle load rates into Netezza.