Solved

Available database tables in Lotus Notes

Posted on 2010-11-10
5
900 Views
Last Modified: 2013-12-18
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
Comment
Question by:yechan
5 Comments
 
LVL 22

Expert Comment

by:Bill-Hanson
Comment Utility
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
 
LVL 10

Accepted Solution

by:
doninja earned 500 total points
Comment Utility
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
 
LVL 5

Expert Comment

by:iPinky
Comment Utility
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
 
LVL 46

Expert Comment

by:Sjef Bosman
Comment Utility
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
 
LVL 1

Author Comment

by:yechan
Comment Utility
This is freaking fantastic.  I used doninja suggestions and it works.  many thanks.

Ye-Chan
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now