Add your databases to Cirro's no-perimeter, zero trust infrastructure. Cirro supports 20 different database types, from Oracle and SQL Server to Gemfire, Hawq and even BigSQL. Then use Data Projects to easily copy, migrate, subset, transform and compare & synchronize your data.

How does Cirro help manage my data?

Cirro can help your organization manage data in four ways:

First, you can use Access Control to avoid handing out database logins to everyone who needs one. Instead, you add your Databases to Cirro then grant access to your users (be they managed in Cirro or via LDAP or Azure AD).

Second, you can use Data Control to easily and quickly control the data your users can access. Give full access to DBAs, or encrypt, mask or subset table columns. And all this without having to make changes on your database.

Third, if you want to make changes to your databases, you can Create Data Projects to copy, transform, encrypt and mask tables and columns to a selected target. And that target can be the same database or a totally different one in a different location.

Last, Cirro provides connection, session, access and data project logs for audit purposes, so you know what’s happened, when and who did it.

Setup Datasources

Step One: Add Datasources

Add network connections for Datasources outside your network or on different servers, then add the Datasources to Cirro.

Add Networks

Setup network connections for Datasources on different networks.

Add L2tp/IPSEC Connection

Add OpenVPN Connection

Add SSH Connection

Manage your network connections.

Manage Network Connections

Add Datasources

It's a three step process to add your Datasources.

Start by downloading database drivers.

Download drivers

Next, add the drivers to Cirro.

Add driver

Last, add your Datasources.

Add Datasources

Manage your Datasources

Manage Datasources

Manage your Datasource drivers.

Manage Drivers

Step Two: Define Access Rules

Access Rules define who can login, how they can login, when and how, and what they can access.

Access Rules

Access rules provide application-level security to the Cirro server. They can restrict access to Users, Databases and IP or network addresses either permanently or at specified times.

User Access Rules

Data Control Access Rules

Data Management Access Rules

Learn more about Access Rules and Alert Actions

View Access Rules

View Alert Actions

Work with Data Projects

What is a Data Project?

A Data Project encapsulates all the necessary configuration, mappings, transformation logic and settings to copy data as complete tables or columns between Datasources, or validate they are synchronized.

Data can be copied or synchronized on a one-to-one basis, or using filters, transforms and masking functions to modify target data.

You can create different Data Projects for different tasks, and run them independently on the same Datasources.

Cirro Data Projects are:

  • Simple to use - Data Projects have an intuitive visual interface for mapping (connecting) Source to Target Datasources. The Project automatically maps to identically named and configured targets, but you can alter these as required.

  • Powerful - Data Projects can be set to perform smart subsetting and understands order and referential integrity.

  • Scalable - Data Projects can be scaled up and down and farmed across multiple servers, agents and threads.

  • Cross-Platform - Data Projects can transfer data across heterogeneous databases and table structures.

  • Prescriptive - Once defined, the project generates and manages the mechanics of querying, dropping and creating tables and inserting the data into the targets.

  • Transparent - When executed, Data Projects create run logs to indicate executed SQL, success or failure and other analysis. This can be exported to other tools.

  • Repeatable - Data projects can be executed as often as you wish, either scheduled or on demand.

Data Projects can be configured to run as a specific user (with their Roles and Datasource privileges), or setup so the owner is a team, as defined by a Cirro Role.

Setup Data Projects

Choose the type of Data Project, run it, then check the results.

Choose your Data Project

Copy tables and columns to another schema on the same Datasource, or a different Datasource altogether. Data can be copied in full or part and transformed with masking functions.

Copy Data

Validate (check) data between source and target schemas to locate discrepancies. Validation is made against row counts, column checksums, row checksums or every column between Source and Target Datasources.

Validate

Combine copy and validation operations which copies data first, then it's validated against Source and Target row counts, column checksums, row checksums or every column.

Copy & Validate

Synchronize will COMPARE data between Source and Target tables then generate scripts to synchronize the data. These scripts may include a mix of INSERT, DELETE and UPDATE operations.

Synchronize

Manage Data Projects on the View all Data Projects page.

Manage Data Projects

View Logs

View Data Project Logs to determine errors and check

Data Project Run Log

View Data Project Reports.

Data Project Reports