Manage Datasources

Manage datasources, including relational databases within Cirro for use with Data Puppy and Secure Connect users.

Note: You can whitelist the Cirro server IP address if your database is outside your network (e.g., Amazon RDS). For networks without a VPN, update your firewall to allow the Cirro Server IP address or set up an SSH tunnel.

Tip: Contact Support for help with Hadoop or Hive setup.

Before you start

Add datasource drivers for each database you’re going to add.

Note: Cirro comes with the Postgres driver pre-installed.

Get the source/hostname, database name and Port ID of any database you want to connect to.
You’ll also need a username and password which Cirro uses to connect to the datasource. Its privileges should correspond to the level of access you want.

View All Datasources

You can view, add, edit or delete datasources from here.

Click Resources then Datasources.

Column	Description
Name	User supplied descriptive name for use in Cirro
Type	Type of datasource such as Oracle or Postgres
Server	Host server containing the database
Login	User login account to connect to Database
Database	Database on the host server
Data Puppy	Datasource enabled for Data Puppy

Tip: Open your account to manage your own datasources

Add Datasource

Add a datasource to Cirro using a driver you’ve already set up and datasource credentials. You can modify advanced settings and enable the datasource for use with Data Puppy.

Tip: Contact Support for help with Hadoop or Hive setup.

Add Datasource

Click Resources then Datasources.
Click Add Datasource
Enter the datasource name and choose the type. These will determine the fields that follow.

Tip: If you’re intending to use Cirro Direct Connect to connect to your database, make sure you accept the default port number for the JDBC driver.

Choose the driver or click Add Driver
Enter the connection details requested by Cirro.

Additional Functions	Description
Enable for Data Puppy	Data Puppy allows free movement of data between different databases. Enabling the datasource for Data Puppy does two things: * Allows the datasource to be used as a system of multiple datasources within Cirro. * Enables additional fields, accessible when you click Additional Settings.
Additional Settings	Additional Settings enables a collection of fields used to further configure your database should you require.
Preview	Click Preview to view the SQL that will be used to create the Datasource in Cirro.

Click Save when finished.

Edit Datasource

If you’re editing a datasource take care to ensure it’s not in use at the time.

Click Resources then Datasources.
Click Edit Datasource from the Actions Menu.
Edit the Name or any settings.

Note: You can’t change the datasource type when you edit.

Click Save when finished.

Delete Datasource

Take care when deleting datasources to make sure there are no dependencies such as Data Puppy Projects or logged in users

Warning: Deletion is permanent.

Click Resources then Datasources.
Click Delete Datasource from the Actions Menu.
Click Yes on the confirmation message.

tags: