hapec Xstream

‹Clean data allows you quickly find the information you need› With hapec Xstream you can view comparable data on a uniform database.

hapec Xstream converts your data into relevant business information. Defined data sources such as ERP systems, relational databases, special applications, spreadsheets, lists and other resources can be searched to collect valuable business data. Using hapec Xstream you can expand, clean and constantly update your database (the data warehouse). hapec Xstream can transform even the most unmanageable clutter of basic figures into a spotlessly clean data pool — an essential prerequisite for further calculations and analysis.

Supported Data bases and target systems:

Relational database systems
Microsoft SQL Server, DB2 iSeries, Oracle, mySQL, Microsoft Access, Borland Interbase/Firebird, Gupta SQL Base, Sybase Adaptive Server Anywhere, Sybase SQL Anywhere and more…

File system-based systems
dBASE, Flatfiles/Textdateien mit Trennzeichen, Microsoft FoxPro, Microsoft Excel, Paradox and more…

Tethered source systems
Bäurer b2, CAS genesisWorld, ISGUS ZEUS, Microsoft Business Solutions Navision, ORTHOsoft, PSI penta, Sage Classic Line / Sage New Classic, Sage Office Line, Sage PC-Kaufmann, Sage Personalwirtschaft, Sage SalesLogix, SBS Lohn, SBS Rewe, SBS Wawi, Syska SQL REWE, MICOS konzept, SAP, UB-Software Majesty and more…

Technical specification

  • Convenient graphical user interface with powerful wizards
    for simple definition of data sources, to localize the relevant base data sets and for the subsequent determination of the extraction, transformation and loading (ETL) processes
  • Easy prototyping and accelerated system launch
  • Interactive development and testing queries with the integrated SQL-Designer
  • XML export and import of metadata
    for further use or for porting into other environments
  • Periodic automatic update and supplementary data warehouse by terminated ETL processes
  • Includes extensive application integration features
  • Automatic, scheduled delivery of exported reports by e-mail
  • Automatic, scheduled loading of OLAP data cubes
  • Centralizing of enterprise tasks

factsheet

Reference projects — hapec Xstream

, , ,

, hapec

hapec

, , ,

, ,

, ,

,

, hapec

hapec

, ,

,

, ,

, hapec

hapec

, ,

, hapec

, hapec

, hapec

hapec

,

hapec

,

hapec

hapec

,

,

hapec

hapec

,

,

hapec

, ,

hapec