Is it possible to query data with SQL directly?

[alex_chew]

Hi,

I have created many customized models in Alfresco. Now I want to generate report from these models with Pentaho report engine. Is it possible to query business data record from Alfresco by customized SQL?

Any advice will be appreciated.

Thanks and regards,
Alex

[jpotts]

Definitely not recommended. The Alfresco schema is not public and can change without warning.

If you must, at least build your reports against a replica of the data to avoid potential performance problems.

Jeff

[carlos_miguens]

As a further suggestion once you have exported the data I'd suggest you build some views and report on those, the Alfresco model is not very obvious and if it changes it means that you will need to just change your views rather than your report queries.

Carlos