Data Integration

Warehousing Your Data in the Cloud with ETL

  • Star
  • Star
  • Star
  • Star
  • Star

DWH on the CloudThe process of taking data from different systems and putting it into a data warehouse for business analysis can be a complicated affair. In this article, we look at what is involved and how the cloud has made matters potentially trickier.

A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources..

Oracle Buys Endeca

  • Star
  • Star
  • Star
  • Star
  • Star

 

Oracle has entered into an agreement to acquire Endeca Technologies, a leading provider of unstructured data management, web commerce and business intelligence solutions.
A privately-held company based in Cambridge, Massachusetts, Endeca provides powerful and highly intuitive products that help companies analyze unstructured data, gain better business intelligence, and deliver a superior customer experience..

 

Aspects to evaluate the selection of an ETL tool

  • Star
  • Star
  • Star
  • Star
  • Star

Addressing a business intelligence project is important to proper assessment of the ETL tool that we will use. The tool based on which we will implement our procurement processes of the Datamart, Datawarehouse or storage structure based on which further exploit the data. It is a cornerstone for the design, construction and subsequent evolution of our BI system. We will analyze technical issues only, without entering into the economic aspects or otherwise (licenses, agreements, technical support, tool changes, etc. ..) . Note that the ETL processes, are closely linked to the processes of data profiling and data quality, here we will not consider.