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 ENCRYPTION KEY Page Use ALTER ENCRYPTION KEY to make changes to an existing key, with the same syntax.
ALTER PROJECT Page Alter a Data project with this syntax.
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.
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 ENCRYPTION KEY Page CREATE ENCRYPTION KEY creates an encryption key within the system, saving it to a specified location.
CREATE JOB Page Create Job inserts scripts into the scheduler.
CREATE PROJECT Page Create a Data project with this syntax.
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.
Create Unloq.io authentication Page Add Unloq.io authentication to Cirro.
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.
DECRYPT data Page Use an encryption key to decrypt table data.
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 data Page Use an encryption key to encrypt table data.
EXECUTE PROJECT Page Execute/run the specified data project. EXECUTE PROJECT executes in the current session synchronously.
I need to change the 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 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 ...
REVOKE SELECT on encryption key Page REVOKE SELECT on an encryption key from users or roles.
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.