Database File Location
For SQL Server, IBSR backup files are included in the Insbridge -Windows folder under databases. In the event that db_owner permissions are not possible or if backup files cannot be used and DDL scripts are needed, SQL Server DDL scripts can be found on the server where Insbridge was installed in the …//Oracle/Insbridge/SoftRater folder.
SQL Server DDLs are not included in the Insbridge -Windows folder. DDL scripts can be found on the server where Insbridge was installed in the …//Oracle/Insbridge/SoftRater folder.
For example: C:\Program Files\Oracle\Insbridge\SoftRater\DDL
SQL Server Upgrade Scripts
DDL scripts can be found on the server where Insbridge was installed in the …\\Oracle\Insbridge\SoftRater folder. For example: C:\Program Files\Oracle\Insbridge\SoftRater\DDL
An Upgrade folder is located inside each of the database types with one upgrade script and Instructions for running the update. When upgrading from a release prior to release 5.0. users must create new and re-load packages.
JDBC Driver Class
“com.microsoft.jdbc.sqlserver.SQLServerDriver”
Supported Versions – 2016 and 2019
User Account Requirements
- Create Table
- Create Index
- Execute on the SoftRater User Defined Stored Procedures