Lotus Notes SQL. What is NotesSQL?
Lotus Notes SQL. What is NotesSQL?
| Answer | From IBM website
http://www.lotus.com/products/product4.nsf/wdocs/3243f3d81944584085256e20006db691
NotesSQL is an ODBC (Open Database Connectivity) driver for Notes and Domino. It allows ODBC-enabled data reporting tools, database tools, and application development tools to read, report, and update information that is stored in Domino databases (.nsf files). With NotesSQL, end users and application developers can integrate Domino data with their applications using tools such as Crystal Decisions Crystal Reports, Microsoft Visual Basic, Access, Brio and Lotus Approach. Even Internet application development tools that support ODBC can access Domino data. IT professionals can enable their existing ODBC-enabled applications to access data stored in a Domino database.
A Domino database is not relational, but with NotesSQL a Domino database looks like a relational data source to an OBDC-enabled tool. This allows relational database management systems (RDBMS) such as Oracle or DB2 to issue SQL (Structured Query Language) statements to Domino.
From Notes411
There is an important concept to remember and that is a Lotus Notes document may conatin varibale length fields and variable element fields. Pure SQL cannot do this. So when reporting with NotesSQL you may find that some views in SQL terms seem to contain much more data then the Notes View in a Lotus Notes client. the SQL driver normalises the data into repeating rows of data for that document until the longest (upperbound) limit of the field with the most Elements.
|
| Attachments | -none- |
| Applies to versions | 4.x; 5.x; 6.x |
| FAQ Provided By | Steven Charles Robinson |
| Credit | |
 | |
|
|