Implementing IBM Lotus Enterprise Integrator 6
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...
| Autor Corporativo: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
White Plains, NY :
IBM, International Technical Support Organization
2003.
|
| Edición: | 1st. ed |
| Colección: | IBM redbooks.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627103206719 |
Tabla de Contenidos:
- 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.
