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!