Identity Manager 3.6.1 Driver for JDBC Implementation Guide
- Identity Manager 3.6.1 Driver for JDBC Implementation Guide
- Introducing the Identity Manager Driver for JDBC
- Driver Concepts
- Database Concepts
- Driver Features
- Installing the Driver Files
- Installing the Driver Files
- Installing JDBC Driver Jar Files
- Installing and Configuring Database Objects
- SQL Script Conventions
- Installing IBM DB2 Universal Database (UDB)
- Installing Informix Dynamic Server (IDS)
- Installing Microsoft SQL Server
- Installing MySQL
- Installing Oracle
- Installing PostgreSQL 7
- Installing PostgreSQL 8
- Installing Sybase Adaptive Server Enterprise (ASE)
- Testing the Database Object Installation
- Upgrading an Existing Driver
- Supported Upgrade Paths
- What’s New in Version 3.6.1
- Upgrade Procedure
- Importing an Example JDBC Configuration File
- Using Designer to Import
- Using iManager to Import
- Starting the Driver Object
- Activating the Driver
- JDBC Driver Settings
- Configuring the JDBC Driver
- Smart Configuration
- Configuration Parameters
- Driver Parameters
- Subscription Parameters
- Publication Parameters
- Trace Levels
- Configuring Third-Party JDBC Drivers
- Configuring jTDS Support for the JDBC Driver
- Managing the Driver
- Schema Mapping
- High-Level View
- Logical Database Classes
- Indirect Synchronization
- Direct Synchronization
- Synchronizing Primary Key Columns
- Synchronizing Multiple Classes
- Mapping Multivalue Attributes to Single-Value Database Fields
- Mapping XDS Events to SQL Statements
- Mapping XDS Events for Indirect Synchronization
- Mapping XDS Events for Direct Synchronization
- The Event Log Table
- Event Log Columns
- Event Types
- Embedded SQL Statements in XDS Events
- Common Uses of Embedded SQL
- Embedded SQL Basics
- Token Substitution
- Virtual Triggers
- Manual vs. Automatic Transactions
- Transaction Isolation Level
- Statement Type
- SQL Queries
- Data Definition Language (DDL) Statements
- Logical Operations
- Implementing Password Set with Embedded SQL
- Implementing Modify Password with Embedded SQL
- Implementing Check Object Password
- Calling Stored Procedures and Functions
- Best Practices
- Supported Databases
- Database Interoperability
- Supported Databases
- Database Characteristics
- Third-Party JDBC Drivers
- Third-Party JDBC Driver Interoperability
- Third-Party JDBC Driver Types
- Third-Party Jar File Placement
- Supported Third-Party JDBC Drivers (Recommended)
- Supported Third-Party JDBC Drivers (Not Recommended)
- Deprecated Third-Party JDBC Drivers
- Other Third-Party JDBC Drivers
- Security Issues
- The Association Utility
- Independent Operations
- Before You Begin
- Using the Association Utility
- Parameters for Searching and Replacing
- Troubleshooting the JDBC Driver
- Recognizing Publication Events
- Executing Test Scripts
- Troubleshooting Driver Processes
- Troubleshooting the PostgreSQL Installation
- Uninstalling the Driver
- Deleting Identity Manager Driver Objects
- Running the Product Uninstaller
- Executing Database Uninstallation Scripts
- Known Issues and Limitations
- Known Issues
- Limitations
- Best Practices
- FAQ
- Can’t See Tables or Views
- Synchronizing with Tables
- Processing Rows in the Event Log Table
- Managing Database User Accounts
- Synchronizing Large Data Types
- Slow Publication
- Synchronizing Multiple Classes
- Encrypted Transport
- Mapping Multivalue Attributes
- Synchronizing Garbage Strings
- Running Multiple JDBC Driver Instances
- Supported Data Types
- java.sql.DatabaseMetaData Methods
- JDBC Interface Methods
- Third-Party JDBC Driver Descriptor DTD
- Third-Party JDBC Driver Descriptor Import DTD
- Database Descriptor DTD
- Database Descriptor Import DTD
- Policy Example: Triggerless Future Event Processing
- Setting Up an OCI Client on Linux
- Downloading the Instant Client
- Setting Up the OCI Client
- Configuring the OCI Driver
- Sybase Chain Modes and the Identity Manager JDBC driver
- Error Codes
- Procedures and Modes
- Legal Notices