Database Connection Prerequisites

Following components are required if you are using Oracle Database. These files are required to be placed on the web server. For more information, see Oracle Database Prerequisites section in the Installation.

Component	Assembly	Version	Reference
Oracle.ManagedDataAccess	Oracle.ManagedDataAccess.Dll	3.21.100	https://www.nuget.org/packages/Oracle.ManagedDataAccess.Core/3.21.100 License: https://www.oracle.com/downloads/licenses/distribution-license.html
Oracle.EntityFrameworkCore	Oracle.EntityFrameworkCore.Dll	6.21.90	https://www.nuget.org/packages/Oracle.EntityFrameworkCore/6.21.90 License: https://www.oracle.com/downloads/licenses/distribution-license.html
Oracle Instant Client			Oracle instant client – download and place within the data > Oracle > instantclientLinux - https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.htmlWindows Instant Client for Microsoft Windows (x64) 64-bitInstant Client downloads for Microsoft Windows (x64) 64-bit https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html

Optionally, it will be helpful to have database browsing tool based on the choice of DB.

If Oracle DB - Toad (compatible with installed Oracle version) or Oracle SQL Developer (compatible with installed Oracle version) with Oracle Client.
If MSSQL DB - SQL Server Management Studio (compatible with installed MS SQL Server).

NOTE:

Check SQL DB integrated windows authentication.