Aiming at Lotus Domino/Notes and its LEI tool, the exchange visits between Notes and SQL2000 were successfully tested and made by LEI, and a written report was formed. I hope to provide reference for friends who have related needs in the future, and also hope to deepen everyone's understanding of notes.
Although this paper expounds the flexible application of LEI from the perspective of SQL2000, its implementation method is different from "relational database [DB2, ORACLE, Informix.....] and annotations", thus drawing inferences from one another.
2. Purpose and principles
Using the connection and behavior of LEI tool to realize the connection between NOTES and SQL database. Schematic diagram (as shown below):
As can be seen from the figure, LEI actually acts as an intermediate server, which enables different databases to exchange data through its connections and active documents.
3. Environmental description
The tester consists of two PCs, and the hardware and software configurations are as follows:
One is used to install Domino/Notes server, LEI server and Notes client, and the other is used to install SQL2000, both of which have been networked through TCP/IP.
4. Software preparation
DOMINO/NOTES5.0.8, LEI3.2, SQL2000 (including server and client).
5. Applicable objects
Familiar with the installation and configuration of Domino/Notes, and understand the basic concepts of Notes database (pages, views, forms, domains, etc.). ); Familiar with the installation and configuration of SQL2000, understand the creation and modification of database and the concept of table; Proficient in ODBC configuration of SQL data source
Schematic diagram of thunder principle
Test environment PC configuration
-
Qingzhou replied: June 2004-1812: 54:12.
6. Specific implementation steps
A) install a) mine
First, the preparation before installation
Domino server has been installed and configured. If it is installed on a domino server, please shut down the domino server first. If it is not installed on the server, you should run the domino server first. This test is to install LEI on the server with domino/notes5.0.8 installed. The server name is testlei/lei. And create a new notes database testleid.nsf with two domains. Create a new metadata database with two data on SQL2000 server (don't set the primary key), and establish a good connection between ODBC and this database on LEI server.
Two. Run the LEI3.2 installer.
As usual, the first two steps are to accept the agreement and click next. Select the first one in the installation type box (because it is the first installation), as shown in the figure:
-
Qingzhou replied: June 2004-1812: 55:14.
The server information dialog box will appear and fill in the name of the installed LEI server and the name of the installed domino server. As shown in the figure:
-
Qingzhou replied: June 2004-18 12: 57: 02.
Click Next and select Yes in the dialog box that appears, because it is already installed on this machine. Then the following dialog box appears:
-
Qingzhou replied: June 2004-1812: 58:15.
Fill in the directory of standby data, and the names of the management database and log file database of LEI server. Without modifying the next point, a dialog box will appear, allowing you to add an administrator of the LEI server. By default, all domino members are selected. Click Next to open the dialog box.
-
Qingzhou replied: June 2004-18 12: 59: 56.
Since this is the first installation, select No and a dialog box will appear (as shown below):
Both options are selected. In the future, use the default settings before installation. After installation, a dialog box will appear to register the product. You can skip if you don't want to register. Press the "Exit" key. Finally, you will be prompted whether to restart the computer, and select "Yes" to restart immediately. The installation is now complete.
-
Qingzhou replied: June 2004-1813: 01:09.
B)LEI startup
Find the newly installed LEI in the program, and click "Lotus Enterprise Integrator" to start the LEI server. After startup, as shown in the figure:
You can also start it on the domino server and enter "load lei addin" on the console. The server is started on the console.
-
Qingzhou replied: June 2004-18 13: 04: 35.
C) introducing c) thunder
Open NOTES and the management database of LEI server, as shown in the following figure:
Appears after opening, as shown in figure:
LEI is mainly used to connect different databases and exchange data between different databases. What needs to be configured is "connection" H and "activity". The former is used to connect databases, and the latter is used to specify data exchange rules, that is, what kind of data exchange is carried out between two databases. This time, we exchange data between notes and sql database, so we need to create two connections (one connecting notes and one connecting sql) and two activities (one connecting notes to sql and the other connecting sql to notes).
Open NOTES and open the management database of LEI server.
Appear after opening
-
Qingzhou replied: June 2004-18 13: 06: 45.
D) create a connection
I. create a connection to notes
Click "Create Connection" and select "Remarks" in the list box, as shown:
Fill in the name of this connection, the name of domino server and specify a specific notes database to exchange data with sql in "Connection Properties", and the rest can be used by default. Save and exit after completing the form.
-
Qingzhou replied: June 2004-1813: 08:11.
Two. Establish a connection with SQL
Connect to sql database through ODBC, and select "ODBC" in the type list. draw
Fill in the name of the connection, the name of the data source, and the user name and password (provided by sql) for connecting the data in Connection Properties, and use the default values for the rest. Save and exit after completing the form.
-
Qingzhou replied: June 2004-18 13: 09: 27.
Three. Connection test
Enter the directory of LEI server in the running window, and add "nlctest" for testing. draw
After confirmation, you can test the connection between ODBC and DOMINO separately. If the test is successful, proceed to the next step.
-
Qingzhou replied: June 2004-1813:12:11.
E) create an activity.
Click Create Activity and select Direct Transfer in the list box, as shown:
This is an important step, which defines the form and fields of tables for exchanging data between two different databases. Therefore, a table is specially listed to illustrate the filling of more important items:
Save and exit after completing the form.
Create an activity
Explain the filling of more important items.
-
Qingzhou replied: June 2004-1813:13: 26.
To test the activity, select the activity named "dtns" in the management terminal, and click the "Start Activity" button to view the server console. If the following red box prompts appear, it means that the Activity runs successfully.
-
Qingzhou replied: June 2004-1813:14:17.
F) test results
Add, delete and edit data in sql database and exchange data with activity(DTN) respectively. Therefore, the data can remain exactly the same, as shown in the following figure:
-
Qingzhou replied: June 2004-1813: 21:39.
summary
The data exchange between different databases is carried out through LEI. When installing LEI, try to install it in the same directory as domino server, so that it is more convenient to configure and operate in the future. When configuring connections and activities, you must clearly understand some basic concepts about NOTES database and SQL database, and you should also read the help carefully to familiarize yourself with the functions of each activity. Pay attention to some details when making some basic configurations, otherwise some minor problems will lead to the failure of the work.
8. FAQs
Q: Unable to connect to SQL server.
Whether SQL allocates corresponding permissions; Is SQL server up and running normally?
Q: When I created the activity, I couldn't find the table required by the SQL database.
A: I didn't choose the corresponding database when I made an ODBC connection.
Q: When you press the "Select Metadata" and "Map Fields" buttons, you will be prompted that the module cannot be found.
A: There is no operation on the client of the server machine.
Q: Data reply import
A: the direct transfer option-target data "overwrite existing data" is not selected.
9. Reference chapter
A) chapter 1 and chapter 2 of a)LEIInsGd.pdf
B) chapter 1, chapter 2, chapter 3, chapter 4 and chapter 8 of b)LCConnGd.pdf
C) Chapters 1, 2, 3, 4, 5, 12, 14 and 15.
-
Antle's reply time: June 2004-18 13: 44: 50.
The first top:)
-
Ibmas400 reply: June 2004-18 15: 05: 58
Qingzhou brothers are like cows:
-eat grass and squeeze out high-quality milk.
:lol: :lol: :lol:
-
Tan Wei replied in June 2004:1822: 01:17.
I haven't used such an old version for many years!
Now it's thunder 6. 5 la
-
Fzrxh reply time: June 2004 19 08: 23: 04
Domino's decs seems to be similar to this one.
-
Qingzhou replied on: June 2004-19 08: 59: 23.
The original text was published by Tan Wei:
I haven't used such an old version for many years!
Now it's thunder 6. 5 la
There is almost no change in function. At that time, I still had the previously downloaded version at hand and didn't want to install it.
-
Qingzhou replied on: June 2004-19 09: 03: 10.
Quote: The original post was written by "fzrxh"] domino's decs seems to be similar to this one.
Release:
The interface of DECS management and mine management looks very similar, but there are some differences in the whole implementation steps. I used to configure it with DECS. At that time, I read a reference book and said that LEI is a tool specially used for the interaction between NOTES and relational databases, and it is better to use LEI after the test.
Look at your habits ~ ~ ~
-
Qingzhou reply time: June 2004-19 09: 23: 40.
The main purpose of this article.
First, users who currently use Lotus Notes products on CU can get good reference materials so that they can refer to them directly when they have similar needs in the future.
In addition, I also hope to improve everyone's enthusiasm, so that every friend who comes to CU400 can really learn something, improve themselves and everyone. This is my personal wish.
If everyone can open their hearts to exchange technology and express their knowledge, I think it will definitely improve the overall level of CU400, and no matter which company they go to in the future, they will benefit a lot.
Do you think so?
-
Fzrxh reply time: June 2004-19 10: 05: 29.
Yes, thank you for your efforts.
-
Fh200 1 Reply time: June 2004-19 23: 56: 20.
Good article, with reference value, thank you.
-
Sjm_lfj reply date: June 22, 2004 09: 55: 4 1
Excuse me, where can I download Lei? Can you send me a copy?
E-mail: sim _ lfj @163.com.
-
Qingzhou reply: June 24th, 2004 19: 34: 10.
Quote: The original post was published by "sjm_lfj":
Excuse me, where can I download Lei? Can you send me a copy?
E-mail: sim _ lfj @163.com.
FTP IP:2 19. 145.62 . 186
Port: 6655
User: www.as400bbs.com
Password: www.as400bbs.com
Directory: /up/qingzhou/LEI6.rar
Uploaded this afternoon, size: 27.6M, downloaded by CuteFTP Pro software.
Set the download link directly. I tried to set up several links,: oops:, so I can only suggest using CuteFTP Pro software to pull data. . .
Who can teach me how to find the link? thank you
-
Qingzhou replied on June 24th, 2004 at 20: 25: 19.
Good people do it to the end ~~~ :mrgreen:
Today, I sorted out the notes I made in my hand and summarized them as follows:
Lei V6.5 learning experience
Author: Qingzhou
Date of manufacture: June 24, 2004
This paper mainly records several problems summarized in the process of learning Lei V6.5 This record is divided into three parts:
1, lei 6.5 foundation
2, Lei 6.5 actual combat drills
3. Frequently asked questions
First, the foundation of Lei 6.5:
1) How does Lotus integrate with other data?
There are five types of enterprise integration ei in lotus:
▲lsx
▲jdbc
▲odbc
▲esb(vb)
▲ Lei
▲decs
2) What is thunder?
LEI is the abbreviation of lotus Enterprise Integration, and it is a tool for lotus to integrate with other data.
What will Ray do?
▲ You can connect NSF, DB2, Oracle, sysbase, old-DB, ODBC, File, Text, SAP R/3, PeopleSoft and Oracle applications.
▲ Executable sql script
▲ Notes and third-party databases can be copied regularly.
▲ Form records (files) can be transferred to each other.
▲ You can take files to a third-party database.
▲ Third-party databases can be updated in real time.
▲ Attachments can be passed into blob fields.
4) What is the operating environment of Lei?
▲ Domino
▲ Lei
▲ Windows 2000
▲ linux 7.2
Two. Lei 6.5 actual combat drill:
1. Install db2 and create the sample database;
2. install domino 6.5；;
3. Install notes 6.5. Install all (Lotus Notes Client 6.5/Lotus Design 6.5/Lotus Administrator 6.5);
4. Configure the domino server;
5. Start the domino server;
6. Configure notes and connect to domino server;
7. Install mine 6.5; ;
8. Start lotus administrator and log in to the database of decsadmin.nsf;
9. Set the server configuration file, set the proxy to * in the security tab, save and exit;
10. Start lei6.5；;
1 1. Start lotus Design:
A) create an employee data,
B) Create an employee form in the database, create fields in the form and save the form. These four fields are:
First, empno, text type;
Two. Firstnme, text type;
Three. Last name, text type.
Four. Salary, type $ number
C) create the view employeeView in the database,
I. specify the view selection form= "employee",
Two. Create columns in the view that are specified as four fields in the form.
Three. Save the view and exit.
12. Start the lotus notes client; ;
Open lei administrator database:
A) Click db2 under the Connect button.
I. Give a name to connect to db2,
Two. Enter samples in the database.
Three. Enter db2admin in the user name.
Four. Enter db2admin in the user password.
Verb (abbreviation for verb) selects an administrator in form mode.
The intransitive verb selects employee in the name of the form.
Seven. At this point, the form field is automatically added to the document, save the document and exit.
B) Click the comment under the Connect button.
I. give a name to connect to domino.
Two. Enter the name of the domino server in Server.
Three. Select employees in the database.
Four. Select employees in the form.
Verb (short for verb) At this point, the fields in the form are automatically added to the document. Select the available fields and save the document.
C) Click Direct Transfer under Activities.
I. Give domino a name db2.
Two. Select connect to db2 in the source code.
Three. Select connect to domino in the target.
Four. Specify the correspondence between table fields in db2 and domino table fields in the mapping.
Verb (abbreviation of verb) Enter Select Empno, First NME, Last Name, salary from administrator.employee in the sql statement.
The intransitive verb saves the document and exits.
D) Select db2 to domino in the view, and then click the start button to start data transfer.
14. Open the employee database with lotus notes client to see if there is any data in the data. If there is, it is successful.
15. The exercise is over.
Three. Frequently asked questions:
1. You cannot select a table when setting up a db2 database.
A: There may be two questions:
First, the user name and password of db2 are incorrect. You can check whether db2 is available and the password is correct.
1) to enter the dos command window.
2) Enter the domino installation directory.
3) execute ntctest.
4) Select 6 for db/2 test,
5) Enter the user
6) Enter the password
7) If the screen shows that the connection is successful, it means success.
Second, the authority to execute the connection proxy is insufficient. Open the server configuration document and set the agent execution authority in the security tab, which can be set to *.
2. When selecting domino database, you cannot select?
Answer: Check whether the domino server name you entered is correct.
3. Select the activities document, and then click start. Did it work?
Answer: The problem here can be found as insufficient execution authority, which can be solved by setting security in the server configuration document. If it is not configured, select the log view of lei administrator and check the error log. In most cases, the sql statement is incorrect.
-
ICC reply time: June 25, 2004 13: 26: 52
Quote: The original post was published by Qingzhou ]CLE and Informix ...;
The interaction between data and notes, etc., thus giving inferences.
2. Purpose and principles
Using the connection and behavior of LEI tool to realize the connection between NOTES and SQL database. Schematic diagram (as shown below):
As can be seen from the figure, l ..........
Ask prawns, what are Lei's tools for?
-
Qingzhou reply: June 25, 2004 13: 29: 24.
The supplementary learning experience of Lei V6.5 is clear enough. . .
What will Ray do?
▲ You can connect NSF, DB2, Oracle, sysbase, old-DB, ODBC, File, Text, SAP R/3, PeopleSoft and Oracle applications.
▲ Executable sql script
▲ Notes and third-party databases can be copied regularly.
▲ Form records (files) can be transferred to each other.
▲ You can take files to a third-party database.
▲ Third-party databases can be updated in real time.
▲ Attachments can be passed into blob fields.
-
Dreams76 reply: June 27th, 2004 13: 19: 36.
Strongly support the landlord, ladies and gentlemen, we should pay tribute to the landlord and write more experience sets for our brothers!
-
Cgljuny's reply time: September 5, 2004 at 23: 16: 42.
Thank you!
I downloaded LEI6 from FTP, but it seems that I can't install LEI6 on the server of NOTES5.0.8. I wonder if I can download LEI3.2 again? It can't be found on many skynets, and it doesn't seem to be on the CD of the notes. I have to ask you for help. Thank you very much
-
Qingzhou replied on: September-June 2004 08: 55: 24.
oh
I seem to have downloaded it from the IBM website. Some time ago, there was something wrong with the hard disk, so I had to find the LEI6 version that was backed up elsewhere before. Excuse me!
It is recommended to test on NOTES R65 version.
At the same time, you can also find it on the enterprise integration homepage of IBM's Lotus website (www.lotus.com/ei).
-
Reply time: September 2004-June 09: 59: 04
Suggest adding essence!
-
Reply time of ChinaHR.com: July 2005-1121:22:18.
You must try it sometime. I should be able to learn this in detail. Thank you~
Original link: /viewthread.php? tid=35025 1
Please indicate the author's name and original source.