Configure your SQL client to connect direct to any Oracle and SQL-Server Datasources, and any that use the MySQL or Postgres wire protocol.

Before You Start

  • Confirm you can login to Cirro using your User ID and password.

  • Click your account name at top right, then My Account, and confirm you have access to the appropriate Datasources.

MySQL Databases

Connect to any datasource that uses the MySQL wire protocol.

Field Description Example
Host Cirro URL or IP address. cirroserver.com
Username Your cirro login with permissions on the database and the name of the database. MyCirroUser@mysqldb
Password Your Cirro account password. MyPassword
Port Database port 3306

Oracle Databases

Connect to Oracle Databases with these settings.

Field Description Example
Service Name Cirro URL or IP address. cirroserver.com
Username Your Cirro account username that has permissions on the database. MyCirroUser
Password Your Cirro account password. MyPassword
Port Database port 1521

Postgres Databases

Connect to Postgres Databases with these settings.

Field Description Example
Hostname Cirro URL or IP address. cirroserver.com
Username Your cirro login with permissions on the database and the name of the database. MyCirroUser@postgresdb
Password Your Cirro account password. MyPassword
Port Database port 5432

SQL-Server Databases

Connect to SQL-Server Databases with these settings.

Field Description Example
Host Cirro URL or IP address. cirroserver.com
Database/Schema Master  
Username Your cirro login with permissions on the database and the name of the database. MyCirroUser@sqlserverdb
Password Your Cirro account password. MyPassword
Port Database port 1433

Troubleshooting

Error message Cause Solution
Unsupported oracle database version The database driver the SQL client is using is incorrect for the database version you’re connecting to. e.g., Target system is Oracle 12x, and driver is too old. Download drivers
SQL Server did not return a response. The connection has been closed. User account has no privileges on Datasource. Grant privileges on Datasource