Deutsch   |   English
   
 digg.com  del.icio.us 

Best practices ETL

Best practices with EXASolution

We recommend to shift transformations from external tools into EXASolution to leverage the power and performance of the whole cluster: ELT

DOs

  • Extract data from the source system
  • Load data into a special schema in EXASolution (staging area)
  • Transform data using plain SQL:
    • Adjust Formats
    • Check Primary Keys
    • Check Foreign Keys
    • Check data quality
    • Normalize data
  • Integrate data into the target schema

DON’Ts

  • Pre-aggregate data for better performance (use views instead)
  • Create separate Data Marts (use views instead)
  • De-normalize data for better performance (use views instead)
Are you stuck?

To Support

Learn from the experts:

Training

References
  • AHOOLY
  • COOP

  • “With EXASolution, we are best prepared for future data growth. The fact that we can now process geodata – that is to say, also evaluate the dimension of the spatial reference – means that we can offer our customers brand new analysis options and even more comprehensive market overviews. We are very satisfied with the new solution. We can react flexibly to future demands but still reduce our total cost of ownership as the selected BI stack fully supports our vision of a ‘lean BI’.”

    Guido Niermann, Head of IT, Dataforce GmbH
    Dataforce

  • "By integrating EXASOL we can offer our customers a whole new experience in explorative data analysis… Besides the technical aspects we were also extremely pleased with the pre-sales advice and support during the integration." 

    Martin Heink
    CEO and owner, econda 
    Econda

  •  

     

     

     
     
    IMS

  • "With EXASOL’s innovative database we are able to perform complex analyses more precisely and with a larger amount of data. Thus we have a significant technological lead over our competitors." 

    Tobias Kiessling
    CTO, intelliAd 
    Intelliad

  • "The continuously high performance and the possibility to run real-time-analyses were the decisive factors for us when chosing EXASolution." 

    Tobias Kroha, CEO, seto GmbH (m-pathy-project)

     
    m-pathy
  • Media Control
  • Olympus

  • "We chose EXASolution because of its high performance; it offers optimal flexibility and handles our increasing amount of data very well." 

    Dr Michael Röbbecke
    (former) CEO, RatePAY 
    RatePAY

  • "With EXASolution we can considerably optimise our business processes."

    Gerhard Zapf
    Project Leader, Semikron 
    Semikron

  • "Reliable and quick support, excellent customer care and proven expertise…"

    David Hodge
    IT Director, Sony Music Entertainment Germany 
    Sony Music
  • SOQUERO
  • SponsorPay
  • Stayfriends

  • "EXASOL’s database is technology made in Germany on which we can count on in the long term. As it is self-scaling and physically expandible, the database grows with our company, and we are able to react to new requirements flexibly and quickly also in the future." 

    Heinrich Zetlmayer
    CEO, Turtle Entertainment 
    Turtle Entertainment
  • United Internet Dialog

  • "With EXASolution, we have acquired a database solution that ideally meets the high standards we demand of complex analyses on increasing volumes of data for our customers." 

    Christian Sauer
    CEO, Webtrekk 
    Webtrekk

  • "We chose the solution from EXASOL after an extensive benchmark test. The high performance of the system, the price/performance relationship and the service had us completely convinced." 

    Dr Ulrich Fricke
    Head of Business Intelligence, XING 
    Xing

  • "Efficiency, speed, high performance and flexibility were the determing criteria when chosing our database… The new database offers us scalability with reduced total cost of ownership. Thus also in the future we are able to perform optimal analyses for our customers…" 

    Sebastian Hoop
    Head of Operations, xplosion interactive     
    Xplosion
  • Zalando

EXASOL is developing a data management system capable of rapid data analysis and evaluation. EXASolution is an on in-memory technology based relational database, designed for time-critical, complex analytics, planning and reporting. Specially developed for enterprise data warehouse applications and business intelligence solutions. Successfully in use in a broad field of applications, e.g. web analytics, data mining, big data and cloud computing.