ODBO

[linvicch]

Extremely frustrating

Does JS support all ODBO driver or only jaspersoft odbo?

Is there an evaluation version of jaspersoft ODBO?

Can jaspersoft ODBO be used with any other product such as business object?

We have a oem version of JS pro. does that come with jaspersoft odbo?

 

Any form of reply will be helpful as there has been nothing helpful at all so far

Thanks :)

[mpenningroth]

JS cannot support all ODBO Drivers because some ODBO drivere are specific to an analysis engine.  (SSAS for Microsoft for example, there are many more.)

Some ODBO drivers are written to use XMLA protocol.  (Simba, Jaspersoft ODBO Connect, and others), these in theory should work with any analysis engine that support XMLA, BUT not all XMLA implementations are equal.  Microsoft for example has extended the XMLA spec with additions for SSAS.

I have used JS ODBO Connect to access SSAS, Pentaho, and of course Jasperserver.

(BTW If the analysis server comes with an ODBO driver, I would use that one first.)

In your previous post on this subject, you were asked if you have ever gotten an XMLA client to connect to your JS, and I believe there were some issues.

You will have no chance of getting any XMLA based ODBO driver to access JS until this is configure properly.

I recommend you use Wharehouse Explorer as an XMLA client to ensure that all your xmla definitions are working before you try an ODBO driver.  You can get that here: http://sourceforge.net/projects/whex/ 

I have seen problems using an XMLA connection with jpivot analysis views, so I usually

I am not sure whether or not JS Pro comes with ODBO Connect. 

Do you have a support agreement with Jaspersoft?  If so you may want to get some help at least with the xmla configuration.

[linvicch]

Hi mpenningroth,

I have manage to get the jasperserver xml/A client to connect.  All that was needed was a restart of the server.

I have a oem version of JS-pro from our vendor. From the sound of it, Jaspersoft odbo should be the same as simba which is the driver I am using. At this point I am certain that my xml/A is properly configured.

I am also certain that my simba driver is properly configured as I am able to successfully connect to xml/A, able to view its schema and cube. I was also able to successfully connect using excel 2007 if i keep on re-trying the connect after it threw a "unable to initialize datasource error".

Thank you for taking time in helping me out. Sadly none of the jaspersoft administrator seem to know much about this.

Thak you once again

[mpenningroth]

You are quite welcome.  Yes I have also noticed that you need to recycle your app server in order to see changes to XMLA definitions exposed.  Maybe a change listener would be in order.

I have not used Simba ODBO in quite a while and I no longer have a license.  You should give the Jaspersoft ODBO Connect a try if you can.

 

Regards,

  Mark

[alexal]

I've downloaded Wharehouse Explorer and connected to ip:port/jasperserver/xmla. It shows only foodmart and shugar cubes. 

My own analysis views have only mondorian connections defined right now, so they can be viewed from the browser. What should I do on server-side to make whex see them too?