#1 most frequent
United States of America
54.0%54 installations of 100
What is IBM InfoSphere Information Server?
IBM InfoSphere Information Server is a data integration platform used to understand, cleanse, monitor and transform data. The offerings provide massively parallel processing (MPP) capabilities.
Categories & Use Cases
Product Demos
Top Performing Features
Simple transformations
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
Category average: 8.8
Integration with data quality tools
Integration with tools for cleansing, parsing and normalizing data according to business rules
Category average: 7.4
Connect to traditional data sources
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
Category average: 8.9
Areas for Improvement
Metadata management
Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management
Category average: 7.5
Connecto to Big Data and NoSQL
Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases
Category average: 7.6
Testing and debugging
Tool to debug and tune for optimal performance
Category average: 7.2
Who Buys & Uses IBM InfoSphere Information Server
#2 most frequent
Australia
4.0%4 installations of 100
#3 most frequent
Canada
4.0%4 installations of 100
Excellent ETL Option for Corporate Data Integration
Pros
- Any source to any target support.
- ETL flexibility without coding.
- Extreme data volume processing.
- Native integration with other Data integration functionalities such as data profiling, data cleansing, metadata management.
Cons
- Lack of a strong web development environment.
- Metadata propagation in Jobs is somewhat complex.
- The possibility to develop jobs in Parallel and/or Server Engines is confusing.
Return on Investment
- Productivity of the development of integration processes.
- Better documentation and governance.
- Reduce training costs of various technologies.
Alternatives Considered
Oracle Data Integrator
Other Software Used
SQL Server Integration Services
IBM InfoSphere, product family for your IT family!
Pros
- IIS best for ETL ,not ELT , and many and diffrent source systems.
- It also can process big data , unstuctured data
- It is not only DWH , you can use infosphere for analys and see the bigger architecture of your OLTP systems
Cons
- Infosphere may improve its logging system. If you dont familier logs of infosphere it's little bit hard to understand
Return on Investment
- If you don't use all of the product family, it will be expensive. But if you want to plan use all the products and you will position it in the center of your infrastructure ROI will be effective.
Alternatives Considered
Denodo
Other Software Used
Denodo, Oracle Data Integrator
Information Server - A world class Integration Platform
Pros
- ETL capabilities, integrating data from any source system to any destination.
- MPP Processing Engine
- Data Profiling & Data Cleansing capabilities with multi-country support for common data such as names and addresses
- Metatada management capabilities not only within the platform but also with 3er party tools like BI tools
Cons
- I would be nice to have a new web development environment for DataStage.
- Connectivity Packs such as Pack for SAP Application are a little pricey.
- It is confusing for new developers the possibility of developing jobs using different execution engines such as Parallel or Server.
Return on Investment
- Information Server can positively impact the costs of companies by increasing the productivity of development and therefore reduce their time and costs. It is estimated that DataStage can increase a developer's productivity by 40% on average.
- Better data governance
- Improve data quality and reduce bad data impacts
Alternatives Considered
Informatica PowerCenter
Other Software Used
IBM InfoSphere Information Analyzer, IBM InfoSphere QualityStage
IBM InfoSphere DataStage Review
Pros
- It is very strong to make transformations/data derivations
- It is very easy to connect to various external data sources. It has an interface (stages) for each connection that simplifies the task
- It is a stable platform. And that parallelism helps make it fast for loading, if the process is well designed
Cons
- Schedule of the processes
- Process versioning
- Deploy of versioned processes between environments. Revision of previous versions
Return on Investment
- I do not measure that kind of data, since I did not define its acquisition
Alternatives Considered
Oracle Data Integrator
Other Software Used
IBM InfoSphere QualityStage
Great product but expensive
Pros
- ETL
- Parallel processing
- Address verification using QualityStage
- Single view of inormation
Cons
- Parellel processing architecture
- Big Data
- Processing of XML
Return on Investment
- Increased time to market
- BI Reports available on time
