First time login?

As a new Cirro user you'll receive an account email which contains the URL of your Cirro installation, your password and a Timed One Time Password (TOTP) link if issued. It may also contain dates when your account is active.

LDAP or Azure Users

If you're an LDAP or Azure user, you'll be able to login to Cirro with your standard account. You may also need to set up an authenticator app.

Sales FAQs

Licensing FAQs

Cirro FAQs

Find product FAQs on each homepage in the menu on the left.

Get Help from Cirro

Sign up with Disqus with your email or login with a social media account to leave comments at the bottom of the page.

Contact support if you need to talk to someone from Cirro.

Index

Index of all product pages

The following pages and posts are tagged with

TitleTypeExcerpt
Add Datasources Page Add a datasource to Cirro. You can modify advanced settings and enable the datasource for use with Data Puppy.
Add Duo Authentication Provider Page Add Duo as an authentication provider to Cirro.
Setup Two Factor Authentication for Duo Page Set up Duo Two Factor Authentication and you'll receive a confirmation call whenever you or anyone else uses your account to login. Follow the prompts to all...
Add Saaspass Authentication Provider Page Add Saaspass as an authentication provider to Cirro.
Setup Two Factor Authentication for Saaspass Page Set up Duo Two Factor Authentication and you'll receive a confirmation call whenever you or anyone else uses your account to login. Follow the prompts to all...
Change License Plan Page A cirro license is determined by the conditions set out on the Plan page. You can change your plan conditions at any time to upgrade, downgrade or cancel you...
Cirro Login Page You can login with a Cirro account or Azure, LDAP or Active Directory account if this is set-up.
Configure Azure AD Provider in Cirro Page Microsoft Azure users can login to Cirro once the system is configured and roles created.
Configure LDAP Provider in Cirro Page Active Directory users are largely handled outside Cirro, however you can reset QR codes and grant Cirro roles and privileges.
Create Data Move Project Page It's a simple three-step process to migrate data between Cirro databases.
Create User Page Create a Cirro user account manually, through bulk upload, set passwords and authentication.
Database Driver List Page Download database drivers to use when setting up drivers in Cirro. These are then used when you set up your datasources.
Listener Configuration for Secure Connect/Direct Connect Page Configure Database listeners for Postgres, Oracle, Sql-Server and MySQL databases to ensure Direct Connect works properly.
Edit a Data Move Project Page Once you've created your Data Move Project you can edit any of the settings.
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.
Log Retention Settings Page Set how long to keep Cirro Hub and RDMBSRMS logs.
View Cirro Server Logs Page View Cirro logs and set log retention.
Manage Access Rules Page Set up access rules to manage when and how users can login to Cirro.
Manage Alert Actions Page Set up connection alerts for Secure Connect users which can notify via email or any HTML compliant system.
Manage Authentication Providers Page Set default and fallback authentication providers to improve security for Cirro accounts, as well as adding default directory services such as LDAP, Azure or...
View Data Move Projects Page Cirro data projects are a collection of settings which enable Cirro to move data from one datasource to another (e.g., All schemas in an Oracle database move...
Manage Datasource Drivers Page Add a datasource driver to Cirro to enable connection to any supported database, including Oracle, SQL-Server and MySQL.
Manage Datasources Page Manage datasources, including relational databases within Cirro for use with Data Puppy and Secure Connect users.
Manage Licenses in Cirro Page View and add a new Cirro license to your Cirro Hosted or Virtual Appliance.
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...
Manage Network Connections Page Setup OpenVPN, IPSec or SSH network connections to enable Cirro to connect securely to datasources.
Manage Roles Page You can add, edit or delete Cirro roles, assign them to users or other roles, and grant them database privileges.
Manage Secure Connect Logs Page View logs for connection attempts, session activities and access rules.
Manage My User Profile Page Your user profile gives you a way to reset your account, view and edit your datasources and your user privileges. You can even toggle between dark and light ...
Manage Users Page Add, edit or delete Cirro users, set and reset passwords, and perform any administration tasks.
Manage User Credentials with SQL Page Grant Database Credentials to a Cirro user account.
Manage Roles with SQL Page Use these SQL commands to grant or revoke roles from Cirro user accounts. You can also create roles for Active Directory user accounts.
Manage Users with SQL Page Create users and grant roles and privileges using these SQL commands.
Add L2TP/IPSEC Network Connection Page Setup an L2TP/IPSEC network connection with these instructions.
Add OpenVPN Network Connection Page Setup an OpenVPN network connection with these instructions.
Add SSH Network Connection Page SSH creates a tunnel between a local Cirro port and remote Database. The database can be running on the SSH server or be another remote machine.
Password Reset Page You can reset your user account password through the Cirro web interface, or SQL.
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.

Where do you want to start?

Getting started

Learn about Cirro Licensing and how to install the product.

Get Cirro

Data Puppy

Move data between any kind of database.

Configure

Secure Connect

Universal Database Security Reinvented.

Configure

SQL Guide

Cirro SQL is based on SQL-92.

SQL Guide