Accesing OMERO database using query language

[shaneklumpp]

I am exploring how to access data in OMERO directly from the underlying database using a query language (e.g. SQL).

Is there a best practice for this?

Also, is the OMERO database schema documented somewhere, and how could I find this?

Thanks

[atarkowska]

Hi,

OMERO API supports two principle ways of querying OMERO and retrieving the objects. You can write SQL-like queries using the query service (uses “HQL”) or you can use one of the other services that already has suitable queries. Using the query service is very flexible but it requires detailed knowledge of the OMERO model and is susceptible to any change in the model.
For more details please follow the http://www.openmicroscopy.org/site/supp ... arted.html

Depends on your programming language preferences you can find relevant training examples in our github repository https://github.com/openmicroscopy/openm ... s/Training

I hope that will help.

Please do not hesitate to ask more specific questions.

Ola