Database Adapters
Overview
Database adapters provide connectivity between webMethods Integration Server and various database systems. These adapters enable CRUD operations, stored procedure execution, and transaction management across different database platforms.
JDBC Adapter
- WmJDBCAdapter - Universal JDBC adapter supporting any JDBC-compliant database | Registry: licensed | Versions: 17
NoSQL Databases
- WmMongoDBAdapter - MongoDB document database adapter | Registry: licensed | Versions: 3
- WmCassandraAdapter - Apache Cassandra distributed database adapter | Registry: licensed | Versions: 2
Big Data
- WmHDFSAdapter - Hadoop HDFS adapter for big data storage | Registry: licensed | Versions: 2
Key Characteristics
- Connection Pooling: Efficient management of database connections
- Transaction Support: ACID compliance and distributed transactions
- Metadata Discovery: Automatic schema and table discovery
- Performance: Optimized for high-throughput operations
- Security: Support for encrypted connections and credential management
Use Cases
When to Use JDBC Adapter
- Connecting to any JDBC-compliant relational database (Oracle, SQL Server, PostgreSQL, MySQL, etc.)
- Standard SQL operations and stored procedures
- Maximum compatibility and flexibility
- Most actively maintained (17 versions)
When to Use MongoDB Adapter
- Document-oriented data models
- Flexible schema requirements
- High-volume read/write operations
- JSON-native data structures
When to Use Cassandra Adapter
- Distributed, highly available systems
- Time-series data
- Write-heavy workloads
- Linear scalability requirements
When to Use HDFS Adapter
- Big data analytics pipelines
- Large file storage and retrieval
- Integration with Hadoop ecosystem
- Batch processing workflows
Common Patterns
- Data Synchronization: Keep databases in sync across systems
- ETL Operations: Extract, transform, and load data between databases
- Real-time Integration: Trigger workflows based on database changes
- Reporting: Query databases for business intelligence
- Master Data Management: Maintain consistent reference data
See Also