Database Connection
- 04 Oct 2024
- 1 Minute to read
- Contributors
- Print
- DarkLight
- PDF
Database Connection
- Updated on 04 Oct 2024
- 1 Minute to read
- Contributors
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
We have included an Interactive Training to provide a more engaging and visual learning experience. End users are required to complete their training through the CSG University.
A Database adaptor uses this connection.
- Database Type
- Postgres SQL version 9. X - includes Amazon Web Services Aurora
- MySQL version 5.6 and above - includes Amazon Web Services Aurora
- MSSQL - Microsoft SQL Server 2012 and above - includes SQL Azure
- Oracle - 10i and above
- User Name
- Name of the user to login to the database
- Note for SQL Server on Azure, the username is user@server - where 'server' is the first part of the fully qualified domain name for the database
- e.g. if the server is kwdb.database.windows.net and the user is kwheel, then the username should be kwheel@kwdb
- Password
- Password of the user to login to the database
- Host Name
- Physical hostname (IP address or fully qualified domain name) of the database server or name of the load balancer (Oracle)
- Port
- The port on which the database is listening for connections. The default ports for the supported databases are:
- Postgres - 5432
- MySQL - 3306
- MSSQL - 1433
- Oracle - 1521
- The port on which the database is listening for connections. The default ports for the supported databases are:
- Database Name
- The name of the default database/schema to be connected to
Related Pages
Is it helpful? React and share your comment
