Implementing IBM Lotus Enterprise Integrator 6 / [Andre Guirard ... et al.].

Format:

Book

Contributor:

Guirard, Andre (Andre P.)

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Business enterprises--Data processing.

Business enterprises.

Enterprise application integration (Computer systems).

Lotus Domino.

Physical Description:

xiv, 260 p. : ill.

Edition:

1st. ed.

Place of Publication:

White Plains, NY : IBM, International Technical Support Organization, 2003.

Language Note:

English

System Details:

text file

Summary:

This IBM Redbooks publication helps you to implement Lotus Enterprise Integrator (LEI) 6. It is targeted for system administrators who plan to implement or upgrade to LEI 6 in their organization. This book provides tips and techniques to help you successfully deploy and administer LEI 6. We begin by providing a brief introduction to what’s new with LEI 6 and cover some architectural scenarios of how LEI 6 infrastructure could be implemented in a customer’s environment. We then provide detailed information on how to install and administer LEI 6, as well as how to migrate or upgrade from LEI 3.x to LEI 6. Tools, techniques and utilities for debugging activities are described in depth, for testing connectivity to relational databases and testing connection documents in the LEI Administrator. Working examples are provided to illustrate how to use the Advanced RealTime activities that are new in LEI 6. It also provides examples of some of the batch activities previously available in LEI 3.x such as a scripted activity and a replication activity. Finally, the book concludes with a discussion of the LC LSX, the LotusScript programming interface to the Lotus Connectors which lets you program any functionality you need that isn’t available through the LEI forms. Please note that the additional material referenced in the text is not available from IBM.

Contents:

Front cover

Contents

Notices

Trademarks

Preface

The team that wrote this redbook

Become a published author

Comments welcome

Chapter 1. Introduction to IBM Lotus Enterprise Integrator (LEI) 6 for Domino

1.1 A business case for LEI

1.2 Which tools come with Domino?

1.2.1 DECS

1.2.2 DCRs

1.2.3 LC LSX

1.3 LEI defined

1.3.1 The LEI Administrator

1.3.2 Connection documents

1.3.3 Activity documents

1.3.4 Current limitations with using LEI 6

1.4 A comparison of DECS, DCRs, and LEI

1.4.1 Advanced RealTime feature - virtual attachments

1.4.2 Advanced RealTime feature - integrated credentials

1.5 What's new with LEI 6.0 through 6.0.2

1.5.1 What's new in LEI 6

1.6 Terminology

1.7 Data type conversions/mappings

Chapter 2. Architectural scenarios and considerations

2.1 Architectural scenarios

2.1.1 Scenario 1: Single Domino/LEI server

2.1.2 Scenario 2: Remote database servers

2.1.3 Scenario 3: LEI access to multiple relational back-ends

2.1.4 Scenario 4: LEI 6 Advanced Realtime plus Notes replication

2.1.5 Scenario 5: Decentralized Advanced RealTime access

2.2 Security considerations

2.2.1 Generic user ID and password

2.2.2 Integrated credentials

2.2.3 Fields and public key encryption

2.3 Performance considerations

2.3.1 LEI considerations

2.3.2 Performance spectrum scenarios

2.3.3 RDB performance considerations

2.3.4 Persistent connections

Chapter 3. Installing and configuring the LEI Administrator

3.1 Where to find the install documentation

3.2 Pre-installation activities

3.2.1 Domino server document changes

3.2.2 ID modifications

3.2.3 Other preparations

3.3 Installation of LEI

3.3.1 Installation Checklist

3.3.2 Process of installation

3.4 Administration of LEI

3.4.1 LEI Administrator database.

3.4.2 Configuration

3.4.3 Starting and stopping the LEI server

Chapter 4. Migrating from Lotus Enterprise Integrator 3.x

4.1 Migration considerations

4.1.1 Migrating scripted documents

4.1.2 Migrating metaconnection documents

4.1.3 LEI clustering and remote administration

4.2 Pre-migration activities

4.3 Process of migration

4.4 Troubleshooting

4.4.1 Migration log file

Chapter 5. Diagnostic tools and techniques

5.1 Test Connectivity using database vendor tools

5.2 Test connectivity using the DCTEST utility

5.3 Test the Connection Document using CONTEST

5.4 Activity debugging techniques

Chapter 6. Connection documents

6.1 DB2 connection documents

6.1.1 Connectivity section

6.1.2 Table selection section

6.1.3 Other section

6.2 Test your connection

6.3 Notes connection document

6.3.1 Connectivity section

6.3.2 General Options section

6.3.3 Document Selection section

6.3.4 Field Selection section

6.3.5 Data Transformation section

6.3.6 Data Creation section

6.3.7 Other section

6.4 File connection document

6.4.1 Connectivity section

6.4.2 Subdirectory Selection section

6.4.3 Other section

6.5 Text connection document

6.5.1 Connectivity section

6.5.2 Text specifications section

6.5.3 Other section

6.6 Metaconnectors

6.6.1 Collapse/Expand Metaconnector

6.6.2 Meter MetaConnector

6.6.3 Order MetaConnector

6.6.4 Trace MetaConnector

Chapter 7. Batch activities

7.1 Command Activity

7.2 Example 1: Setting up a Command Activity

7.2.1 Create a connection document to the RDB

7.2.2 Create the Command Activity

7.2.3 Execute the Command Activity

7.2.4 Create the AGENTEQUIP table

7.3 Direct Transfer Activity

7.4 Example 2: Using Direct Transfer

7.4.1 Create a connection document to Notes.

7.4.2 Create the main Direct Transfer activity

