Connection to EXASOL DWH

Has anyone experience with connection to an EXASOL DWH? I got information about that product by the TPC website where a benchmark has been published (no. 1 in 100GB and 1.000GB). 
Seems that it is a very fast DWH with cluster technology. Any idea to connect with ODBC, JDBC ... ? 
Here the link to the benchmark site <a class='bbc_url' href='http://tpc.org/tpch/results/tpch_perf_results.asp'>http://tpc.org/tpch/results/tpch_perf_results.asp</a>

Find more posts tagged with

Analytics

#BIRT

Comments

mathias

Exasol has a nearly complete set of drivers: 
- a platform-independent JDBC 3.0 driver 
- an ODBC 3.5 driver für Windows (>= Windows 2000) and Linux (unixODBC). I think there are 32bit and 64bit versions. 
- an ADO.NET 2.0 data provider with extensions for MS SQL Server 2005 Reporting and Integration Services 
 
If your application follows the standards of the interface used, there should be no big problems connecting to Exasol DWH. The software is known to be compatible to the big commercial BI tools, e.g. Business Objects, MicroStrategy, SAS/Base, Cognos. 
 
On their website (www.exasol.com) you can download an english whitepaper with a little more information.

ramganesh

I am conecting the BIRT report tool to databse SQL server . It's connected

but ISERVER express is not view the page some wrror will be disply

This error is dilpay

Cannot open the connection for the driver:org.eclipse.birt.report.data.oda.jdbc
faild to get connection.
SQL error #1: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified..

if possible pleease rectify

ramganesh

ramganesh wrote:

I am conecting the BIRT report tool to databse SQL server . It's connected 
 
but ISERVER express is not view the page some error will be disply 
 
 
 
This error is dilpay 
 
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc 
faild to get connection. 
SQL error #1: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.. 
 
if possible pleease rectify

ramganesh

ramganesh wrote:

I am conecting the BIRT report tool to databse SQL server . It's connected 
 
but ISERVER express is not view the page some error will be disply 
 
 
 
This error is dilpay 
 
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc 
faild to get connection. 
SQL error #1: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.. 
 
if possible pleease rectify

ramganesh

ramganesh wrote:

I am conecting the BIRT report tool to databse SQL server . It's connected 
 
but ISERVER express is not view the page some error will be disply 
 
 
 
This error is dilpay 
 
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc 
faild to get connection. 
SQL error #1: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.. 
 
if possible pleease rectify