Your not a IBM Notes XPages or a Lotus programmer, but you need the data. The XPages guys are working on big projects and your very low on their priority list. Your boss doesn’t care, he needs a report A.S.A.P. We have a solution for you until those XPages guys get free time. There is a NotesSQL driver. It has been around for a very long time. You can mine and pull data from Notes applications using MS Excel, MS Access or some other tool. You may even be a Business Intelligence person and your using Oracle SQL Developer to pull in data from Oracle and Notes into one report.
Your thinking this guy knows me … yes this article is written for you
Here is how you get started. Download the IBM NotesSQL driver. I’m using Notes 8.5.3. You can get your version by opening your Lotus Notes client and viewing help about IBM Louts Notes. You’ll see something like this:
IBM Lotus Notes 8.5
Revision 20121116.0820-FP3 (Release 8.5.3FP3)
Visit the download page to download. You will need to create a user name and password. Then click download in this category:
IBM Lotus Notes SQL Driver V8.5.3 for Windows English eAssembly
IMPORTANT NOTE: You will need the 32 bit NotesSQL driver. You will need the 32 bit Lotus Notes client and you will need a 32 bit application to use the NotesSQL driver. This means you need a 32 bit MS Office installed.
After the download run the install.
When the installation starts, keep clicking next keeping all the defaults until you click Finish. When you click Finish, the installation is done.
After the install is complete, please restart your computer. When you system is back up, check that ODBC driver is recognized by MS Windows. Open the 32 bit version of the ODBC Data Source Administrator odbcad32.exe.
IMPORTANT NOTE: Another gotcha, by default control panel launches the 64 bit ODBC Data Source Administrator, you will need to launch the 32 bit one yourself located at C:\Windows\SysWOW64\odbcad32.exe
IMPORTANT NOTE: Your c:\…ibm\lotus\notes needs to be in your system environment variable %PATH%
Now, what you need to do is create a DSN for every database you want to access in Lotus Notes. You will be prompted with your password whenever accessing Lotus Notes databases. So you will get prompted for your id and password. You will also get prompted when running queries also.