Unterfeldstrasse 18, 8050 Zurich
+41 32 511 27 89

Features

The Features

Guaranteeing the best workflow.
Clever. Intuitiv. Powerful.

1. Connect

The first step is to retrieve data from source systems. Quickly add a new source and immediately copy the data into the staging-area of the Datavault Builder.
Take advantage of the possibility to view the data before and after loading, quickly check data quality or determine top occuring terms.

staging

Manage Sources

  • Connect to any JDBC-enabled database, such as MS Access/Excel/SQL, Oracle and IBM DB2.
  • Group different Sources into Source-Systems
  • Select specific Source Tables and Columns
  • Directly load data and monitor progress

Analyze Data

  • Directly browse data
  • Check data quality
  • Determine top-terms per field
2. Store & Integrate

Now the integrated Core Warehouse, the Datavault, is modelled with the unique Graphical Modelling Editor.
Map the data from the staging into the historized Datavault as permanent storage and directly create automatable loading procedures.

datavault

Model

  • Quickly develop structure with prototyp-elements
  • Create Business Key Hubs, Links and Attribute Satellites
  • Convert data types on the fly
  • Directly initiate fully automated and historized loading

Manage Complexity

  • Browse through related elements
  • Search and add elements to modelling canvas
  • Create Bookmarks of frequently used model-parts
  • Highlight use of source-systems in datavault elements
3. Deliver

As a final step, the data is prepared for delivery to target systems.
Easily compose Business Objects and realize custom Business Logic to supply the information in the exact state as it is needed.

businesslayer

Define Output

  • Select fields to output with drag & drop
  • Rename to business-relevant terminology

Apply Custom Logic

  • Realize system-specific Business Rules
  • Use common SQL-Syntax for full customization
  • Integrate fields from independent Lookup-Tables
4. Automate

To round it up, either kick on the automatically prepared load job with the click of a button or define custom jobs with individual triggers and schedules to feed in new data.

Data Lineage & Instant Insights & Permissions:

Stay in Control

lineage_crop

Track your Dataflow

  • Navigate for- and backwards
  • Highlight Sources and Targets of chosen elements
instantinsights

Get Instant Insights

  • Realize direct Quick-Analytics
  • Visualize data with charting-library
  • Drag & Drop – Editor
permissions

Control Access

  • Setup different User Accounts
  • Manage User Permissions

Release Plan:

More Features are coming up!

Sign up now and get informed about the latest updates.

SMB Edition Enterprise Edition
Staging Integrated Informatica, Microsoft SSIS, others on request
Core Warehouse
Integrated Oracle or Microsoft SQL
Data Vault Visual Interface
Integrated Integrated
Master Data Manager
Excel Loads with historization Plugin for Atlassian Confluence
Business Layer
Integrated (with Custom Business Rules) Integrated (with Custom Business Rules)
Access Layer
Integrated Integrated
Version Control
Integrated (Q2 / 2017) In Database or using Version Control System
Deployment
Integrated (Q1 / 2017) Using Fat-Client Utility
Data Quality (Error Marts)
Integrated (Q1 / 2017) Integrated (Q1 / 2017)
Data Lineage
Integrated Integrated
Instant Insights
Integrated Integrated