Lab Portal: Database Connection

Estimated reading time: 1 minute

Data Connection for a Database

Step 1: Start off by navigating to https://portal.gointerject.com . Once logged in you can setup a data connection by clicking on the Data Connections icon.

Step 2: In the Data Connections page select the New Connection button in the top right-hand corner.

Step 3: In the Connection Type field, make sure Database is selected.

Step 4: The Connection Details page will contain the following information for the new connection.

  • Name: A unique friendly name used when connecting a Data Portal to the Data Connection
  • Description (optional): description of what the connection string is connecting to
  • Connection String: used by INTERJECT to connect to the specified server & database

Step 5: After adding the required information, click on the Save button to create the new data connection

The Database Data Connection is now ready to be used in a Data Portal.

Testing Connection String from within Excel

Before setting up a Data Connection to a Database, you can verify that the connection can be established within Excel.

Step 1: With Excel open, go to the INTERJECT Ribbon menu and click Advanced Menu (Skip this step if already at Advanced menu)

Step 2: Click System drop-down and select Check Connection

Step 3: Paste the database connection string you will be using to configure the Data Connection into the text-box.

When the connection functions it will display a message such as the one below.