Connect to OLAP database using jdbc4olap driver

5 views (last 30 days)

I am trying to connect to an OLAP database. I know that MATLAB cannot connect to multidimensional databases natively, and need JDBC drivers. I followed the instructions here. I have downloaded and properly registered the driver in the javaclasspath. Therefore, when I call the function javaclasspath, the six jar files for the driver are shown correctly at the end of the results.
D:\Program Files\MATLAB\R2022a\java\JDBC\activation-1.0.2.jar
D:\Program Files\MATLAB\R2022a\java\JDBC\commons-codec-1.3.jar
D:\Program Files\MATLAB\R2022a\java\JDBC\jdbc4olap-1.1.4.jar
D:\Program Files\MATLAB\R2022a\java\JDBC\mssql-jdbc-11.2.0.jre18.jar
D:\Program Files\MATLAB\R2022a\java\JDBC\saaj-api-1.3.jar
D:\Program Files\MATLAB\R2022a\java\JDBC\saaj-impl-1.3.jar
Then I open the Database Explorer app using the following function.
databaseExplorer ();
Next, I open the JDBC Data Source Configuration window and enter the details.

After clicking Test, I enter my credentials. But I get the following error messages in the JDBC Database Configuration window and Command window, respectively. I need to know which settings should be changed. Any help is appreciated.

Aug 31, 2022 8:29:57 AM com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection post
SEVERE: SAAJ0009: Message send failed
Aug 31, 2022 8:29:57 AM org.jdbc4olap.xmla.XmlaConn discover
INFO: Error in soap call: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
Aug 31, 2022 8:29:57 AM org.jdbc4olap.jdbc.OlapNonRegisteringDriver connect
INFO: Connect error

Answers (0)




Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!