Integration Systems Models
3BI
Provider of Business Intelligence Solutions
Solutions
OLTP
ETL Tools
Reporting
OLAP
Customized data models to store integrated data and to enable and ease the reporting and analysis features of your Marketing Intelligence Solutions.

ETL tools

ETL allows the automation of the copy / transformation processes on a scheduled basis of data from one database to the other. The main features of our ETL solution are:
  • Scheduled copy/transformation of data from OLTP to Reporting and multi-dimensional databases
  • Validation of transformed data (through data mining algorithms and statistical calculations such as database holes, error hunting, anomalies detection, etc.) and automatic database alert generator on industry trend deviation, price movements, new product launches, etc.
  • Scheduled execution of external programs (text file creation for instance)
Copyright © 2006 3BI Consulting. SA. All rights reserved.