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.
| 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. |
| HarperDB | Hybrid SQL/NoSQL document store. Native SQL plus document operations. |
| 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. |