Use your SQL editor and Cirro account to connect to any single MySQL, Oracle, Postgres or SQL-Server database you've set up in the system.
Before You Start
- Accept default JDBC driver settings for connection to the host
Database Port MySQL 3306 Oracle 1521 Postgres 5432 SQL-Server 1433
- Note the system name for your SQL editor connection.
Note: Set up LDAP or Azure AD if you want to use a directory service.
Connect to a database with your Cirro user
Note: We’ve made field titles as generic as possible in the following examples. The field titles will differ based on the database type you’re connecting to.
Open your SQL editor and the connection dialog.
Use the Cirro installation as the server, hostname or IP address (depending on your editor and the database you’re connecting to).
- Your username is your Cirro account name
- Your password is your Cirro password.
Note: Append your Timed One-Time Password (supplied through an app like Google Authenticator) to the end of your password.
- Use the database system name as the Service Name/SID (if required)
SERVICE NAME/SID: ORA1