Smooth integration

EXASolution has a set of standard interfaces that allow smooth integration into existing system landscapes.

 

Users can continue to use the front-ends they have used to date, which means there are no changes for data warehouse users. Thanks to the CLI-compliant native interfaces, proprietary applications can be easily connected.

 

EXASOL offers a high-performance data transfer tool to load the data warehouse; this can be integrated into the ETL tools that are standard in the industry. Direct connection to the most important RDBMS such as Oracle or IBM DB2 allows a fast data transfer between EXASolution and other enterprise
systems within the company.

 

Process control of your data warehouse remains unchanged since EXASolution offers effective possibilities for integrating common user tools.

Extended SQL standard 2003

  • Analytic functions
  • Scalar functions
  • Extended MERGE statements

Typical front-ends

  • Business Objects
  • Cognos
  • Micro Strategy
  • Microsoft Office
  • Panoratio
  • SAS

Standard interfaces

  • ODBC 2.5/ 3.0/ 3.5
  • JDBC 1.0/ 2.0/ 3.0
  • ADO.NET 2.0
  • Native (CLI)

Fast data transfer

  • Oracle
  • IBM DB2
  • CSV
  • FBV
  • Parallel CSV