Data Tier Install

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

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
• Enter the desired DB name into the Database Name field. The default is “Interject_Reporting”, but you can name it as needed
• Press OK

Step 3: Point the script window to the new database

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.