7.4.3 Create a Notes connection document by copying

7.4.4 Copy the RDB Connection

7.4.5 Collapse/Expand Metaconnection

7.4.6 Create the secondary Direct Transfer activity

7.4.7 Establishing a chain of activities

7.5 Scripted activity

7.6 Example: Creating a scripted activity

7.7 Replication activity

7.7.1 Primary key replication

7.7.2 Timestamp replication

7.8 Example: Primary key replication, RDB to Domino

7.8.1 Create Notes connection to Agent records with view selection

7.8.2 Create Notes Connection to Agent Equipment with view selection

7.8.3 Create Order metaconnections for Notes connections

7.8.4 Create a Collapse/Expand Metaconnection for the RDB

7.8.5 Create the main Replication activity

7.8.6 Test the main replication activity

7.8.7 Update the relational data

7.8.8 Retest the main Replication activity

7.8.9 Create a secondary Replication activity

7.8.10 Test the Secondary replication activity

7.9 Other data moving activities

7.9.1 Archive

7.9.2 Java

7.9.3 Polling

7.9.4 Admin Backup

7.9.5 Admin Purge Log

Chapter 8. Advanced RealTime activities

8.1 Virtual fields activity

8.1.1 Usage notes

8.1.2 Setting up the virtual fields activity

8.1.3 Event options for virtual fields activity

8.1.4 Keeping Virtual Field key documents up to date

8.2 Virtual Attachments

8.2.1 How file attachments work in Notes

8.2.2 Virtual Attachment "Resync" for Virtual Documents

8.3 Example 1: Virtual Fields activity

8.3.1 Populate the data in the relational tables

8.3.2 Create a Connection Document

8.3.3 Create the Activity Document

8.4 Example 2: Adjust Virtual Fields to Store Additional Fields

8.4.1 Stop Activity and update Activity document

8.4.2 Update documents to contain the new fields.

8.4.3 Considerations in storing copies of fields

8.5 Example 3: Virtual Fields activity with multi-value fields

8.5.1 Create a connection document to the AGENTEQUIP table

8.5.2 Create a secondary Virtual Fields Activity

8.5.3 Test the new activity

8.6 Virtual documents activity

8.6.1 How does the virtual documents activity work?

8.6.2 Differences between a regular Notes document and a virtual document

8.6.3 External system metadata for virtual documents activities

8.6.4 Virtualizing and revirtualizing

8.6.5 Indexing

8.6.6 Deletion involving virtual documents

8.6.7 Domino replication involving virtual documents

8.6.8 Event options for virtual documents activity

8.7 Differences between virtual documents and virtual fields

8.7.1 Advantages of virtual documents activity

8.7.2 Limitations of virtual documents activity

8.7.3 Using virtual fields with virtual documents

8.8 Virtual agents

8.9 Example 4: Using a virtual documents activity

8.9.1 Create a connection document to your relational database

8.9.2 Create the data tables

8.9.3 Create the Virtual Documents activity

8.9.4 Create a new Virtual Fields activity

8.9.5 Test the new activities

8.9.6 Note IDs of Virtual Documents

Chapter 9. Getting Started with the LC LSX

9.1 History of the LC LSX

9.1.1 Migrating LEI LSX code from Previous LEI Versions

9.2 The LSX Classes

9.2.1 LCSession Class

9.2.2 LCConnection Class

9.2.3 LCField Class

9.2.4 LCFieldlist Class

9.2.5 LCStream Class

9.2.6 LCDateTime, LCNumeric, LCCurrency Classes

9.3 Basic database operations

9.3.1 Connect to a database

9.3.2 Handle LC errors

9.3.3 Select and fetch all the records in a table

9.3.4 Select records that meet certain criteria

9.3.5 Insert a new record

9.3.6 Delete records that meet certain criteria.

9.3.7 Update a record using writeback

9.3.8 Update a record using a selection key

9.3.9 Control Commit and Rollback

9.3.10 Call a stored procedure

9.3.11 Using database timestamps

9.3.12 Execute SQL that you create in your program

9.3.13 Work with binary data

9.4 Using the Notes Connector

9.5 Connection pooling

9.6 Performance tips

9.6.1 Performance code samples

9.7 Tips and tricks

9.7.1 Using the Trace metaconnector

9.7.2 Map by Name

9.7.3 Sorting data

9.7.4 Updating key fields

9.7.5 Offload database access to server

9.8 LEI power programming

9.8.1 LEI Programming 1: Transfer data from profile documents

9.8.2 LC LSX Example 2: Update Virtual Fields in Notes views

9.8.3 LC LSX Example 3: Fix unvirtualized documents

9.9 Notes client coding considerations

9.10 Other APIs

9.10.1 LS:DO

9.10.2 JDBC

9.10.3 @DbLookup and @DbColumn functions

9.11 Additional information about the LC LSX

Appendix A. Removing Lotus Enterprise Integrator (LEI)

Considerations prior to removing LEI

Access to data

LEI clustered environment

Domino Enterprise Connection Services (DECS)

Process of removing LEI

Appendix B. Troubleshooting

Using the LEI log (leilog.nsf)

Using the Domino log (log.nsf)

Enabling log conflicts in replication activities

Logging SQL statements

Using the trace metaconnector

Using Notes Server Diagnostic (NSD)

Appendix C. Additional material

Locating the Web material

Using the Web material

How to use the Web material

Further useful downloads

Glossary

Related publications

IBM Redbooks

Other publications

Online resources

How to get IBM Redbooks

Index

Back cover.

Notes:

"December 2003."

"SG24-6067-00."

Includes bibliographical references and index.

OCLC:

939263451