CincomBI™ Data Warehouse

Your warehouse solution for business intelligence

The CincomBI Data Warehouse layer collects, integrates and stores an organization's data with the aim of producing accurate and timely management information and supporting data analysis. The Extract-Transform-Load (ETL) process provides the data basis for building your warehouse solution. The process extracts data from operational host systems, conforms data from disparate sources, and shapes the data into a form suitable for analysis. The ETL tool helps you develop and automate the construction and update of your warehouse data.

• Reshape your host data into the appropriate physical schema for your warehouse database.
• Support Legacy data stores.
• Transform data from multiple sources into a standardized form.
• Cleanse data to enforce your business rules.
• Handle large volumes of data for initial loads.

CincomBI Data Warehouse supplies a relational database with support for developing J2EE and .Net applications. A reporting framework is also provided to allow you to design and deploy reports without the need to program.

CincomBI for SUPRA®
CincomBI for SUPRA provides an Extract-Transform-Load (ETL) component to help you develop and automate the construction and update of your warehouse data specifically for SUPRA PDM data. Data can be directly extracted using the CincomBI Data Access layer, or it can be extracted using native SUPRA utilities.

Visit the SUPRA PDM page for more information on the SUPRA database management product.