Getting data from MS SQL database to Lotus Notes Database

1
votes

I know this is a weird thing to do and the question would be asked, why... Anyhow, I have a project being started in association with integration and I was thinking about asking the question here to get a little think tank going and probably find the first "string/line" to pull on to get this tangled web to start unfolding in my head.

I know that Lotus Notes/domino DB is not a relational database and that the work to get it to work with an MS-SQL-database has been documented and talked about around the net. Also that probably every single case is unique.

But what's asked here is for the MS-SQl-Database information/data to be imported to Lotus Notes Database in some way. I don't have a Totally clear picture of how the information will be used exactly, but what I am looking for is the integration part between the two databases.

What is an effective way of doing this? Is it through the use of some kind of API or endpoint technique or maybe through some file export(example CSV-file) > Storage (example FTP) > import (example CSV-file)?

---EDIT---- This will be a periodically import of data. Also just out of curiosity would this be able to be done as an "on demand" import?

I would very much appreciate any kind of ideas, brainstorming or suggestions!

1
sql-serverdatabaseintegrationlotus-noteslotus-domino
Is this a one-time import? Or do you need to do an import and then periodically re-import? Or an import and then real-time synch (one direction, or both directions)? – Richard Schwartz
Ah forgot to mention that, it will most likely be a periodically import. – John
How much tables should be imported in Domino? What type of use/request should be performed on the data? – Emmanuel Gleizer

1 Answers

2
votes

There are lots and lots of options.

If your organization has Lotus Enterprise Integrator licensed, I'd look at that because its purpose in life is to connect Domino to database systems for exports, imports, synchronization, etc. Otherwise, I might look at (believe it or not) Tivoli Directory Integrator, which is a free entitlement for Domino customers; it's not really just for directories and it can connect to SQL Server. And you could, of course, just code it as an agent the Domino side using the Lotus Connectors LSX - which may or may not be easier than using TDI, and is certainly more lightweight.