Lotus Domino

1
Lotus Domino RDBMS Integration --Domino
????????
??? Angus Lo Angus_Lo_at_pchome.com.tw
2
This Presentation
1.About Using ODBC 2.About Using Lotus Script
Extension (LSX) 3.About Using JDBC 4.About Using
Middleware Solution 5.???? 6.JDBC Demo
3
About Using ODBC
ODBC (Open Database Connectivity) ? SQL Access
Group ??? (Microsoft ?????), ? Microsoft ????????
ODBC ?????, SQL Access Group ??? X/Open
International Association ????? 
4
About Using ODBC
???? Lotus Script ,Formula ?? Client-Server
??,??Multi Thread ,???????????,??????
,??????,???????? ?? ??Client ? ???ODBC Driver
,?????Client ??????
5
About Lotus Script Extension (LSX)
LSX (Lotus Script Extension) Provides natives
Access through Database Client ??Native Driver ?
RDBMS ?? (DECS Bundle) DB2 UDB Oracle
Sybase ODBC EDA/SQL File and text systems 
6
About Lotus Script Extension (LSX)
???? Lotus Script ?? Client-Server
??,???????Native Driver ,???? ?? ??Client ?
???Database Client ,?????Client ?????,???Multi
Thread ,????????
7
About Using JDBC

• JDBC (Java Database Connectivity) JDBC ??? ODBC
  ??, ??? Application, Driver Manager, Driver,
  Database Engine ??
• JDBC driver ??? ???????
• ??????
• ?? connection
• ?? statement
• ?? statement
• ????
• close statement
• close connection

8
About Using JDBC
About Using JDBC
??JDBC ??
9
About Using JDBC
???? Notes Java Pure JAva ?? Client-Server
??, ??Multi Thread ,??JDBC ????,???client
??,???,?????Client ??????? ?? ???Java ?????
10
About Using LEI
???? ?? 3-tier ??,???????Native Driver
,???,????????,????????? ?? ??????(50 ???)
,????????????????,?????????????, ??????????,
????????JDBC?
11
(No Transcript)
12
????Methods of Integration between Domino and
RDBMS
1._at_DbFunctions 2.Lotus Script Data Option
(LSDO) 3.Lotus Script Extension (LSX) 4.Java
Program 5.Native nonProgrammatic access RDBMS
(DECS) 6.Server to Server (LEI) 7.Domino Access
through Transaction SystemCICS ,MQSeries ) 
13
????(1)
14
????(2) Programmatic access VS.
nonProgrammatic access (JDBC VS. LEI)
Triggered Processes ? Real-time process LEI
(Server base) gt JDBC (Client base) ? Scheduled
process JDBC LEI ? Event-driven process
JDBC LEI Database Migration JDBC gt LEI
15
????(3) Programmatic access VS.
nonProgrammatic access (JDBC VS. LEI)
Software Development Cost JDBC (Programmatic)
gt LEI (nonProgrammatic) Hardware Cost LEI (
middleware Server Domino Server ) gtgt JDBC
(Domino Server) TCO (Total Cost Ownership)
LEI gtgtgt JDBC
16
JDBC Demo
17
????
??? Angus Lo (achen_lo_at_ms36.url.com.tw) ?? ?
???????? ?? Lotus Notes , Java ,
Delphi ?? ?????????(????) ??????????? Run PC
?????? ?? Lotus Certified Professional (Lotus
Principal CLP ) CLP Java
18
Thank You??????