CODEWITHSUNDEEP
jdbcssasxmla
Alvaro VS
Alvaro VS

Reputation: 203

Connecting through XMLA using JDBC

I'm trying to connect to SpagoBI using a XMLA data source.

This is my JDBC URL: 

jdbc:xmla:Server=http://localhost/olap/msmdpump.dll;

And I'm using this driver:

com.microsoft.sqlserver.jdbc.SQLServerDriver

I'm trying to connect to a SSAS cube. This is how the configuration looks like now:

Data source

But Tomcat keeps telling "no suitable driver found".

Any thoughts?

Thanks!

Update:

I wasn't using the correct driver. the SQLServerDriver is only for SQL Server, not for SSAS. Does anyone know what driver could I use?

Upvotes: 2

Views: 2905

Answers (1)

Andrei Nicusan
Andrei Nicusan

Reputation: 4623

The SQL Server driver has a purpose for connecting JPA-based applications to relational databases based on MSSQL Server. MS Analysis Services is not a relational database; it is a OLAP solution for storing data cubes.

You need to find another way to connect to MS Analysis Services. One solution is to send XMLA or MDX queries to the URL you posted (actually, to the DLL) using a socket connection or an HTTP client.

Upvotes: 2

Related Questions