For details on the database software versions and editions that are required on the application server, see the software recommendations subsection for the HxGN SDx Application Server platform recommendations.
For Oracle database access, install the following:
Oracle client software
After installing the Oracle client on the application server, the server should be rebooted.
Oracle Net Server database software, to configure a local net service name pointing to the database server.
For more information about installing Net Server, see the Oracle documentation.
To provide access to the SQL Server database when it is installed on a separate database server, install the following Microsoft SQL Server Shared Features on the application server:
Client Tools Connectivity
Client Tools Backwards Compatibility
Client Tools SDK
SQL Client Connectivity SDK
SQL Server Management Studio (SSMS) and is no longer distributed with the database engine setup program. SSMS is delivered as a separate product by Microsoft.
Instead of installing the SQL Server Shared Features, you can install two packages from the SQL Server Feature Pack, downloadable from Microsoft. Select the 64-bit versions of each, version 13 for SQL Server 2016 or version 14 for SQL Server 2017.
Microsoft ODBC Driver for Microsoft SQL Server - Windows (msodbcsql.msi)
Microsoft SQL Server Command Line Utilities (MsSqlCmdLnUtils.msi)