162

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

Mfg. Part: D0JVNLL-BL | CDW Part: 2468871 | UNSPSC: 43232307
Request Pricing
Close

Have leasing questions? Let us know how can we help.

Note: Leasing is available to organizations only. Leasing is not available to individuals.
800.808.4239
Mon-Fri 7am-7:30pm CT
Availability:8-10 days
Orders placed today will ship within 10 days
  • License + 1 Year Software Subscription and Support
  • 1 managed server
  • Passport Advantage Express
  • Linux
  • Win
  • AIX
View More
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.

Technical Specifications
Specifications are provided by the manufacturer. Refer to the manufacturer for an explanation of the print speed and other ratings.
System Requirements
Platform: AIX , HP-UX , Linux , Solaris SPARC , Windows

Software
Bundled Support: 1 Year Software Subscription and Support
License Category: License
License Qty: 1 managed server
License Type: License
Licensing Program: Passport Advantage Express

Service
Support Details Full Contract Period: 1 year

Header
Brand: IBM
Compatibility: PC , Unix
Manufacturer: IBM
Model: Information Server for Netezza 1000
Packaged Quantity: 1
Product Line: IBM InfoSphere

Service & Support
Type: New releases update

Service & Support Details
Service Type: New releases update



Response Time: 2 hours
Service Availability (Hours a Day): Business hours
Service Type: Phone consulting



Service Availability (Days a Week): Monday-Sunday
Service Availability (Hours a Day): 24 hours a day
Service Type: Emergency phone consulting



Service Type: Web knowledge base access



Service Type: E-mail consulting

General
Category: Business applications
Subcategory: Business - data analysis & business intelligence

Licensing
License Pricing: Volume

