Database Reporting and Schema

Hello!
HAs anyone created an ODBC connection to the OpenNebula database and produced any custom reports (outside the built in reports) or made database queries. If so, where could I find a schema and how did you make a connection?
Any help would be appreciated. Thanks.