Developing with INTERJECT

Estimated reading time: 6 minutes

Overview

This section is for professional developers who create the data pathways for reports and applications that can edit data. To facilitate this section, we provide a sample database to assist in training. Please contact us for the files at info@gointerject.com .

The sample database is called Interject_Example_v1 . This database is available for SQL Server versions 2008 to 2017 and works easily with the free express version. Download SQL Server Express here.

To complete the developer training, you must have Client Admin permissions within an existing INTERJECT account. Verify the correct role at the INTERJECT Website Portal at https://portal.gointerject.com For help with logging in, see Logging In to the Website Portal .

Navigate by using the following links to continue with the training objectives:

INTERJECT Website Portal Overview

The INTERJECT website portal is a central place to manage INTERJECT client settings and user profiles. For an INTERJECT developer, the most used areas of the INTERJECT website portal are managing connections and data portals.

Defining INTERJECT for Developers

Developers often assume that INTERJECT is useful only in building simple reports, not extending to workflow creation or collecting user inputs. However, INTERJECT is truly an application platform that can extend reports into two-way interfaces, which have the impact and scalability of a website application.

Simple Data Pull

To clearly illustrate the end-to-end workflow of developing a report, you can begin with several simple data pull examples showing different report configurations. You will be reusing INTERJECT reports used in previous sections, because these should be familiar to you if you read this documentation from the beginning. By the end of these sections, you will understand the process of creating spreadsheet friendly reports that can drill to other reports.

Advanced Data Pull

INTERJECT reports can handle a wide variety of complex reports. Up to this point you have seen simple reports where a single recordset is returned to single area of the spreadsheet. This topic will share advanced reporting configurations that use multiple recordsets and multiple INTERJECT report formulas and supporting functions to construct advanced presentations.

Simple Data Save

Interject allows for the editing of data and uploading those changes directly into the database it is connected to. This requires a different Data Portal.

Security Best Practices

Managing security is a key component of the Interject platform, and there are several areas to understand. Security involves both the row level security that can exist in reports and apps and how the middle tier objects are secured. Security also includes which spreadsheet report template can be seen by which users. The paragraphs here discuss each of these areas, best practices in building, and methods to test user access.

Managing Settings Cache

INTERJECT optimizes speed by caching company settings, such as Data Portals, Connections, and Report Library templates. This information is received on login and is stored in memory for as long as the Excel session is open. This is an important topic for new deployments where these settings may need to change often. If there are any changes to these company settings, the INTERJECT Excel add-in will check for changes at various actions.

Common Troubleshooting

There are times when a report does not work. INTERJECT has several tools to quickly and accurately diagnose the problem, whether it is in the Excel Report itself, or if it’s an application error. This helps to reduce downtime which saves money. The following section gives a detailed look at some of the tools available.