Lab Portal: Database ConnectionEstimated reading time: 1 minute
Data Connection for a Database
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.