Hi Samuel,


I have had a look at the Odatasite. It looks like it�s just a service you use to connect to a data set.
Yellowfin generally connects to the data directly, so bypassing Odata.
We support all major DB drivers, so it�s all very straight forward.

If you would like Yellowfin to connect to Odata, you would need to find a JDBC driver to connect to it, and ensure that the driver can take SQL queries and translated it so that Odata can understand and process the query.
You can then just drop the driver into Yellowfin and connect : http://www.yellowfinbi.com/YFForum-How-to-add-a-new-JDBC-drivers-for-use-in-Yellowfin-?thread=108357

But out of curiosity, wondering if you would actual need to connect to Odata, as you may be able to connect to the DB directly ;).

Regards,
David

Hi David,

Thanks for your response. The client wants to utilize an OLAP cube that uses an OData connection to connect to third-party applications.


Regards,
Samuel

Hi Samuel,

Thanks for the extra info.

In this case, Yellowfin would need to connect to the cube via XMLA .

Regards,
David

Hi,

I've added the OData JDBC-driver from CData as described above, so the Data Source is working:



However, when making a simple view on one table (no joins) it cannot preview data and also reports return an error.

Any suggestions?

Johan

Correction: I forgot to run the setup.jar on the host itself. After doing this, it works. Still, is YellowFin going to support OData natively? It is, after all, a webservice mimicking a database connection.

Hi,

We can certify the driver and then include Odata in our connection wizard, but the user will still need to supply the JDBC driver itself, as it doesn't seem to be a free open source driver.

However in order to certify the driver, we would need you to provide us with a copy of it and access to a test environment that will allow us to perform some standard tests.

Regards,
David