IBM InfoSphere Information Server vs. Quantrix

Information Server is extremely useful to replace manual developments that require a lot of coding effort. It significantly increases the productivity of the initial development and the future maintenance of the processes since it has a visual development environment with self-documentation.

If you find yourself in the ocean of traditional spreadsheets, overwhelmed by broken links, errors, model audit problems, hardwiring, etc. here is a lifebuoy for you. If you want to have full flexibility in your budgeting and forecasting in contrast to ERPs with rigid structures and one-size-fits-all concept. If you are small or medium size company and do not want to invest in costly enterprise solutions. If you need a fast implementation https://youtu.be/5W_q5Xhw5fg

• 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

Incentivized

• Building complex financial planning model availing of a multidimensional data structure coupled with a powerful formula language, with the immediacy and intuitiveness typical of spreadsheets
• Implement quickly model modifications (new products, new scenarios, new time periods) simply adding new "items" to "categories" (corresponding to dimensions in a multidimensional data model)
• Scale up models to very large datasets with very fast computation times
• Easily import data from text files, other Quantrix models and external databases via DataLink and DataNAV
• Save snapshots of tables computed in Quantrix to external databases via DataPush

Incentivized

• 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.

Incentivized

• Hard to be critical of the Quantrix team as I know they strive to produce the best product possible. I suppose the next thing on my wish list would be the application of the new Solver functionality to be available in the Qloud.
• A big help for new users would be a good book on transitioning from Excel or other environment into Quantrix. I know first hand it can be difficult to transition when having to learn the program through a help guide, forums and tech support. I had a lot of trial and error in my journey to producing the desired models. On one hand it was a valuable method as it taught me a lot of what not to do, but I will admit it was not the most efficient way to do things.
• Would also love to see local user groups being formed at some point in the future. Quantrix puts on a fantastic conference once a year in beautiful Maine, but it is a big journey for someone in Southern California (and limited to one or two days a year). I would like to see some local chapters formed in different areas of the country so local Quantrix users can get together more often and collaborate (maybe a quarterly or semi-annual meetup?). Our Quantrix community is still relatively small and may be a difficult task for some areas, but is also the very reason why this would be great idea.

• Scale of implementation
• IBM techsupport

Incentivized

For a newbie it can be difficult until you get the hang of the system. Quantrix is a very logical system, once you understand its underlying ideas.

DataStage is more robust and stable than ODI The ability to perform complex transformations or implement business rules is much more developed in DS

Overall, I was not part of the ultimate decision to purchase Quantrix. I terms of user-friendliess and robust reporting capabilities I do think Tableau has Quantrix outclassed. That being said, Quantrix does provide more in-depth analyses for our relevant data and provides better modeling for our forecasts out of the box. The accuracy of the tools output is also much better

Incentivized

• Productivity of the development of integration processes.
• Better documentation and governance.
• Reduce training costs of various technologies.

• Capacity forecasting used to take hours to calculate with a ton of manual modifications. Quantrix has automated that so a model can be updated at any time with a click of a button
• The accuracy of the models is incredible. It took some tweaking to add in data scubbers, but now it runs almost flawlessly
• The confidence the management teams have in the output of the model is amazing. Before, people would question the output, have you rebuild it, and then compare. Now the report comes out and the output has high confidence.

Incentivized