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

See Also 

• Connections
• Database Read Adaptor
• Database Write Adaptor
• Database Listener