Use your favourite SQL editor to connect to Cirro datasources without the need to login to the front-end.

Cirro Federated Query Editor

Cirro has a built-in query editor available with any Data Puppy License.

Use the Cirro Federated Query Builder

SQL Editor FAQ

Get answers to Frequently Asked Questions

Index

Index of SQL Editor pages

The following pages and posts are tagged with

TitleTypeExcerpt
Apache Derby IJ Command Line SQL Editor Page ij comes packaged with Apache Derby and is available from the command line on your server machine.
FAQ - Change Query Delimiter Page You can change the query delimiter from the standard semicolon to any single character.
Federated Query Builder Page Cirro has a built-in SQL Query tool for use on Data Puppy datasources. It also recognises Cirro's four-part table names.
Manage Multi-Part Object Name Mappings Page Cirro works with four-part object names, in the form: db.catalog.schema.object. These enable interaction with different RDBMS. However, many SQL Query Editor...
Use Excel to connect to SQL Server Database Page Connect Microsoft Excel to any SQL Server database configured in Cirro.
Cirro Direct Connect Page Use your SQL editor and Cirro account to connect to any single MySQL, Oracle, Postgres or SQL-Server database you've set up in the system.
SQL Editor Driver Installation Page Set up a client computer so you can run queries using SQL editors like DBeaver, SQuirrel or Tableau.
Setup DBeaver SQL Editor Page Connect to Cirro with DBeaver using these steps.
Setup DBVisualizer SQL Editor Page Connect to Cirro with DBVisualizer using these steps.
Setup Qlikview SQL Editor Page Connect to Cirro with QlikView SQL editor using these steps.
Setup SQL Workbenchj Page Connect to Cirro with SQL Workbenchj editor using these steps.
Setup SQuirrel SQL Editor Page Connect to Cirro with SQuirrel SQL editor using these steps.
Setup Tableau SQL editor Page Connect to Cirro with Tableau using these steps.
Setup Toad Data Point Page Connect to Cirro with Toad Data Point using these steps.

Set up your SQL Editor

Direct Connect

Use your Cirro username and password to connect to MySQL, Oracle, Postgres and SQL-Server databases without the need for additional drivers. If you're connecting to a SQL-Server database you may need to set up SSL.

Configure SSL

Cirro Direct Connect

Setup ODBC SQL Editors

Download and install the Cirro ODBC driver which enables your SQL editor to connect to Cirro's hub and view your databases as a tree.

Download & Install driver

Qlikview

Tableau

Toad Data Point

Excel

Setup JDBC SQL Editors

Download the Cirro JDBC driver then use it in your SQL editor to connect to Cirro's hub and view your databases as a tree.

Download driver

Dbeaver

Dbvisualizer

SQL Workbench J

Squirrel