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
  • Tableau
  • Qlik Sense
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
  • Offers GDPR/DSGVO compliance design patterns
  • 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)
  • SAP HANA, CDS Views
  • 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