topic Re: Migrate existing data in Alfresco Archive

Migrate existing data

insanity5902 — Fri, 06 Feb 2009 17:13:44 GMT

Hello Everyone, First post, I hope it is in the right spot.Currently we use a system from Exact software called e-Synergy. It seems it stores all it's information in MS SQL, including documents and attachments.Does anybody know of a way to import this data, besides doing it manually?Has anybody look

Re: Migrate existing data

mdutoo — Tue, 26 May 2009 17:12:37 GMT

Hi

You can use the Open Source ETL tool Talend 3.1 and its Alfresco connector to import data (taken e.g. from a database or anything Talend can look into, in your case probably the MS SQL database of e-Synergy) into Alfresco as any kind of Alfresco content (documents, folders, custom…).

Otherwise there is an ACP generator (but I didn't test it) or you could develop a specific automated action, but that probably would amount to more work.

Some links :
Talend 3.1 including the Alfresco connector is available at http://www.talend.com/download.php
Its Alfresco connector has been contributed on the Alfresco forge at http://forge.alfresco.com/projects/etlconnector/
More information at http://knowledge.openwide.fr/bin/view/Main/AlfrescoETLConnector

Re: Migrate existing data

groutal — Mon, 15 Jun 2009 14:21:20 GMT

Hi Mdutoo, thank you for the information. About Talend Open Studio, it is an open source ETL tool for data integration experts with a user-friendly GUI, easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component which allows the user to get a graphical and functional view of integration processes. For more information: http://www.talend.com/