Use Data Puppy to copy data from one database to another. You can set up local and remote data agents to share the data load and view logs during and after job completion

Cirro SQL Guide

Get access to the complete set of Cirro SQL commands

SQL Guide Home

FAQ

Get answers to Frequently Asked Questions

Authentication FAQ

Get answers to Frequently Asked Questions

Index

Index of all Data Puppy pages

The following pages and posts are tagged with

TitleTypeExcerpt
Create Data Move Project Page It's a simple three-step process to migrate data between Cirro databases.
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.
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 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.

Get Started with Cirro Data Puppy

Datasources

Add database drivers, and datasources to Cirro.

Manage Drivers

Manage Datasources

Cirro Agents

Install agents on local or remote servers to help share the workload of data migration.

Manage Data Agents

Add Remote
Data Agent

Data Projects

Move data between any kind of database.

Manage Data Projects

Create a Data Project

Edit Data Project