topic Re: Is it possible to query data with SQL directly? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-query-data-with-sql-directly/m-p/250212#M203342 <HTML><HEAD></HEAD><BODY><SPAN>Definitely not recommended. The Alfresco schema is not public and can change without warning.</SPAN><BR /><BR /><SPAN>If you must, at least build your reports against a replica of the data to avoid potential performance problems.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Fri, 01 Jun 2012 15:21:22 GMT jpotts 2012-06-01T15:21:22Z Is it possible to query data with SQL directly? https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-query-data-with-sql-directly/m-p/250211#M203341 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 Fri, 01 Jun 2012 14:26:34 GMT https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-query-data-with-sql-directly/m-p/250211#M203341 alex_chew 2012-06-01T14:26:34Z Re: Is it possible to query data with SQL directly? https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-query-data-with-sql-directly/m-p/250212#M203342 <HTML><HEAD></HEAD><BODY><SPAN>Definitely not recommended. The Alfresco schema is not public and can change without warning.</SPAN><BR /><BR /><SPAN>If you must, at least build your reports against a replica of the data to avoid potential performance problems.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Fri, 01 Jun 2012 15:21:22 GMT https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-query-data-with-sql-directly/m-p/250212#M203342 jpotts 2012-06-01T15:21:22Z Re: Is it possible to query data with SQL directly? https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-query-data-with-sql-directly/m-p/250213#M203343 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>Carlos</SPAN></BODY></HTML> Mon, 30 Jul 2012 14:37:11 GMT https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-query-data-with-sql-directly/m-p/250213#M203343 carlos_miguens 2012-07-30T14:37:11Z