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.html 

 

Instant Client for Microsoft Windows (x64) 64-bitInstant Client downloads for Microsoft Windows (x64) 64-bitt
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.