SAS/Access Competitors and Alternatives

Read reviews of SAS/Access competitors and alternatives
Real User
BI developer at 驴妈妈旅游网
Aug 01 2018

What is most valuable?

Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast.

How has it helped my organization?

In our DW/BI solution, ODI is the main tool to integrate the data as a daily batch. Besides loading data, we do most of our transformations in ODI. ODI is quick to use.

What needs improvement?

The ODI scheduler for agent sometime fails with no sign, which impact the ETL solution severely. The property window in the ODI studio always does not refresh as it should. Sometimes, the mapping or package automatically gets edited.
User
Student at a government with 1,001-5,000 employees
Jul 08 2018

What is most valuable?

* Import from PowerCenter * Copy Text between Excel and the Developer Tool * Logical Data Object Read and Write Mapping Editing * DDL Query * Profiles

How has it helped my organization?

Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years. Informatica administrators are in the scope of daily operations.

What needs improvement?

* XML processing * Scheduler * Non-limit SQL qualifier embedded (right now 32K limitation) The Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design.

Sign Up with Email