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