Tag Archive for: ETL

In today’s “Big Data” era, a lot of data, in volume and variety, is being continuously generated across various channels within an enterprise and in the Cloud. To drive exploratory analysis and make accurate predictions, we need to connect, collate, and consume all of this data to make clean, consistent data easily and quickly available to analysts and data scientists.

Read more

By now, we’ve all heard the V3 definition for Big Data maybe a million times: Volume (Size of Data), Variety (Type of Data) and Velocity (Frequency of Data) with Veracity (Accuracy of Derived Insights) thrown in as an extra sometimes. The issue is that this all-too-common definition has caused some confusion in organizations around who qualifies as having big data or a big data problem. Read more

ELT is a term heard increasingly in today’s analytic environments. Understanding what it means, and how you can make use of it, requires understanding the traditional nature of how data warehouses are loaded and how data movement tools work. That’s why we’ve pulled this article together: to break down the ETL vs. ELT divide and show you where the similarities and differences are. Read more

SAP-R/3 is one of the most common ERP applications for manufacturing industries.  The data warehouse for such installations has been Oracle.  The biggest pain point for Oracle implementations has been getting the data out of SAP-R/3, which involves complex processes and expert domain knowledge.  With the introduction of SAP-BW, the data warehouse suite, ’Getting the data out’ of SAP-R/3 requires little effort.  Over years, SAP-BW has matured to handle large data volumes and meet the service level agreements for large enterprises.  The question then arises, especially for those organizations with an Oracle data warehouse, if moving to SAP-BW makes long term sense. There are several factors to be considered, the core being organizational commitment and long term vision.  One of the factors is understanding the differences between SAP-BW and Oracle within the context of an enterprise data warehouse. Read more

Tag Archive for: ETL