Who should use this guide?
You'll need a basic understanding of the SQL92 standard and relational databases.
Before you start
Check the basic setup steps have been completed, including adding your Datasources.
Setup SQL Client
Connect to Oracle, SQL-Server, or databases that use the MySQL or Postgres wire protocol.
Connect to Cirro using ODBC or JDBC drivers and perform Federated queries across your databases.
You can also use Cirro's built-in Federated Query Builder.
Cirro Query Execution and Federated Systems
When executing queries on federated systems, the behaviors of the underlying database are dominant regarding how results are calculated.
Identifiers and Reserved Words
These words are reserved in either Cirro or the SQL-92 standard and should not be used as identifier names.
SQL Syntax Notation
The Cirro SQL Guide uses a standard syntax notation.