Solved

Available database tables in Lotus Notes

Posted on 2010-11-10
5
907 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 22

Expert Comment

by:Bill-Hanson
ID: 34106791
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
ID: 34110694
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
ID: 34110894
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
ID: 34112631
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
ID: 34121258
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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Why won't this building block macro run? 6 298
Email relaying to outside address 4 185
Lotus Notes to MS Exchange mailfile migration 4 80
Bulk lotus notes account creation 3 106
This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

734 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