This is the index of all Data Puppy pages. If you've got a question leave a comment in the form below.

Index

This is the index of all Data Puppy pages

The following pages and posts are tagged with

TitleTypeExcerpt
Add Remote Data Agent Page Agents help spread the load of data migration on remote or local database servers. Follow these instructions to install and configure a data agent on a remot...
Add Remote Data Agent with SQL Page Use data agents on your remote database systems to better load balance data migration.
ALTER PROJECT MAP Page Alter a project map with these SQL commands.
ALTER VIEW - ADD/DROP PROJECTION Page View projections are Cirro's implementation of row and column security. They allow the same view to return different data depending on who selects from them.
Add Unloq.io authentication Page Add Unloq.io authentication to Cirro.
BEGIN...END Page
CANCEL PROJECT Page The CANCEL PROJECT statement will terminate a running project, i.e. find the session and cancel its statement. This requires the CANCEL SESSION privilege.
CREATE/ALTER ENCRYPTION KEY Page CREATE ENCRYPTION KEY creates an encryption key within the system, saving it to a specified location. Use ALTER ENCRYPTION KEY to make changes to an existing...
CREATE/ALTER PROJECT Page Create or Alter a Data project with this syntax.
CREATE JOB Page Create Job inserts a data project script into the scheduler.
CREATE REMOTE DATABASE Page Creates a local synonym for a remote database. This functionality is used to create mappings to the four-part object names required by Cirro.
CREATE TABLE as SELECT Page Alters the SELECT query of an existing, non-materialized view.
Data Move Memory Issues Page Cirro Data Agents may require adjustments to Datasource Batch and Target Transfer Memory usage to work efficiently. You'll also need to alter JVM heap memory...
Data Puppy Index Page This is the index of all Data Puppy pages. If you've got a question leave a comment in the form below.
Drop Encryption Key Page DROP ENCRYPTION KEY deletes a named encryption key from Cirro.
DROP JOB Page Drops an existing scheduled job.
DROP PROJECT Page DROP PROJECT changes the project's status flag to INACTIVE. Inactive projects will not usually be displayed. This is to maintain history of project runs unti...
DROP REMOTE DATABASE Page Drops an existing remote database reference.
ENCRYPT/DECRYPT data Page Use an encryption key to encrypt or decrypt table data.
EXECUTE PROJECT Page Execute/run the specified data project. EXECUTE PROJECT executes in the current session synchronously.
FAQ - Change Query Delimiter Page You can change the query delimiter from the standard semicolon to any single character.
FAQ - SQL Client cannot connect Page Check these solutions if you're having difficulty connecting.
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.
GRANT/REVOKE SELECT on encryption key Page Grant SELECT on an encryption key to users or roles.
My SQL Client can't connect to a Cirro Database Page You've tried to connect to a Cirro database but nothing happens or there's an error message.
Manage Cirro Data Agents Page Agents help spread the load of data migration on remote or local database servers. The standard Cirro license comes with one RDBMS Agent and you can install ...
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 clients can ...
Use Excel to connect to Cirro SQL Server Database Page Connect Microsoft Excel to any SQL Server database configured in Cirro.
SHOW PROJECT Page Display any data project using these commands.
Cirro Direct Connect Page Use your sql client and Cirro account to connect to any MySQL, Oracle, Postgres or SQL Server database you've set up in the system.
SQL client Driver Installation Page Set up a client computer so you can run queries using sql clients like DBeaver, SQuirrel or Tableau.
Setup DBeaver SQL client Page Connect to Cirro with DBeaver using these steps.
Setup DBVisualizer SQL client Page Connect to Cirro with DBVisualizer using these steps.
Setup Qlikview SQL client Page Connect to Cirro with QlikView sql client using these steps.
Setup Oracle SQL developer client Page Use Cirro Direct Connect with Oracle SQL Developer.
Setup SQL Workbenchj SQL Client Page Connect to Cirro with SQL Workbenchj editor using these steps.
Setup SQuirrel SQL client Page Connect to Cirro with SQuirrel sql client using these steps.
Setup Tableau SQL client Page Connect to Cirro with Tableau using these steps.
Setup Teradata SQL Assistant Page Setup Teradata SQL Assistant.
Setup Toad Data Point SQL Client Page Connect to Cirro with Toad Data Point using these steps.