Use Lei technology to exchange notes and SQL2000 data

. [Preface]
This article focuses on Lotus Domino /Notes and Its Lei tools, tested and passed Use Lei successfully exchanged notes with SQL2000 and formed a written report form. Requirement And hope to deepen your understanding Notes .
Although this article describes the flexible use of lei from the perspective of SQL2000, its implementation method can be used as "relational Database [DB2, Oracle, Informix...] Data Interaction with notes ", and so on.
2. [Purpose and principle]
Use Lei tools to connect notes to SQL databases. (For example ):

It can be seen that Lei actually starts from an intermediate ServiceTool It enables different databases to exchange data through its connection and activity documents.
3. [environment description]
The testing machine has two PCs. The hardware and software configurations are as follows ():

One for Domino/Notes server and lei Server And notes Customer End-to-End installation, one for SQL2000 Install And the two are connected through TCP/IP.
4 .【 Software Preparation]
Domino/notes5.0.8, lei3.2, and SQL2000 (including servers and clients ).
5. [intended audience]
Master the installation and configuration of Domino/Notes, and understand the basic concepts of Notes database (pages, views, Form , Domain, etc.); Master SQL2000 installation and configuration, understand the concept of database creation and modification, and table; Master odbc SQL data source configuration.

Lei Principle

Test Environment PC Configuration

Qingzhou replied to: 12:54:12. [implementation steps]
A) Lei Installation
I. Preparations before installation
The Domino server has been installed and configured. If it is installed on the Domino server machine, close the Domino server first. If it is not installed on the server machine, run the Domino server first. In this test, Lei is installed on the server with Domino/notes5.0.8 installed. The name of the server is testlei/lei. And create a new two-domain Notes database testleid. nsf. Create a new two-data metadatabase on the SQL2000 server (do notSetAnd Connect ODBC to the database on the Lei server.
Ii. Run lei3.2 to installProgram
The first two steps are as follows: accept the agreement and click Next. Select the first one in the type of installtion box (because it is the first installation)

Qingzhou reply: the server information dialog box appears at 12:55:14, 2004-06-18. enter the name of the Lei server installed and the name of the installed Domino server.

Qingzhou replied to: 12:57:02 click Next. In the displayed dialog box, select "yes" because it is installed locally. The following dialog box appears:

Qingzhou replied to: 12:58:15 fill in the backup data directory, with the management database and logs of the Lei ServerFileDatabase Name. Click Next without modification. What appears is to increase the Lei server.ManagementMember dialog box. By default, all Domino members are displayed. click Next.

Qingzhou replied to: 12:59:56 because it was the first installation, select "no" and a dialog box (such as) appears ):

Both options are selected. It will be used by default until installation. After installation, a registration will appear.Product. Press the "exit" key. Finally, the system prompts whether to restart the computer. Select "yes" to restart the computer immediately. So far, the installation is complete.

Qingzhou reply to: 13:01:09 B) Lei startup
Find the just-installed lei in the program and click "Lotus entERPRise integrator to start the Lei server. After startup

You can also start it on the Domino server and enter "load Lei addin" on the console. This server is started on the console.

Qingzhou reply to: 13:04:35 c) Lei Introduction
Open notes, and open the management database of the Lei server,

After opening,

Lei is mainly used to establish a connection to different databases and exchange data between different databases. "connection" H and "activity" need to be configured. The first one is used to connect to the database, the latter is used to define data exchange rules, that is, the data exchange between two databases. This is the data exchange between notes and SQL databases. Therefore, we need to create two connections (one connecting notes and one connecting SQL) and two activities (one from notes to SQL and the other from SQL to notes ).

Open notes and open the management database of the Lei Server

It appears

Qingzhou reply to: 13:06:45 d) create a connection
I. Create a connection to the notes
Click "creat connection" and select "Notes" in the list box:

Fill in the connection name in "Connection Properties", the name of the Domino server, and specify a specific Notes database for data exchange with SQL. The rest can be used by default. Save and exit.

Qingzhou reply to: 13:08:11 II. Establish a connection with SQL
Connect to the SQL database through ODBC and select "ODBC" in the type list ".

In "Connection Properties", enter the connection name, data source name, andUserName and password (provided by SQL), and others can be used by default. Save and exit.

Qingzhou reply to: 13:09:27 III. connection test
In the run window, enter the Lei Server Directory and add "nlctest" for testing.

After confirmation, you can test the connection between ODBC and Domino respectively. If the test is successful, proceed to the next step.

Qingzhou reply: 13:12:11 e) Create "activity"
Click "creat activity" and select "direct transfer" in the list box:

This is an important step. It defines the form and table fields and fields between two different databases for data exchange. Therefore, enter a table to indicate the important items:

Save and exit.