(...loading)
Lab 16.2 Database Connection

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.