Overview
SQL for Alfresco provides SQL access to Alfresco repository. Each content type and meta data can be queried with SQL. You can make natural joins on a very understandable data model.
SQL for Alfresco is an extension present on each Alfresco server. It is configured with SIDE/Alfresco.
Benefits
SQL for Alfresco provides the following benefits:
- Easy Integration through JDBC
- Well known query language
- Skill leverage through SQL
- Feature leverage through SQL
- Speed increase
- Understandable data model
Features
SQL for Alfresco provides the following features:
- SQL access to repository
- Joins beetween Alfresco content types
- Reuse of company's existing skills
- Ability to query Alfresco data model through SQL
- Integration with reporting tools
- Birt, JasperReport
- CrystalReport
- BO, Pentaho, SpagoBI
- Integration with office tools such:
- spreadsheets: Excel, Calc, ...
- wordprocessing: Word, OpenOffice, ...
- database tools: Access, ...
- Integration with ETL software:
Screenshots
Not applicable.
Demonstration
In construction.