Connect Microsoft Excel to any SQL Server database configured in Cirro.

Before You Start

Before you set up any SQL client, you’ll need:

Download and install Cirro ODBC driver

First, download the Cirro ODBC driver for your system.

  • Open Cirro in a web browser.
  • Click Download Drivers, found at the bottom of the page.
  • Click the relevant 32 or 64 bit driver for your system.
  • Choose a download folder then click OK.
  • Run the downloaded installer then close when finished.

Next, we add the driver to the ODBC Data Source Administrator page.

  • Open Windows Settings and search on "ODBC"
  • Now choose the 32 or 64 bit driver version.
  • Click User DSN then Add.
  • Choose the Cirro Driver.
  • Click Finish.

When the driver is added, the system automatically displays the Cirro ODBC data source config tool.

There's two ways to setup the driver:

  1. Default - the driver defaults to "CIRRO" as the remote system. This gives access to all databases your user account has been granted.
  2. Passthrough - set up the driver with a database name and your Cirro account name and password. Click Resources then Datasources to find the database name.

You'll need to substitute your connection details for the example values below.

Field Description Example Values
Datasource Name Arbitrary title for the data source Cirro_ODBC
Cirro server hostname or ip address Hostname or IP address of the Cirro instance organization.cirro.com
Cirro server port The port the driver can access the server (defaults to 1521) 1521
Remote System Enter "CIRRO" to connect to Cirro Hub (and all the databases in the system), or use database name for passthrough connection. CIRRO
User name Cirro user name cirrouser
Password/Confirm Password Cirro user password cirropassword
Connection String Extra Properties Specific connection details. In this example, set tableNameQuery=true to use two-part object names in SQL queries (e.g., "database.schema.table" becomes "database-schema-table"). tableNameQuery=true
Extra JVM args Additional Java Virtual Machine arguments none
Log level 0-7 leave blank for default none

Get Datasource Server Name

  • Login to Cirro, Click Resources then Datasources.

You’ll find the datasource name in the first column. Make sure the Status is Enabled otherwise the connection will fail.

Configure Excel 2016+

This is an four step process.

  • First, open Excel and a blank workbook.

  • Second, Open the Data toolbar.

    • choose Get Data then From Database and From SQL Server Database.
  • Third, enter the server IP address or hostname of your Cirro server then click OK.

  • Fourth, enter your Cirro account credentials then click Connect.

Field Description Example values
User name Cirro account name @ target SQL Server database. MyCirroUser@MyDatabase
Password Cirro account password. MyCirroPassword

Configure Excel 2013

It takes two steps to add a Cirro SQL Server database to Excel 2013.

  • First, open Excel and a blank workbook.

    • Open the Data tab, then choose From Other Sources then From SQL Server.
  • Second, complete the data connection wizard.

    • Enter the server IP address or hostname of your Cirro server

    • Now click Use the following user name and password.

    Field Description Example values
    User name Cirro account name @ target SQL Server database. MyCirroUser@MyDatabase
    Password Cirro account password. MyCirroPassword
    • Click Next.

If the details are correct, Excel will load the datasource.

Clear Permissions

There are two reasons you’ll need to clear permissions:

  • You’ve entered incorrect connection details

  • You want to connect to another SQL Server database on your Cirro server.

  • Choose Data then Get Data and Datasource Settings.

  • Click Global Permissions.

  • You can choose to:

    • Clear Permissions for the selected hostname

    • Clear All Permissions.

Troubleshooting

If you’re having trouble connecting or seeing Datasources, check our Troubleshooting guide.