question

technette avatar image
technette asked

Import Lotus Notes Database

Can we import a lotus notes into SQL database?
lotus-notes
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
It is possible to connect to Lotus Notes databases via ODBC. See [ ConnectionStrings.com][1] for more info. So, in theory, you could do one of the following: - create a linked server to the Lotus Notes database and import data from there - use SSIS to import data - use [OPENROWSET][2] queries to connect to the LN database and extract data. EDIT - Reaction to your comment about ODBC drivers... If you can't install the ODBC driver for Lotus Notes on the SQL Server in question, then you'll have to use the SSIS option, setting up the SSIS package to run on a third server... [1]: http://www.connectionstrings.com/lotus-notes [2]: http://msdn.microsoft.com/en-us/library/ms190312.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg avatar image
Oleg answered
This [article on Database Journal][1] site provides a very comprehensive list of steps involved in connecting lotus and SQL Server. Basically, it includes installation of the Lotus Notes Client on the box hosting your SQL Server instance and installing and configuring the [NotesSQL ODBC driver][2]. Oleg [1]: http://www.databasejournal.com/features/mssql/article.php/3462011/Connect-to-Lotus-Domino-using-SQL-Server-Linked-Server.htm [2]: http://www.lotus.com/
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@Oleg - between the two of us, we seem to have covered it... ;-)
0 Likes 0 ·
Thank you very much. Both of the answers are great. I had to recommend the first incase we do not have access to the server. Thomas and Oleg, you are fantastic!!!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.