IBM InfoSphere Information Server vs. Spreadsheetsoftware ExcelAnalyzer

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.

It analyse the financial Model for audit before taking a major decision. it is very easy to use and have a good usage for the new employees. It make my work easy to prepare the internal and external audits. It also help me to clean up the spreadsheets before automation and if you are in trouble then they have a very good customer support as well.

• 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

• 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

Because it is a good tool to reduce the errors in your data and easy to use for all the employs in the organization to set up the Excel Analyzer is also very easy. It save my time and also reduce the financial risks after analysing my data. It also improve the compliance to audit the data.

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

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