Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 910
  • Last Modified:

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
0
yechan
Asked:
yechan
1 Solution
 
Bill-HansonCommented:
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.
0
 
doninjaCommented:
If you have NotesSQL installed then just start up Excel and use the Query Builder.
Once you point ata  database it will show you all the Views (tables in SQL) that you have available to reference and the relevant data.

You can then see if you need any views created by Notes Developer to get the data you need.
0
 
iPinkyCommented:
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...


0
 
Sjef BosmanGroupware ConsultantCommented:
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.
0
 
yechanAuthor Commented:
This is freaking fantastic.  I used doninja suggestions and it works.  many thanks.

Ye-Chan
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now