5 EASY STEPS TO
CREATE YOUR DATA WAREHOUSE

ARCHITECTURE

FEATURES

MAIN FUNCTIONALITY

FULL BI-STACK AUTOMATION

From source to data warehouse through to frontend

  • MS SQL Server 2008-2017
  • SQL Server Integration Packages
  • MS Analysis Cubes
  • Tabular Models
  • PowerPivot (Excel)
  • Power BI

DEPLOYMENT

  • Visual Studio Solution
  • Creation of DACPAC files

AUTOMATIC CONNECTIVITY

  • MS SQL Server
  • ORACLE, Oracle Exadata
  • SAP/Theobald (DeltaQ/Tables)
  • Excel
  • Access
  • CSV/Text
  • OLEDB (e.g. Terradata, Netezza, DB2..)
  • ODBC (MySQL, …)

DOWN LAYER: PRE-DEFINED META DATA CONNECTOR

  • SAP R3 /S4
  • MS CRM
  • MS Dynamics Navision

MANUAL CONNECTIVITY

  • Any data source
  • Hadoop with partner connector
  • Google BigQuery/Analytics
  • Amazon
  • Shop solutions
  • Facebook
  • LinkedIn
  • Twitter

MODELLING APPROACHES

  • Kimball
  • Data Vault 2.0 and 1.0
  • Inmon
  • 3NF
  • Custom creations

HISTORISATION APPROACHES

  • Slowly changing dimensions (SCD) typ 0,  typ 1, typ 2
  • SnapShot historisation
  • Gapless historisation
  • Change-based calculations

SURROGATE KEY

  • Auto-increment, long integer
  • Hash key, custom definition of hash algorithm

TRANSFORMATIONS

  • Automatic transformations
  • Manual transformations (View)
  • Manualy created SSIS Packages
  • SQL Script
  • Stored procedures
  • Persistence of results

AZURE

  • Azure available also Azure data warehouse

OTHER

  • Source metadata exploitation
  • Support for roll based security (OLAP Cubes)
  • Data partitioning
  • Pre-deployment script and post-deployment script
  • Multiple environment support
  • Custom defined layers
GUI
  • Windows GUI
  • Embedded version control
  • Multi-user
  • Predefined templates
  • Cloud-based repository
  • Cloud service support available
  • Data Lineage
  • Macro language for more flexible development
  • Predefined, datatype-based transformations
  • Example:: Ltrim, Rtrim, Null2string, ..
  • Calculated columns in each DWH table
  • Single point development: whole design in AC possible. External development not necessary
  • Embedding external code
  • Automatic documentation in Word and Visio
PROCESS SUPPORT
  • ETL procedure protocol
  • Error handling on ETL procedures
  • Consistency on ETL failure
  • Rollback on ETL procedures
  • Automatic recognition of source structure changes and automatic adaptation of connected DWH
  • Entirely DWH lifecycle support
  • Delta and full load of data models
  • External orchestration/scheduling for ETL process
  • Internal orchestration/scheduling for ETL process with generated MS-SSIS packages
  • Several workflow configurations
  • No runtime for AnalyticsCreator necessary
  • Daily processing of created DHWs is run without AnalyticsCreator
  • No additional licences necessary
  • For design component no MS SQL Server necessary
DATA SOURCES

AUTOMATIC CONNECTIVITY

  • MS SQL Server
  • ORACLE, Oracle Exadata
  • SAP/Theobald (DeltaQ/Tables)
  • Excel
  • Access
  • CSV/Text
  • OLEDB (e.g. Terradata, Netezza, DB2..)
  • ODBC (MySQL, …)

MANUAL CONNECTIVITY

  • Any data source
  • Hadoop with partner connector
  • Google BigQuery/Analytics
  • Amazon
  • Shop solutions
  • Facebook
  • LinkedIn
  • Twitter

DEFINE YOUR OWN CONNECTIVITY

META-CONNECTOR

The meta-connector is a description of data-sources you use for more easy handling in AnalyticsCreator. It contains information about key fields, referential integrity...

 

SAP

  • Module: FI, CO-PA, SD, MM,

MICROSOFT DYNAMICS

  • AX
  • Navision
  • CRM (on premises)
  • CRM 365 (start a request)

 DEFINE YOUR OWN META-CONNECTORS

 MORE META-CONNECTORS AVAILABLE SOON