Database server support

Oracle® database server is no longer supported to host the Alfabet database.

Azure®SQLServer is supported.

For Microsoft® SQL server databases, the Microsoft .NET Framework driver has been removed. It is not running on .NET Framework 6.

SQL server connection pooling has been implemented for connections to the database server. With connection pooling, opening and closing a connection is no longer required for each database request, but all requests are handed over to a pool of persistent connections. Connection pooling enhances performance.

Fields removed from the server alias configuration:

• Database Settings > Details tab:
  • Database Driver
  • Database Driver Type
  • Database Host
  • Database Port
  • Database Service Name
  • Direct Connection
  • Indirect Connection
  •  Database Connection Count

Fields added to the server alias configuration: Database Settings > Details Database Access

For database servers not supporting a restricted mode, set this attribute to State . For all other databases it should be set to Restricted . The restricted mode is used during database maintenance activities like update of the meta-model or restore of a database from an ADBZ or ADB7 file to prevent any other activity on the database. If the database server does not support a restricted mode, a status information is set in the Alfabet database during database maintenance activities to inhibit access by other Alfabet components.