Link to home
Start Free TrialLog in
Avatar of yechan
yechanFlag for United States of America

asked on

Available database tables in Lotus Notes

Hi Experts,

how can I find out all the tables available in Lotus notes?  I have created an ODBC connection in SSIS but now I do not know how or what SQL statement(s) to issue in order to get data out of Lotus Notes.  I'm using Lotus Notes 8.5.2 and trying to dump data into SQL Server.

thank you
Avatar of Bill-Hanson
Bill-Hanson
Flag of United States of America image

I'm not sure of the commands either, never used ODBC with Domino data.  I have used COM, and can explain that, but yuch!

The best solution is to setup a webservice on the domino server to serve up the data to your SSIS app.
ASKER CERTIFIED SOLUTION
Avatar of doninja
doninja
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
according to this article: http://www.builderau.com.au/architect/database/soa/Create-an-ODBC-connection-to-a-Lotus-Notes-database/0,339024547,320282240,00.htm

you should get all views (ie tables) and forms listed... if setup properly...


Avatar of Sjef Bosman
All solutions to connect to a Notes database via ODBC require NotesSQL, see doninja's post.

There is one alternative to importing the data from the SQL server side: export the data into SQL server from the Notes side. Could be much easier. You need the Domino Designer client to create the procedure (usually an agent). The language you can use, LotusScript, closely resembles VB, so 90% shouldn't be too hard to do.
Avatar of yechan

ASKER

This is freaking fantastic.  I used doninja suggestions and it works.  many thanks.

Ye-Chan