Skip to main content

Accessing TDS Service from DBeaver

info

Available for: Flex (SSIS) and Gems (Pre-built)

Overview​

DBeaver can connect to the COZYROC Cloud TDS service using a Microsoft SQL Server (MSSQL) connection.

To establish a connection, you must provide:

  • TDS endpoint details
  • Your COZYROC credentials

This guide walks you through configuring the connection and accessing your TDS data in DBeaver.

Prerequisites​

Before you begin, ensure you have:

Step 1 — Create a New Connection​

  1. Open DBeaver
  2. Click New Database Connection
    • (or use Database → New Database Connection)
  3. In the driver list, select SQL Server
  4. Click Next

Data visualization

Step 2 — Enter Connection Settings​

Provide the following:

  • Host: tds.cozyroc.cloud
  • Port: 14333
  • Database: COZYROC
  • Authentication: SQL Server Authentication
  • Username: Your COZYROC Cloud account email
  • Password: Your Personal Access Token generated in COZYROC Cloud

Data visualization

Step 3 — Configure SSL​

  1. Open the SSL tab (if available)
  2. Enable Use SSL
note

SSL is recommended to ensure secure communication with the TDS service.

Data visualization

Step 4 — Test the Connection​

  1. Click Test Connection
  2. If prompted, allow DBeaver to download the SQL Server driver
  3. Confirm the test succeeds
  4. Click Finish

Step 5 — Access Your Data​

Once connected:

  1. Expand the connection in the Database Navigator
  2. Open the COZYROC database
  3. Browse schemas and tables
  4. Open a table to preview data or run queries

Data visualization

Troubleshooting Connection Issues​

If the connection fails, verify:

  • Endpoint and port are correct
  • Access token is valid and not expired
  • SSL is enabled
  • Firewall or IP allow-listing is configured if required
  • SQL Server driver is installed in DBeaver

Next Steps​

You are now ready to:

  • Query TDS data
  • Validate datasets
  • Use DBeaver for exploration and troubleshooting
  • Connect BI tools to the same TDS endpoint