IBM InfoSphere Information Server for Netezza 1000 - license + 1 Year Softw

Mfg.Part: D0JVNLL-BL | CDW Part: 2468871 | UNSPSC: 43232314
Availability: 8-10 days
Warranties
$33,367.99 Advertised Price
Advertised Price
Lease Option ($959.66/month)
Note: Leasing is available to businesses only. Leasing is not available to individuals.
Product Details
  • License + 1 Year Software Subscription and Support
  • 1 managed server
  • Passport Advantage Express
  • Linux
  • Win
  • AIX
  • HP-UX
View Full Product Details
Better Together
Quick View
Total Price:

Product Overview

Main Features
  • License + 1 Year Software Subscription and Support
  • 1 managed server
  • Passport Advantage Express
  • Linux
  • Win
  • AIX
  • HP-UX
  • Solaris SPARC
InfoSphere Information Server for Data Warehousing delivers key data integration capabilities for clients of IBM Netezza that help optimize return on investment and help enable the success of data warehouse implementation. Netezza data warehouse appliances bring the power of analytics directly into the hands of business users within every department of an organization.

Netezza is integrated into IBM's Information Management software portfolio and is an essential component of the smarter business systems that IBM is helping companies and organizations build to address the complex business and IT challenges presented by the exponential growth of data.

InfoSphere Information Server for Data Warehousing offers key data integration capabilities for organizations deploying IBM warehouse appliance solutions such as IBM Netezza and the IBM Smart Analytics System.

