These instructions apply to Oracle, SQL-Server, all databases that use MySQL wireprotocol and all databases that use Postgres wire protocol.

MySQL Databases

Connect to MySQL databases with these settings.

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. Include your timed one-time password if you have one MyPassword
MyPassword123456
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. Include your timed one-time password if you have one MyPassword
MyPassword123456
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 account username that has permissions on the database. MyCirroUser
Password Your Cirro account password. Include your timed one-time password if you have one MyPassword
MyPassword123456
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
Username Your cirro login with permissions on the database and the name of the database. MyCirroUser@sqlserverdb
Password Your Cirro account password. Include your timed one-time password if you have one MyPassword
MyPassword123456
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