Accelerate
Your
Data-Driven Decisions
The Exasol Add-On "Exasol Semantic Layer" allows you to implement a complete semantic layer with integrated business logic centrally on the database.
Make the most of your data. Simply. Efficient. Standardised.
Do you...
… already use Exasol, one of the fastest analytics databases on the market?
… want your end users to also benefit from this speed in terms of reporting & analytics, and not be slowed down by BI front-ends or poorly written SQL?
… want exactly one central business layer as an interface to Exasol for all direct queries and BI tools?
Then You Need Exasol Semantic Layer (ESL)
Easy to Use
All queries are simplified and yet formulated in accordance with the SQL standard.
More complex language constructs (such as JOIN, GROUP BY) can be consistently omitted by the user.
This makes the queries extremely simple, even for your less technically experienced users.
Efficient
Use SQL queries that are optimally designed for your Exasol database and are generated at runtime. This avoids bottlenecks and high database load due to inefficiently formulated queries.
The quality of the query is no longer determined by the BI tool or the end user.
Uniform
Create a standardized data model that serves as a central "single source of truth" for technical terms and business logic.
Easily integrate with BI tools such as Power BI, Tableau, Microstrategy, Qlik and access it directly via your SQL client (JDBC, ODBC).
Redundant modeling or programming in the BI frontend is no longer necessary!
Transparent
ESL is based on the free Exasol "Virtual Schema" feature and is therefore completely transparent.
Open and comprehensively documented Python code, stored in the adapter script.
Data models, metadata & business logic are simply structured and stored in database tables.
More than just a semantic layer: ESL can solve many other problems in your everyday data life
- Integrate your database with LLMs: "Chat with your data"
-
Connect analytics database and "cold data" concepts: Current data on the fast Exasol, older datasets on alternative databases. Both databases are merged automatically and completely transparently for the user
- Set up roles/rights models centrally for both column- and row-level-based security
- Enable write-back functionality (e.g. to collect planning data) directly from any(!) BI tool
-
Determine your users' analysis priorities ("meta-reporting") and optimize your data model accordingly
What our users say
“Faster and simplified queries possible without in-depth SQL knowledge”
“I can focus on the content and conditions of my analysis and don’t have to concentrate on SQL structures“
“Queries can be executed with less work and background knowledge“
“Key figures can finally be defined universally“
“Automates complex and complicated SQL queries for users who are not so technically inclined”
“Elimination of JOINS makes data extraction and overview much easier“
How does ESL work?
The Exasol feature “Virtual Schema” enables almost unlimited manipulation of incoming SQL queries using a Python script (Exasol adapter script). With ESL, we use this possibility to convert the incoming SQL formulated for a simple central (virtual) table into a complex SQL to a previously stored data model.
This frees users and BI tools from creating complex queries and leaves this to ESL. Client queries on ESL therefore require for example neither JOIN nor GROUP-BY. The central table acts as a semantic layer and interface for the business. The complexity of the underlying data model and queries is therefore completely outsourced: