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.3.1 Initial.Interject_Reporting.sql.
FRX Migration 1.0.6 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
  • Enter the desired DB name into the Database Name field. The default is “Interject_Reporting”, but you can name it as needed 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 = '<Epicor Controlling Database Name>'
	,@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.