IBM InfoSphere Information Server for Netezza 1000 - license + 1 Year Softw is rated 4.0 out of 5 by 19.
Rated 4 out of 5 by from Reports used to take 30 to 60 minutes, now run consistently in seconds or minutes Valuable FeaturesHigh performance RDBMS appliance optimized for data warehousing and enterprise reporting. Very simple to manage huge volumes of data without having to worry about indexing and partitioning.Improvements to My OrganizationReports which used to take between 30 to 60 minutes or would time out on an Oracle database, which was previously used for the enterprise DWH, now run consistently in seconds or in less than five minutes.Room for ImprovementCould do better to support more concurrent update queries. We had to stagger our ETL loads to prevent queuing of jobs and random failures.Use of SolutionOver one year.Stability IssuesThe database runs stable unless there are hundreds of queries running in parallel.Scalability IssuesEvery query is a full table scan. If the table contains mostly integers, then performance is good. If the number of users is in the thousands, then it may be better to use cubes or other solutions to service reporting needs.Customer Service and Technical SupportBefore being acquired by IBM, Netezza corporation had exceptional support and used to respond very quickly (less than 30 minutes) in case of production issues. Round the clock support and monitoring were offered and support tickets were handed over very professionally between engineers working across time zones. After being acquired by IBM, support has not been as responsive, but there weren't as many issues as the box was stable.Previous SolutionsPreviously, Oracle was used as the data warehousing platform, and performance was low and not meeting the needs of the enterprise reporting and analytic user community. My customer switched to Netezza mainly for performance, and it was a big improvement.Initial SetupAs the box was very heavy, datacenter flooring required additional reinforcement. The box runs Linux and the initial setup is quite straightforward. ODBC drivers on the servers (ETL or reporting) which connect to the box may need to be upgraded.Pricing, Setup Cost and LicensingFrom a cost per terabyte perspective, Netezza is definitely more expensive compared to Hive on Hadoop, but due to its simplicity and ANSI SQL Compliance and high performance which can be achieved with less tuning, it may be worth it.Other Solutions ConsideredMy customer upgraded from Netezza 4.x to Twinfin 6.x.Other AdviceNetezza is a great option for data warehousing, but give due attention to concurrency and find out how much would be the peak load the database may have to handle. Also, check whether performance is acceptable for APIs and web services. Performance may not scale for thousands of single row lookups, as the database is more suited for complex aggregated data warehousing queries.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2018-01-25
Rated 4 out of 5 by from The platform is very efficient and robust. Valuable Features:It is extremely easy to use. The platform is very efficient and robust as well.Improvements to My Organization:Generally, the machine utilized for the PoC is rarely returned once the overwhelming results are seen! Customers decide to keep the project, almost from scratch! The initial KPIs are delivered with low investment. There is quick implementation and considerable outcomes which make the platform a valuable asset to the organization.Room for Improvement:Marketing, I dare say, should be improved. The ads should NEVER mention “big data” since the platform was not initially designed for it!I worked years and years ago with Teradata, and this is the platform to which it should be compared. It is important to emphasize that Netezza and Teradata have different markets. Netezza performs very well “in its peculiar and valuable small world”.Use of Solution:I have used this solution for years.Stability Issues:We did not have any stability issues.Scalability Issues:It is not designed to process a huge volume of data.Technical Support:Technical support is good.Previous Solutions:I worked for different companies and my experience is really wide. Teradata is the paramount solution! Oracle’s Exadata invests a lot in both technology and marketing, sometimes losing the focus on “real” analytics. They used to address the platform as both OLAP and OLTP (“one size fits all”), which is not correct.Initial Setup:The rule of thumb in the data warehousing/business intelligence space starts with a simple PoC. That being said, there must be a few questions to be answered by the platform. The data model must be simple and flexible enough in order to address some “extra questions” within a set timetable, in case the customer wants to extend the PoC prior to making the purchase.Cost and Licensing Advice:Comparisons with other solutions, including pricing and licensing, is as important as a PoC.Other Solutions Considered:I compared Netezza to Teradata and Exadata.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-11
Rated 4 out of 5 by from We can query large data volumes. Valuable Features:IBM PureSystems or NPS has a patented NDAC or Netezza data accelerator card inside each of the SPUs (Snippet Processing Arrays). The SPUs act as individual processors that share part of a query. This helps in high-speed parallel processing of big data volumes. Querying a large data volume takes just a few seconds to minutes, if it is done right.Improvements to My Organization:Analyzing years of data requires high processing power and storage. IBM PDA has exactly that. Years of processed data (tables) can be queried and retrieved based on management requirements. This can be done in minutes for analysis. This is extremely important in identifying trends for decision making in higher management to serve customers better in today’s business environment.Room for Improvement:It is a highly complicated architecture and only IBM engineers/support, or someone who worked on the hardware side of the system, can understand the system architecture completely.This means that:* Replacements can only be done by an IBM engineer* Components are not generic and are not on the market* Many of the systems are IBM patented* Service support costs are highStorage, although high, is limited depending on the rack configuration. For example, an N3001-80, which is an eight-rack Mako Server and also the top end model with the highest storage, can store a maximum of 384TB. Should your data exceed this limit, the storage cannot be extended.It cannot be used for unprocessed data. The data has to be in a table format.Use of Solution:We have been using the solution for five years.Stability Issues:We rarely had stability issues. You may expect an average of one outage every two months for a few minutes, if it is maintained properly. This is mostly due to “pollreplytimeout” errors of the SPU.All the rack components are dual for redundancy. Almost all components have failsafe/backup, including the host that is configured in cluster for high availability. With this, the system is up and running all the time, or you can get it up at the earliest possible time in case of component failures/system down situations.Scalability Issues:We had scalability issues. Storage, although high, is limited depending on the rack configuration. For example, an N3001-80, which is an eight-rack Mako Server and also the top end model with the highest storage capacity, can store a maximum of 384TB. Should your data exceed this limit, the storage cannot be extended. You will have to purchase a new appliance.Technical Support:I would rate the technical support at 7/10.Previous Solutions:We did not use a previous solution.Initial Setup:IBM sets up the NPS and does the initial configurations. As an admin, you will have a completely configured system ready to work on.Cost and Licensing Advice:This is a multi-million dollar product. The software and hardware are both IBM patented.Netezza SQL ('nzsql') runs only on PDA systems, and cannot be installed on other enterprise class servers. Power consumption is high and these systems must have mandatory IBM support, due to the patented and exclusive IBM hardware. However, the benefits outweigh the costs if you have large data volumes that require fast analysis on a day-to-day basis.Other Solutions Considered:We didn't really examine any alternatives. I started working directly on IBM PDA (Netezza) and I haven't had any chance to work on the competitors' products. I was not a decision maker in the selection of this product. This was a higher management decision.A close competitor of IBM PDA is Apache Hadoop. As of now, no other product is as fast or as stable.Other Advice:You can definitely consider this appliance if you have:* A large volume of processed data (tables) that are created on a daily basis* Data that requires daily analysis, critical for decision making, and a budget to complement itThis is one of the most stable and fastest data warehouse appliances available in the market today.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-07-03
Rated 4 out of 5 by from It's an easy-to-use data warehouse appliance, but it doesn't support correlated queries. Valuable Features:* Zonemap features* AMPP (SMP+MPP ) architecture* High availability* Field-Programmable Gate Arrays (FPGAs)Improvements to My Organization:The Netezza deployment is easy, and there is less administration and coding than in other databases.Room for Improvement:* Correlated queries are not supported.* Concurrency - the performance dips with number of concurrent queries; for example, if more than 48 queries are run concurrently, it queues up.* Scalability - if the data increases, you need to go for a bigger appliance as you cannot add to Netezza incrementally.Use of Solution:I've used it for two-and-a-half years.Deployment Issues:Some minor SPU communication issues with IP protocol.Stability Issues:No issues encountered.Scalability Issues:No issues encountered.Customer Service:They deliver the products to customers faster and with greater accuracy, i.e. within the agreed-upon due date.Technical Support:Netezza already had a excellent customer satisfaction and the rating would be 8/10.Previous Solutions:We previously used Oracle then migrated to Netezza because its deployment is easy, and there is less administration and coding when compared to Oracle. Also, the query performance is excellent in Netezza.Initial Setup:It is very straightforward because Netezza's initial setup took less than two days and the entire data set was loaded onto the Netezza appliance to which users had full access to the system.Cost and Licensing Advice:Netezza is an easy-to-use data warehouse appliance. It's extremely fast with a low cost and the customers run their BI and advanced analytics in a very flexible manner.Other Solutions Considered:We also looked at Teradata.Other Advice:Netezza should have enough advantages with implementation, i.e time to deployment, price, performance, and the ability to integrate with the existing environment.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-02-12
Rated 4 out of 5 by from It is very fast which makes our life easier to run huge queries for analytics. Valuable Features:We use Aginity to access Netezza database. We really like the way we can dominate the physical distribution of the data hence know how to improve the performance of the query. Netezza on its own is very fast which makes our life easier to run huge queries for analytics.Improvements to My Organization:This has really helped us to improve the performance of our Data Marts and warehouses. We can run our reports very quickly. It has also improved the turn around time of business requests.Room for Improvement:In Aginity there should be a way to format the SQL queries. I think we can't format the query the way we can do it in Oracle editor (beautifier). Say, for example, if we are trying to get the DDL of an existing view, we lost the formatting. It's a minor issue, but important from usability point of view. Other than this, I think we are good so far with Netezza as a whole.Use of Solution:We have been using this product from last 5 years.Deployment Issues:We did not experience any issues.Stability Issues:We haven't had any issues.Scalability Issues:We've not experienced any issues.Other Advice:If volume is the issue, use Netezza. Nothing is better than this product.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-10-15
Rated 4 out of 5 by from It has allowed us to get reports that were previously unavailable, but the in-house development tool needs work. Valuable Features:There is minimal on-going maintenance.Improvements to My Organization:There were some reports we couldn't get because of performance, but with Netezza we could get more of them.Room for Improvement:It needs a better in-house development tool.Use of Solution:I've used it for three years.Deployment Issues:Functions are difficult to deploy.Stability Issues:No issues encountered.Scalability Issues:No issues encountered.Customer Service:7/10.Technical Support:7/10.Previous Solutions:Our customers mostly switch from traditional RDMs to appliances.Initial Setup:It is very easy to setup.Implementation Team:We used an in-house vendor who were 8/10.Cost and Licensing Advice:Choose your most complex scenario. Do a POC and try to scale.Other Advice:You should know how it works well so you can use its power. So, start with a partner or vendor team.Disclaimer: My company has a business relationship with this vendor other than being a customer:Premium Business partner
Date published: 2016-09-26
Rated 4 out of 5 by from It is very fast which makes our life easier to run huge queries for analytics. Valuable Features:We use Aginity to access Netezza database. We really like the way we can dominate the physical distribution of the data hence know how to improve the performance of the query. Netezza on its own is very fast which makes our life easier to run huge queries for analytics.Improvements to My Organization:This has really helped us to improve the performance of our Data Marts and warehouses. We can run our reports very quickly. It has also improved the turn around time of business requests.Room for Improvement:In Aginity there should be a way to format the SQL queries. I think we can't format the query the way we can do it in Oracle editor (beautifier). Say, for example, if we are trying to get the DDL of an existing view, we lost the formatting. It's a minor issue, but important from usability point of view. Other than this, I think we are good so far with Netezza as a whole.Deployment Issues:We did not experience any issues.Stability Issues:We haven't had any issues.Scalability Issues:We've not experienced any issues.Other Advice:If volume is the issue, use Netezza. Nothing is better than this product.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-05-06
Rated 4 out of 5 by from It has allowed us to get reports that were previously unavailable, but the in-house development tool needs work. Valuable Features:There is minimal on-going maintenanceImprovements to My Organization:There were some reports we couldn't get because of performance, but with Netezza we could get more of them.Room for Improvement:It needs a better in-house development tool.Use of Solution:I've used it for three years.Deployment Issues:Functions are difficult to deploy.Stability Issues:No issues encountered.Scalability Issues:No issues encountered.Customer Service:7/10.Technical Support:7/10.Previous Solutions:Our customers mostly switch from traditional RDMs to appliances.Initial Setup:It is very easy to setup.Implementation Team:We used an in-house vendor who were 8/10.Cost and Licensing Advice:Choose your most complex scenario. Do a POC and try to scale.Other Advice:You should know how it works well so you can use its power. So, start with a partner or vendor team.Disclaimer: My company has a business relationship with this vendor other than being a customer:Premium Business partner
Date published: 2016-04-25
  • y_2018, m_8, d_17, h_14
  • bvseo_bulk, prod_bvrr, vn_bulk_2.0.8
  • cp_1, bvpage1
  • co_hasreviews, tv_0, tr_19
  • loc_en_US, sid_2468871, prod, sort_[SortEntry(order=SUBMISSION_TIME, direction=DESCENDING), SortEntry(order=FEATURED, direction=DESCENDING)]
  • clientName_cdw