Use Lotus Enterprise Integrator (LEI) to move Domino attachments to a relational database (graphics process)

Refer to IBM Solutions: http://www.ibm.com/developerworks/cn/lotus/LEI-attachments/index.html

Reprint Please specify source: http://blog.csdn.net/zhouyuqwert/article/details/6681442

Some of these procedures are explained below:

First, you need an empty copy of the form without any documentation, since the LEI Virtual documents activity at the back will listen to the empty form,

Once the data is created or deleted, it will be reflected in a timely manner to the corresponding relational database of the activity.

That is, the domino attachment is stored in binary data in the new attachment table of the activity.

The information for the attachment is also stored in the relational database field.

You can copy the original form's documents to the copy while the activity is listening, so that it can be automatically transferred to the relational database.

The following is the entire process of transfer:

1. Create a new copy.

Right-click Copy-new copy

Click Other settings, select Advanced

Tick "Select document by Selection formula" and enter a formula so that no document satisfies the criteria and no document copies are made during the copy process.

Determine the copy.

2. Create a relational database corresponding to the Notes form

Domain corresponds to field creation relational database table

3. Create an LEI Virtual Documents Event

Prior to this, there was a need to have a connection connection to the Notes database and a connection to connect ODBC (or other relational database forms, this example ODBC-connected MySQL).

1) Fill in the identification name to indicate the current activity, select the Domino Database and ODBC connection, and select mapping Fileds.

2) Tick options->general options->use External Key Table

3) options->general options->key fileds Select key field

4) Create extenal Key Table.

Table name fill in the format [schema]. [Table]

5) tick options->virtual attachments->virtualize Attachments

6) CreateVirtual Attachment table

At this point, the activity is created successfully, and you can see that there are two more tables in the ODBC corresponding database

4. Copy the document to the copy

Remove the tick by selecting "Select a document by Selection formula" in the copy settings, or you can write a formula to select a document according to your own needs.

Turn on the LEI Virtual Documents activity and see the following statement on the Domino server.

Copy-and-Copy right-click Notes database

After you copy the data into the copy, you can see if the database successfully received the attachment and the form data.

Doc_key table:

Doc_attachments table:

Use Lotus Enterprise Integrator (LEI) to move Domino attachments to a relational database (graphics process)