Databases
Database Integrations – Postgres, MySQL, MSSQL, MongoDB, CosmosDB, DynamoDB
Summary (SEO Meta Description):
Database integrations in WeHub include Postgres, MySQL, MSSQL, MongoDB, CosmosDB, and DynamoDB.
Connect workflows to relational and NoSQL databases to query, insert, update, and manage records at scale.
Overview
Database plugins enable WeHub workflows to connect directly with SQL and NoSQL databases.
These integrations allow you to query, insert, update, and manage structured or unstructured data, making them ideal for data-centric automation.
Typical Use Cases:
- Store workflow results in Postgres or MySQL.
- Query MongoDB documents for dynamic data processing.
- Manage CosmosDB in both Table and NoSQL modes.
- Use DynamoDB for high-throughput key-value storage.
- Integrate with enterprise databases like MSSQL for business-critical apps.
Available Plugins
| Plugin | Description |
|---|---|
| PostgresSQL Plugin | Connect workflows to PostgreSQL databases. |
| MySQL Plugin | Query and update MySQL databases. |
| MSSQL Plugin | Connect to Microsoft SQL Server and perform CRUD operations. |
| MongoDB Plugin | Work with MongoDB JSON documents. |
| CosmosDB Plugin | Integrate with CosmosDB in both Table and NoSQL modes. |
| DynamoDB Plugin | Read and write high-throughput key-value data in AWS DynamoDB. |
FAQ
Q: Do these database integrations support schema validation?
A: Yes. Most database plugins in WeHub support schema mapping and validation to ensure data consistency and quality.
Q: Can I use DynamoDB both for triggers and processors?
A: DynamoDB acts primarily as a Processor, but can be combined with Triggers for event-driven workflows.
Q: Are these plugins suitable for large-scale production data?
A: Absolutely. Each plugin is designed to handle production-level workloads and supports WeHub’s scalable architecture.
Keywords: WeHub Database Integrations, Postgres Plugin, MySQL Plugin, MSSQL Integration, MongoDB Workflow, CosmosDB WeHub, DynamoDB Plugin