I have Lotus Notes application, and a lot of people insets data inside this application. For different reason I need those data also copied into MSSql database, for other programs to use it.
Right now, we use export data to excel and insert them to MSSql database, but this has some drawback. As first we export to excel daily, so data inside MSSql database are not current. And second is that is needed a man labour.
My task is to fix this. I could probably implement job that automatically create export and then import to MSSql, but I am looking if there is a way to replicate data between those two databases.
Has someone some experience in this? The best solution would be replication of the databases. Second best solution would be to catch trigger when data is stored in Note database. I read that Notes use Java. Do anyone know if you could catch trigger when data is stored into database.
I am using Lotus Notes 8.5
I'm just going to answer your last question. The rest is really too broad. There are many, many ways to synchronize data between a Notes/Domino database and MS SQL Server or just about any other database. There are a lot of 3rd-party products that can do this
But now I'll answer this: Second best solution would be to catch trigger when data is stored in Note database. I read that Notes use Java. Do anyone know if you could catch trigger when data is stored into database.*
The answer is yes, you can catch a trigger. There is a set of Notes C API routines known as Extension Manager that is designed specifically for that. The C API is quite complex, requiring deep knowledge of Notes programming, and the EM routines add another layer of complexity. Fortunately, though, there's an open source project called Trigger Happy on the OpenNTF site that gives you the code you need for an Extension Manager routine that can invoke a Java agent when it catches an NSFNoteUpdate event.
Note, however, that Anyone with even modest experience with Notes would have already known that it supports Java, so I suspect you are very new to this. Trigger Happy makes this task a lot easier than writing your own Extension Manger routines, but it doesn't get you off the hook from having to learn quite a lot about Notes and Domino in order to do this job - including a lot of learning about how to use the Notes Java API and at least learning the basics about how Extension Manager works and about the events that it can capture.
Even with Trigger Happy, I would still recommend that you engage the services of someone who has done this sort of thing before. It's going to be capturing events on your server and running code on your server. If not done well, this could easily slow your server down (a lot!) or even crash it.