Connect to Cirro with SQL Workbenchj editor using these steps.

Before You Start

Download SQL Workbench

Setup Driver

  • Open SQL Workbench.

  • Choose File, then Manage Drivers.

  • Enter a name for the driver.

  • Click FOLDER and browse for cirroclient.jar.

  • Ensure classname is: com.cirro.jdbc.client.security.Driver.

  • Click OK

Setup Connection

  • Choose File and Connect Window.
Field Description Example values
Name Name of Connection Cirroconnection
URL jdbc:cirrosecurity://[ip address or hostname]:1527/cirro jdbc:cirrosecurity://myhost.cirro.com:1527/cirro
Username and Password Cirro username and password Cirrouser/cirropassword
Class Name com.cirro.jdbc.client.security.Driver com.cirro.jdbc.client.security.Driver
  • Click Test to verify the settings are correct.

  • Click Ok to connect.

  • Click Workspace and Save Workspace to save these settings.

Leave Comments

Login to Disqus to leave comments and questions

Email Cirro if you've got problems, or click Raise Issue at the right side of the page to raise a support request.