Etlworks integrates with NoSQL databases in two ways: a small set of built-in (included) connectors with native, NoSQL-aware capabilities, and a much larger set of premium connectors that abstract NoSQL stores as relational sources (tables, views, stored procedures) using the same pattern as Connected Apps.
Included connectors
Native NoSQL connectors. These have dedicated articles in this section because they expose features beyond what a generic SQL abstraction can cover — nested-document handling, document operations, native CDC.
| Connector | What you can do |
|---|---|
| MongoDB | Read collections, write documents, query with SQL translated to MongoDB queries, capture changes via log-based CDC, and manage documents with file-style operations. Two connection types: MongoDB (collections) and MongoDB Document (individual documents). |
| Redis | Read and write key-value pairs. Wildcard keys behave like wildcard filenames. |
Premium connectors
Premium NoSQL connectors are the same pattern as Connected Apps: Etlworks treats the NoSQL store as a relational database, exposing collections, indexes, and queries as tables, views, and stored procedures. You build flows with drag-and-drop mapping or SQL queries; the connector translates to the underlying NoSQL protocol.
Because the premium NoSQL connectors share the relational-abstraction pattern, the dedicated guidance lives in Working with Connected Apps: how to authenticate, how to browse objects in Etlworks Explorer, how to use the connector as a source or destination in ETL flows.
Available premium NoSQL connectors:
| Apache Phoenix | Btrive | Cassandra | Cloudant |
| CosmosDB | Couchbase | CouchDB | DynamoDB |
| Elasticsearch | HarperDB | Hbase | HDFS |
| HDSF | HPCC | MarkLogic | Splunk |
Full connector-reference page: Connectors for NoSQL databases.
Which connector should I use?
| You want to… | Use |
|---|---|
| Read or write a MongoDB collection | The MongoDB connector (included). |
| Read or write key-value pairs in Redis | The Redis connector (included). |
| Read or write Cassandra / DynamoDB / Cosmos / Couchbase / Elasticsearch / Hbase / MarkLogic / Splunk / … | The matching premium connector. Follow the Connected Apps pattern: same drag-and-drop or SQL-based ETL as a relational database. |