Alfresco Integration with MongoDB

[abhishek_talukd]

We are integrating #Alfresco With #MongoDB.
We have identified and developed mechanism to perform CRUD operation from Alfresco to MongoDB.
While performing write operation from Alfresco to MongoDB , we have seen that a copy of the record is also storing in Alfresco Database like PostgreSQL/MySQL along with MongoDB. We want to do away with this duplicate of records.

Could any one of you please let us know or guide us to develop a mechanism , so that we can stop the information to be stored in Alfresco back-end database and only stored in external Database like MongoDB.

Thanking you all in anticipation.

Regards,
Abhishek

[mrogers]

Alfresco needs a relational database.   Which Mongo cant do.  But it is very useful for what it can do!  

[abhishek_talukd]

Thanks a lot for this information. But practically if we want to use MongoDB along with Alfresco, is there any way we can store some selective information in MongoDB only and not in alfresco default Relational Database. Otherwise this will cause data redundancy. Any idea will be great help for me.

[mrogers]

Mongo is great for the content and by definition any stuff that is not relational in particular audit and monitoring stuff.   And perhaps configuration.   

You could probably move tables like the attribute and patch to mongo.   however the important tables (to alfresco) like node, node_property and value need to be in a RDBMS.