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 

Privacy Policy
© 2022 CSG International, Inc.