Use Lotus enterprise Integrator (LEI) to move Domino attachments to a relational database (Graphic Process)

See IBM solutions: http://www.ibm.com/developerworks/cn/lotus/LEI-attachments/index.html

Reprinted please indicate the source: http://blog.csdn.net/zhouyuqwert/article/details/6681442

Some of these processes are explained as follows:

First, an empty form copy without any documents is required, because the Lei virtual documents activity following the empty form will listen to it,

Once data is created or deleted, it is immediately reflected in the relational database corresponding to the activity,

That is, Domino attachments are stored in the attachment table created by the activity as binary data,

The attachment information is stored in the relational database field.

You can copy the document of the original form to the copy during activity listening so that it can be automatically transferred to the relational database.

The entire transfer process is as follows:

1. Create a new copy.

Right-click Copy and choose create copy.

Click other settings and select Advanced

Select "select Document by selecting formula" and enter a formula so that no document meets the conditions, so that no document is copied during the copy process.

Confirm the copy.

2. Create a relational database corresponding to the notes form

The field corresponds to the field used to create a relational database table.

3. Create a lei virtual documents Activity

Before that, you must have a connection to the Notes database and a connection to ODBC (or another relational database, in this example, ODBC connects to MySQL.

1) enter the Identification name to indicate the current activity, select the domino database and ODBC connection, and select mapping fileds.

2) Select Options> General Options> use external key table.

3) options-> General options-> key fileds select the key field

4) Create extenal key table.

Table Name format [schema]. [Table]

5) Select Options> virtual attachments> Virtualize.
Attachments

6) createvirtual
Attachment table

This activity is created successfully. You can see that there are two more tables in the ODBC database.

4. Copy the document to a copy

Remove the "select Document by Selection Formula" in the copy settings, or you can write a formula to select a document based on your needs.

Enable the Lei virtual documents activity. You can see the following statement on the Domino server.

Right-click the Notes database and choose Copy> copy.

Copy the data to the copy to check whether the database has successfully obtained the attachment and form data.

Doc_key table:

Doc_attachments table: