Etlworks supports NoSQL databases through two tiers: included connectors with native, NoSQL-aware features, and premium connectors that abstract a NoSQL store as relational (tables / views / stored procedures) for ETL and SQL-based access.
Use-case-level coverage: Working with NoSQL databases in the Integration Use Cases category.
Included connectors
| Connector | What it's for |
|---|---|
| MongoDB | Read collections, write documents, capture changes via log-based CDC. Two connection variants: MongoDB (collections) and MongoDB Document (individual documents). Supports SQL queries translated to MongoDB syntax. |
| Redis | Read and write key-value pairs. Wildcard keys behave like wildcard filenames. |
Premium connectors
Premium NoSQL connectors follow the same pattern as Connected Apps: Etlworks treats the NoSQL store as a relational source. Tables, views, and stored procedures are auto-discovered; flows use drag-and-drop mapping or SQL. See Working with Connected Apps for authentication setup, browsing in Etlworks Explorer, and using the connector as an ETL source or destination. From Etlworks 10.0.14, install and license them from the UI — see Managing premium connectors.
| Connector | What it's for |
|---|---|
| Apache Phoenix | SQL over Hbase. Massively parallel, low-latency reads on Hbase tables. |
| Btrive | Btrieve (legacy Pervasive) key-value store. Read and write Btrieve files via SQL. |
| Cassandra | Wide-column distributed store. Read and write Cassandra tables; CQL via SQL. |
| Cloudant | IBM Cloudant (managed CouchDB on IBM Cloud). Document store with SQL abstraction. |
| CosmosDB | Azure Cosmos DB. Multi-model (document, key-value, graph, column-family) via SQL. |
| Couchbase | Document database. Read and write Couchbase buckets; N1QL via SQL. |
| CouchDB | Open-source document database. Read and write CouchDB documents via SQL. |
| DynamoDB | Amazon DynamoDB. Key-value and document store; tables exposed as relational. |
| Elasticsearch | Distributed search and analytics engine. Read and write indices; SQL across indices. |
| Hbase | Wide-column store on Hadoop. Read and write Hbase tables via SQL. |
| HDFS | Hadoop Distributed File System. Read and write HDFS files via the JDBC layer. |
| HDSF | Hadoop Distributed Storage Format variant. Read and write via the JDBC layer. |
| HPCC | HPCC Systems (Lexis/Nexis) data lake platform. ECL-backed datasets via SQL. |
| MarkLogic | Multi-model database (document, graph, search). Read and write XML / JSON documents via SQL. |
| Splunk | Operational data platform. Search indices and read events as relational rows. |