Case Studies & Reference Letters & News

Case Studies & Reference Letters

News:

Hapec BI Studio

Application and Data Integration

HaPeC Xstream is a innovative ADI Platform developed to help you solve your application and data integration challenges.

Business rules and software development requirements can often make your integration projects logically and technically complex. HaPeC Xstream´s unique Data

Access Layer enables the tech-savvy user to access the necessary datasources without software engineering skills, even from proprietary data sources. 

The metadata model of Xstream is designed for reusability and transportability. All metadata objects are virtual and do not affect the physical datasources.

A ETL metadata model created in Xstream´s database centric studio can be tranfered to other Xstream instances by exporting industry standard XML metadata.

 Capabilities:

- Unified Data Access - Access Data from diverse sources always with the same methods

- Query Parser / Query Engine - Run and optimize queries across multiple heterogenous data sources and data formats

- Metadata Repository / Datastore - Store all metadata of all sources and data destinations as well as the transformational  views    in one central metadata repository

- Virtual Metadata - All metadata points to logical objects which can be easily mapped to the physical environment found.

Xstream Data Access Layer Providers:

- Microsoft SQL Server

- Microsoft Access (Microsoft Jet Engine)

- Microsoft Excel

- Microsoft Fox Pro

- Sybase Adaptive Server Anywhere

- Sybase Adaptive Server Enterprise

- IBM DB2 Universal Database

- IBM DB2/400 on IBM iSeries

- IBM Informix

- dBase

- Firebird

- Borland Interbase

- Flat Files / Text Files

- MySQL

- Progress OpenEdge

- Oracle

- Paradox

- PervasiveSQL

- PostreSQL

- Gupta SQLBase

ERP or Solution Specific Xstream Data Access Layer Providers:

- Sage Office Line

- Sage Classic Line

- CAS genesisWorld

- Microsoft Navision on CSide Database

- Microsoft Navision on Microsoft SQL Server

- Comarch Semiramis on IBM iSeries

- Comarch Semiramis on Microsoft SQL Server

- Comarch Semiramis on Oracle

- Composite Information Server

- IBM Virtual View Manager