topic Re: Alfresco & XML databases in Alfresco Archive

Alfresco & XML databases

jeroen — Wed, 22 Jul 2009 12:01:47 GMT

Hi,Has anyone experience in using an XML database (e.g. Berkeley DB XML) for Alfresco? The xml objects (files) in the database would contain both the data (that is, links to the files stored in a directory) and metadata. So, the objects would be represented using a kind of wrapper format (e.g. METS

Re: Alfresco & XML databases

norgan — Thu, 23 Jul 2009 08:53:19 GMT

Hi Jeroen,
you have to distinguish between the repository and the clients.

The repository supports a set of SQL databases and provides a set of interfaces APIsto the "top" and "side", namely JCR, CMIS, Webdav, CIFS, SOAP, REST and some others, I am sure. The interface towards the database uses hibernate. So either, you have a hibernate interface for your database, or the work to use an XML database for that should be considerable, I guess. But maybe, somebody here has done an SQL -> XML migration here?

The clients can do, whatever you want If your database implements a webservices or JCR interface, you should be up and going in no time. But only for the logic, you implement yourself in the client.

Norgan

Re: Alfresco & XML databases

groutal — Fri, 07 Aug 2009 10:03:11 GMT

If you would like to perform a SQL to XML data migration, you can use Talend Open Studio.

It is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes.

For more information: http://www.talend.com/