Database Connection

A connection is used by an adaptor.

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 host name (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
Database Name
- The name of the default database/schema to be connected to

Journey Hub