2014-09-29 10:07:00 UTC

A recent review wrote that PowerCenter has room for improvement. Agree or Disagree?

He wrote "As with all ETL tools in general, it does not include a good data reporting feature." Do you agree with this assessment? 

Read full review here: http://www.itcentralstation.com/product_reviews/po...

22 Answers
author avatar
Top 5LeaderboardConsultant

WIth Cloud implementations there are plenty of analytics that you can reference when moving data using ETL tools. Even outside of the Cloud space I think that there are plenty of options as long as you are on Oracle Products to do this type of analytics. But really what it boils down to is do you have the relationship with the DBA to make these analytics happen and give you access to the dashboard.
Basically, the option is there its just not a "in your face solution". Would it be great to have that on the standard ETL tool....sure, but really even if you had it do you know how to use it properly. I know what you are thinking...."But I know how to use it so therefore I should have it".......OK....Maybe you know but you in the lower percentage with me and a few other people. ROI on that isn't there which is why they haven't done this.

2016-05-11 20:50:07 UTC
author avatar

To determine complexity and system loads easier to end users, companies build up ETL tools to make the process easier and less time consuming. These are used especially in business intelligence and data warehouse projects. On the back of ETL tools there have been some large no. of growth in market. Microsoft introduced SQL Server 2005 with products like SSIS (SQL Server Integration Services).

Yes, for improvement it needs to add field names for new groups.
Overall ETL tools are good to be considered reporting tools.

2014-09-29 11:50:19 UTC
Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools. Updated: March 2020.
406,312 professionals have used our research since 2012.