Let us take a closer look at how to Connect to Redis Data in DBeaver. With the support of our server management support services at Bobcares, we will give you a complete guide on the process.

Use the CData ODBC Driver to connect to Redis data in DBeaver.

The CData ODBC Driver for Redis gives ODBC-compliant access to live Redis data, allowing us to work with Redis data in a variety of BI, reporting, and ETL applications, as well as directly using traditional SQL queries. This article shows how to work with Redis data using DBeaver’s visual features, such as the query browser.

Because of the improved data processing embedded within the driver, the CData ODBC drivers provide unrivaled speed while working with live Redis data in DBeaver.

When we send complicated SQL queries from DBeaver to Redis, the driver sends supported SQL operations straight to Redis and uses the embedded SQL engine to perform unsupported actions (typically SQL functions and JOIN operations) client-side. We can manage and analyze Redis data using the built-in dynamic metadata querying.

Connect to Redis Data in DBeaver

Provide values for the relevant connection attributes in the data source name if we haven’t previously (DSN). The Microsoft ODBC Data Source Administrator may be used to configure the DSN.

This is also the final step in the driver installation process. A tutorial to utilizing the Microsoft ODBC Data Source Administrator to build and configure a DSN can be found in the Help documentation’s “Getting Started” chapter.

To connect to a Redis instance, set the following connection properties:

• Server: Enter the name or address of the server where the Redis instance is executing. In Port, we may specify the port.
• Password: Enter the password that was used to authenticate with a password-protected Redis instance using the Redis AUTH command.

When we connect, use UseSSL to negotiate SSL/TLS encryption.

Lastly, in the DSN Configuration box for the driver, set the “Map To WVarchar connection attribute to False. This option allows string types to be translated to SQL VARCHAR while also preventing SQL_WVARCHAR types from being presented as NULL.

Connecting to the Redis ODBC Data Source in DBeaver

For connecvtuing the Redis ODBC datasource follow the steps given below:

1. Launch the DBeaver program and pick the New Database Connection option from the Database menu.
2. Choose ODBC and click Next in the ‘Connect to a database’ window.
3. Enter the DSN in the Database/Schema area (CData Redis Source by default).
4. It will be available in the JDBC URL automatically.
5. Choose the Test Connectivity option. If the connection is successful, we should receive a ‘Connected’ message from DBeaver, along with driver information.

Query Redis Data

We may now query the tables accessible by the data source connection for information. And we can extend the database structure to see all of the tables.

We can get the data from a table by right-clicking on its name and selecting View data. The data will then be accessible through the Data tab.

[Need assistance with similar queries? We are here to help]

Conclusion

To sum up we have now seen how to Connect to Redis Data in DBeaver. With the support of our Server management support services at Bobcares we have now seen the whole configuration process.