IBM InfoSphere, product family for your IT family!
July 02, 2018

IBM InfoSphere, product family for your IT family!

Gunes INAL | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Modules Used

  • InfoSphere DataStage
  • InfoSphere Data Architect
  • InfoSphere Information Governance Catalog
  • InfoSphere Information Analyzer

Overall Satisfaction with IBM InfoSphere Information Server

We use infosphere for
1-Load Data Warehouse: I design ETL jobs for load data to our ODS, DWH and DM tables
2-Design DWH with Data Architect: I use data architect for creating DWH and DM tables. Create diagrams for business flow, table relationships etc.
3-Analysis to OLTP with Information Analyser: I use IA to check our OLTP system.
4-Information Governance Catalog: see the big picture of business and infostructure. We use IGC as a data dictionary, data lineage, and business lineage tool.
  • 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
  • Infosphere may improve its logging system. If you dont familier logs of infosphere it's little bit hard to understand
  • 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.
Denodo not an ETL tool but you can manage your data with it as well as Infosphere
You can use infosphere:
-If you have multiple targets and source systems and they are different than each other.
-If your infostructure is so big and unplaned well so you can't find what you want to see.
-If your databases not so strong to process your data

InfoSphere Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
9
Simple transformations
10
Complex transformations
8
Data model creation
9
Metadata management
10
Business rules and workflow
10
Collaboration
8
Testing and debugging
7
Integration with data quality tools
10
Integration with MDM tools
9