Data Tier InstallEstimated 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.
|Base Install and data transfer||1.3.1||Initial.Interject_Reporting.sql.|
|FRX Migration||1.0.6||Migration Script|
Steps Required for Technical Install
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.