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
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
Lotus IBM
Last Comment
yechan
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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...
you should get all views (ie tables) and forms listed... if setup properly...
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.
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.
ASKER
This is freaking fantastic. I used doninja suggestions and it works. many thanks.
Ye-Chan
Ye-Chan
The best solution is to setup a webservice on the domino server to serve up the data to your SSIS app.