Connect to OLAP database using jdbc4olap driver

5 次查看(过去 30 天)

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

回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by