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.
Step One: Add Datasources
Add network connections for Datasources outside your network or on different servers, then add the Datasources to Cirro.
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 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.
Learn more about Access Rules and 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.
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.
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.
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.
Manage Data Projects on the View all Data Projects page.