IBM ILOG CPLEX Optimization Studio vs. IBM InfoSphere Information Server

It is well suited for solving large-sized, mixed-integer, and integer programming problems. Now, the new version supports for Multi-Objective optimization along with some new algorithms such as Benders Decomposition. It is less appropriate for quadratic programming problems where the objective function is the product of multiple variables. However, it's very easy to code any problem.

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.

• Linear Programming
• Mixed-Integer Linear Programming
• Non-Linear Convex-Optimization
• Visualization
• Shadow Price Analysis
• Parameter Tuning

• 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

• Data handling from different sources like Note Pad, etc.
• Large size of MILP problems.
• Various parameters to set.

• 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

• Scale of implementation
• IBM techsupport

Incentivized

It's nice to use and with good optimization.

Honestly, to say, I never contacted CPLEX but used its forum to know/clarify any issues I faced.

IBM CPLEX Optimization Studio covers wide range of problems in comparison to Gurobi and also offers a number of visualization tools for results analysis. It has better customization and parameter tuning options in comparison to Gurobi. It offers various API integrations such as Python, Java and C++ which is not the case with Gurobi.

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

• Faster computation leading to better internal customer relations
• Able to solve high variable problems with ease
• Anomaly detection became easier within business

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