Data Tier Install

Estimated reading time: 1 minute

After you get access to Interject, there are three parts to installing Interject Financials - Epicor. First is the initial data tier install, then the data load from Epicor and FRx, then the actual report configurations in the Interject application.

Prerequisites
  • VPN Connectivity \(if install is from Remote\)
  • Verify and Download Interject Install Scripts
Script Version Link
Base Install and data transfer 1.0.7 Initial.Interject_Reporting.sql.
FRX Migration 1.0.4 Migration Script

Steps Required for Technical Install

To-do

Step 1: Connect to your Epicor server as SysAdmin in SQL MGT Studio

Step 2: Create Interject Reporting Database

  • Right Click New Database in the Object Explorer New database
  • Type “Interject_Reporting” into the Database Name field New database
  • Press OK

Step 3: Point the script window to the new database Mgt Studio Point

Step 4: Execute the Initial.Interject_Reporting.sql script

Step 5: Create security objects and grant read-only access to Epicor tables by passing the following parameters using the following script as an example:

EXEC [Custom].[Interject_SetupScript1_Security]
	@MasterEpicorDatabase = 'samplemasterdb'
	@CertificatePassword =  'myPassword1234'
  • 5a: MasterEpicorDatabase (specify master Epicor DB)
  • 5b: CertificatePassword (create a certificate with a custom password)

Technical Note: This will create [LocalDomain]/InterjectUser group and provide it with a new db_Interject role. This role will have execute rights to 3 schemas [Client], [Custom], and [Report]. This script also creates a certificate and signs store procedures that have dynamic code. The certificate provides read only access to the sign store procedures on the already-used tables of your Epicor databases. If at any point these store procedures are changed, the certificate will be invalidated and will need to be reapplied.