Product Reviews
IBM InfoSphere Information Server for Netezza 1000 - license is rated 4.0 out of 5 by 16.
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
Rated 4 out of 5 by from It has Standard SQL, ODBC, JDBC, and OLE DB interfaces. Valuable Features:* Supports both business intelligence and advanced analytics* Efficient even if being used by thousands of users at the same time* Streaming architecture based on blades* Compatible with the most popular business intelligence and analytic tools* Standard SQL, ODBC, JDBC, and OLE DB interfacesImprovements to My Organization:We had lot of POC's on data warehousing project with the help of Netezza, we have proved that it has really improved time on doing analyticsUse of Solution:I have used this solution for more than two yearsDeployment Issues:There were no issues with the deployment.Stability Issues:It's reliable and available, with 99.99% uptime.Scalability Issues:There were no issues with the scalability.Technical Support:Support for this product is good.Initial Setup:Initial set-up was straightforward.Implementation Team:It was done by an in-house team.Other Advice:It is good product if you are choosing to go for datawarehouse business intelligence.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-01-31
Rated 4 out of 5 by from ARULES() function is the fastest implementation of the associations algorithm (a priori or tree) I have worked with. Valuable Features:ARULES() function is the fastest implementation of the associations algorithm (a priori or tree) I have worked with. In comparison with the R associations package, it is +1000x faster. The issue with the R implementation, and R in general, is that the functions do not work on large sets of data. R would generate a 100,000 x 100,000 element matrix for some of the arules runs we do – very, very inefficient programming.Improvements to My Organization:Any in db machine, learning functions help by eliminating the data transport issue. NZA goes one better by allowing you to utilize a tuned engine (software + hardware) to run the functions. The result is that we can run algorithms that would be impossible to run on other platforms.Room for Improvement:We are using an older version. Some improvements are already implemented, such as the addition of neural networks. Other improvement would be to make the existing algorithms even faster, e.g. kmeans can actually be parallelized. If this reworking of the algorithm is done, it should leverage the MPP architecture of Netzza and run much faster.Also, some algorithms are faster than almost any other method or system e.g. NZA.ARULES() function. Whereas others are not as fast and could probably be optimized for an MPP architecture like kmeans function.Use of Solution:2-3 years on and off. 1 year for actual integration into another tool for mass consumption.Deployment Issues:For deployment, ensure you follow the instructions. The version of Netezza must be matched with the version of NZA. We tried to install a newer version of NZA not supported by the version of Netezza we had and it did not work.Technical Support:N/A. We did not engage IBM tech support, mainly due to past experiences where it is faster, easier and much less stressful to just figure things out yourself.Previous Solutions:Rapidminer, R, DB2 intelligent miner, SSAS data mining were all tested for association rules. Rapidminer and R did not pass. They use matrix math, and cause +100x performance degradations. DB2 intelligent miner, SSAS data mining, and likely also NZA follows the original a prori methods of using sets, not matrices.Initial Setup:DBA set it up, but it seemed very simple. I helped with designing the overall architecture. If you stick with NZA as a “function repository DB” concept and do not put data on it (as recommended in the install manual) you will be ok.Implementation Team:In-house. Don’t over think it. Just apply some base architectural principals and give it a try. If you find something not working make adjustments.Cost and Licensing Advice:I had nNo visibility to pricing. Netezza in general though, is very cost effective. If you compare to other MPP platforms like Hadoop. Hadoop requires a very “non-enterprise” culture to implement and a team of designers / engineers. Netezza requires maybe 1-2 admins.Other Advice:I would have to understand the specifics of the organization, the data size, the tasks, etc. to make any recommendations.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-01-17
Rated 4 out of 5 by from It reduces system administration and database administration effort. Valuable Features:Netezza partitions all database objects across all available SPU’s. With traditional RDBMS systems, partitioning database objects requires a lot of planning and configuration. Netezza, only requires to develop a partitioning scheme. This eliminates several steps in the process, vastly simplifies performance tuning leading to very high performance.As the system is preconfigured, the site level configuration required is minimal. Eliminates the need for a separate SAN.Improvements to My Organization:Reduces system administration and database administration effort. Simplifies performance tuning effort. The net effect is reduced load on DBA team and quicker turnaround.Room for Improvement:Application development in Netezza is done using SQL scripts and stored procedures. GUI based ETL tools provides higher level of visibility and higher productivity. I hope to see a GUI based application development environment. This could also be achieved through tight integration with an ETL tool, like IBM’s own ETL tool DataStage.Use of Solution:We've used it for five years.Deployment Issues:Netezza was one of the components in our application. This component had the least number of issuesStability Issues:Netezza was one of the components in our application. This component had the least number of issuesScalability Issues:Netezza was one of the components in our application. This component had the least number of issuesTechnical Support:Good. We had Netezza experts assigned to the client site and had easy access to them.Previous Solutions:* Compared to other RDBMS, Netezza provides much higher performance and much lower maintenance effort* Compared to Teradata, lower cost and lower administrationInitial Setup:Initial set-up of the system is quite simple. Eliminates several steps required in a custom built platform, like storage system configuration, planning database storage.Implementation Team:I was a consultant from the system implementation vendor.Other Advice:* Netezza is well suited for data warehousing and analytics, not for OLTP application* The key approach is to develop an uniform data distribution scheme and collocation of data partitions across related database objects. For example, if we have a large customer dimension and a large sales by customer fact, these tables will be joined very frequently. To get the best performance, both tables should be distributed on the same key, e.g. customer_id.Disclaimer: My company has a business relationship with this vendor other than being a customer:We are system integration provider for Netezza
Date published: 2016-01-05
  • y_2017, m_6, d_26, h_16
  • bvseo_bulk, prod_bvrr, vn_bulk_1.0.0-hotfix-1
  • cp_1, bvpage1
  • co_hasreviews, tv_0, tr_16
  • loc_en_US, sid_2468871, prod, sort_[SortEntry(order=SUBMISSION_TIME, direction=DESCENDING), SortEntry(order=FEATURED, direction=DESCENDING)]
  • clientName_cdwg
 
Adding to Cart...
6/27/2017 12:22:53 AM
^ Back to Top

Maximum 300 characters
An account manager will email you within one business day to confirm your request.

Your Quote has been submitted

What Happens Next? A confirmation email is on its way. Within one business day, you will be contacted by an Account Manager to finalize your quote.

Error!

Something went wrong.

Please try again later.