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.
Search for a product comparison in Data Integration
SQL DBA at a computer software company with 51-200 employees
Vendor
Sep 29, 2014
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.
Informatica PowerCenter is known for its robust data integration, scalability, and user-friendly interfaces. It simplifies data processing with real-time capabilities, handling large datasets efficiently. Its adaptability with diverse sources makes it suitable for complex data environments.Informatica PowerCenter offers extensive transformation options with features like flow designer, mapping, and error handling, enhancing development efficiency. Its GUI interface allows seamless integration...
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.
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.