Netezza offload to GCP


Client challenges

Our client, an insurance company from the US, wanted to reduce maintenance cost and bring in advance capabilities to their environment. GCP enables the client to approach new business opportunities and serve the customer better.

Following were some of the critical needs of the client:

  • To decommission Netezza - Move from a high maintenance to pay per use cost model; Provide enhanced analytical capabilities.
  • To Develop the centralized high-performance platform to carry out all Analytics and Artificial Intelligence activities.

Our solution:

We built a single platform on Google Cloud which facilitates faster processing, Analytics and AI capabilities for the business use case.

Following are the processes involved :

  • All Netezza components migrated to Big Query.
  • Informatica Jobs migrated to GCP for processing and loading data to Big Query
  • Dataproc cluster with all accelerators deployed and ability to auto scale and run spark jobs as and when required.
  • Expose data using Big Query interface so that users can access this data for further analytics.
  • Further implementation of analytics Use case

                                                                                    Google Cloud Products We Used:

GCP products we used


                                                                                                    Client Benefits:


The Data lake on GCP is scalable to handle unpredicted demand patterns

Better performance

Enables Advance Analytics and Artificial Intelligence capabilities

Productive & Cost effective

Reduced development time and cost. User-friendly tools that contribute to higher productivity

Enables high security

Supports Disaster recovery and provisions high availability