Notes data move to MongoDB

Stanislav Marszalek  30 September 2014 09:57:11
We have already written several articles about the document-oriented database MongoDB. For many properties similar to IBM Notes we use it in our web applications based on PHP and Symfony. For purpose of data synchronization from Lotus Notes to MongoDB we've developed a converter. Document-oriented nature of MongoDB database allows the transfer lot of different data types, such as RichText, attachments or multi-valued fields.
The converter itself is in the form of Lotus Notes application and you can set up entire data synchronization there. The configuration contains:
  • Notes server and file path
  • Form name for data filtering
  • Last modification data to fine tune synchronization
  • Field mapping
blog2014_09_11_01 style=
blog2014_09_11_02 style=
 
Field mapping is done in the form of separate documents, where you can specify:
  • Lotus Notes source data - it may be a single field, formula or attachment
  • MongoDB field name
  • Multivalue field type
  • Field Type – apart from common field types, such as text, number, date, it also supports RichText (they are converted into HTML) and Attachments (which are stored in GridFS, file store of MongoDB)
The synchronization can be run manually or periodically. It uses Lotus Notes document unique ID as a main key to properly connect all related data..


blog2014_09_11_03 style=

Comments

1Adam Brown  01.10.2014 5:42:10  Notes data move to MongoDB

Great stuff. Very interesting.

Do you have a way of managing Reader/Author fields and how they translate into MongoDB from a security perspective?

2David Marko  01.10.2014 9:35:58  Notes data move to MongoDB

All Readers (the same for authors) fields are mapped to the one array fieĺd in Mongodb. Then, when quering MongoDB, we add this readers field criteria to the entire query. Not difficult. In our projects we use ElasticSearch together with MongoDB, so we query the view data from ElasticSearch the same logical way.

3Pitt de Waard  11.11.2014 12:10:42  Notes data move to MongoDB

where to buy/download?

4Brian Stitt  13.12.2014 14:24:14  Notes data move to MongoDB

Where can I download this Notes application for testing?

5Ramanjaneyulu  07.10.2015 7:44:16  Notes data move to MongoDB

Iam trying to move Lotus nsf files into Mongo DB. Please provide me the download link

6Patrick Kwinten  30.03.2016 9:25:14  OpenNTF project?

Would you be willing to share your application to the Notes community. This could be a great starter for developers to experience with alternative data storage

7usps tracking  18.02.2017 17:02:54  Notes data move to MongoDB

{ Link }

TOPlist