The Module Connect & Warehouse

The Connect & Warehouse Module consists of a data processing component (Connect) and a data storage component (Warehouse). Together they form the core of businessNavi while being usable individually. They can be used in combination with additional modules or serve as a base for own evaluation systems.

businessNavi Connect

The Connect component initiates a connection to your most differentiated source systems. It comprises configurable processes via meta data as well as functions for extraction, transformation and for loading the data into the data warehouse. You choose the interval of actualization depending on the application – close to real-time.

Throughout the processing of the data, checking routines secure both completeness and currentness of the data. Every process unit is tested and documented by the integrated logging. Moreover, the proper specialist department will be informed. Concentration on the essential is complemented by triggers for event-controlled reporting.

businessNavi Warehouse

The Warehouse component organizes your data relevantly for evaluation purposes. It contains predefined table structures and views for the sectors Sales, Finance, Purchasing and Production. All assessments run on the data warehouse with optimized performance and thereby relieve the operative systems.


At the start of businessNavi’s implementation all structural changes are steadied. Hence, not only current, but also historical views are reproduced.

All companies are exposed to changes in classification of master data – for example, regarding the distribution of sales areas or the affiliation of products to product groups. This takes away the ability to view data structures historically and causes existing reports to no longer be reproducible or dynamic data from the past to not be assessable in current structures, respectively.

Architecture and applied technologies

The Warehouse Module is implemented with the SQL server 2012 by default. Optionally, you can make use of any relational database system (RDBMS). Access to your operative systems is granted by an extraction program which can be applied by Java-technologies independently from the platform. The data converting process is realized by a Java-based framework.

Extraction: Data is extracted through a JDBC-interface (Java Database Connectivity), thus, supplying options such as ciphering and dispatching the data involving a backup.
  • Data Converting: The process order is steered by a Java-based framework which additionally facilitates the histography of the data. During the data allocation process, logging-information arranges a broad overview about table sizes and transformation progress.
  • Data Storing: The data model being implemented on the data base can be extended as necessary. Alternatively, one can apply any RDBMS.
businessNavi module overview

Concerning the frontend, IBM Cognos is recommended in order to enable the optimal and extensive possibility for reporting and analyzing. Suitably, standard analysis cubes and reports are determined for the delivery volume of the additional modules businessNavi offers.

Basic Modules Composition Modules
  • Planning
  • Consolidation
  • Special


Josef Mirkhel

Josef Mirkhel

Project Manager

+49 (0) 2382 9698 300

Download the flyer