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 detailed instructions, please refer to the section Oracle Database Prerequisites in the AE-RPA- Installation Guide.

 

Component Assembly Version Reference
Oracle.ManagedDataAccess Oracle.ManagedDataAccess.Dll 2.19.80

https://www.nuget.org/packages/Oracle.ManagedDataAccess.Core/

 

License: 
https://www.oracle.com/downloads/licenses/distribution-license.html
Oracle.EntityFrameworkCore Oracle.EntityFrameworkCore.Dll 3.19.80

https://www.nuget.org/packages/Oracle.EntityFrameworkCore/

 

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.