Migrate existing data

[insanity5902]

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 looked into, or actually performed, a migration from e-Synergy to Alfresco?

I've tried searching google and alfresco sites and couldn't find anything with regards to e-Synergy

I just thought of these, are their services out there that perform automated migrations?

I look forward to your responses.

[mdutoo]

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

[groutal]

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/