String strPartFamily = MqlUtil.mqlCommand(ctx,'temp query bus Part * * select attribute') īut again this is java based solution and not VBA.įinally 3DEXPERIENCE provides MQL console in server, to play around with all the data using SQL like queries in more developer friendly manner.

Using this ADK you can also call MQL queries and work seamlessly.

You can get the context by running above java code from your local eclipse. ('Is context set '+ctx.isConnected()) Īs you mentioned you are currently using 3DEXPERIENCE then 3DPassport might block above URL method connection, So you need to pass NO-CAS URL. matrix.db.Context ctx = new matrix.db.Context(' ctx.setUser('Test Everything') Sample code shows how you can get the context and work with Enovia ADK. Then you can make use of that service in to your vba function.Īgain you have to decide the kind of data whether xml or json it is separate topic.Īs I told earlier Enovia is Java based application, It provides JAVA ADK to extend its functionality. For this you will need server access and first you have to write some java code (Rest/SOAP service) and update the class/jar into 2014 server (tomcat). However webservice can be used communicate between applications of different platforms or managed by different programming ADK.įor this you need to create your own service (REST/SOAP). You have to try SOAP based service or JAX-RS.Įnovia is java based application and doesn't support VBA ADK to directly work with backend data.

I figure I could make some simple python scripts then call them through the python interpreter from excel with shellexecute but that is not a very elegant solution I think.Ībove mentioned Rest framework may not be available with 2014X version. I'm ok with learning some python to do this but my main program and user interface is in excel. I'm not sure if they will allow me to do what I want. I am not familiar with python nor these two projects. I found two projects that might allow Excel/VBA to talk to python components or at least to python scripts. I would like to access this interface in VBA directly but I didn't find anything to that effect. I would like to query Enovia from inside Excel / VBA.Īfter some search, Enovia seems to have a programming interface called Abaqus.

How to use eclipse with enovia