Redis is an in-memory key-value store. Etlworks reads from Redis using a single key or a wildcard pattern, writes to Redis using a single key, and treats Redis the same way it treats a file storage system: the Redis key behaves like a filename and the value is the file contents.
What can you do with Redis in Etlworks?
| Use case | How |
|---|---|
| Connect to Redis | Create a Redis connection. |
| Extract data from Redis | ETL flow with Redis as the source. Wildcard keys behave like wildcard filenames. |
| Load data into Redis | ETL flow with Redis as the destination. |
| Browse data in Explorer | Open Etlworks Explorer against a Redis connection to view keys and values, including in their native format (JSON, HL7, …). |
| Query Redis with SQL | The SQL editor in Etlworks Explorer works against any connection — including Redis. |
Connect to Redis
Create a Redis connection.
Extract data from Redis
Redis as a source works just like a file source: the Redis key plays the role of the filename.
- Create a Redis connection for the source.
- Create a destination connection.
- Create an ETL flow with the Redis connection as the source and the destination from step 2 as the destination.
Use wildcard keys the same way you'd use wildcard filenames. To process every matching key, see Process files in an ETL flow using wildcard filenames.
Load data into Redis
- Create a source connection (database, file, API, …).
- Create a Redis connection for the destination.
- Create an ETL flow with the source from step 1 and the Redis connection from step 2 as the destination.