How to Create and Connect to an InterProse ACE Database in VDM

Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.

Article Goal

Guide users through the process of creating an InterProse ACE connection profile in VDM and successfully connecting to their ACE environment for report building.

Why Create an InterProse ACE Connection?

Setting up an InterProse ACE connection in VDM enables you to:

• Build and run reports directly from your ACE environment using VDM

• Leverage ACE’s API and query builder to extract and analyze data

• Manage and centralize reporting from multiple systems within VDM

Note: BridgeWorks does not support the ACE platform directly. For help creating templates or obtaining API credentials, contact InterProse ACE Support.

Steps to Create an InterProse ACE Connection in VDM

Step 1: Log In to InterProse ACE

Use an administrator account to access ACE.
Navigate to: Reports → SQL Designer

Step 2: Set the Report Label

Set the Label to:
BridgeWorks VDM

Step 3: Set the Report Identifier

Set the Identifier to:
BRIDGEWORKS_VDM

This identifier will be used later in the VDM connection setup.

Step 4: Assign the Appropriate Role

Select or create a Role that includes all users who will build, edit, or run reports using VDM.

Step 5: Choose the Correct Output Format

Select JSON as the output format.

Step 6: Define the SQL Query Parameter

Step 6: Generate the API Key

• Go to: Setup → User

• Click Generate API Key

• Copy the generated key—you will use this during connection profile setup in VDM

This key authenticates VDM with your InterProse environment.

Step 7: Set Maximum Report Rows

• Go to: Setup → System

• Set the Maximum Report Rows limit

This controls how many rows can be returned in one report and may be adjusted based on reporting needs.

Step 8: Create the InterProse ACE Connection in VDM

In VDM:

• Click the Database tab in the ribbon

• Click New to create a new connection

Step 9: Enter the API Key

Paste the API Key from Step 6 into the API Key field in the VDM connection wizard.

Step 10: Enter the Company URL

Format:
https://YourCompanyId.interprose.com/report/runner.do

Replace YourCompanyId with your actual company ID. This is your InterProse report endpoint.

Step 11: Enter the Customer ID

Use the Company ID from Step 10 for the Customer ID.

Note: The Customer ID is case sensitive and must be entered in ALL CAPS.
Example: YOURCOMPANYID

Step 12: Enter the Report Name

Use the Identifier you set in Step 3:
BRIDGEWORKS_VDM

Step 13: Enter the Parameter Name

Set the Parameter Name to:
QueryString

Step 14: Test the Connection

Click Test Connection.

• If successful, click Next

• If unsuccessful, double-check your API Key, URL, and case-sensitive values

Successful connection means VDM can communicate with InterProse.

Step 15: Save the Connection and Load Tables

Click Save to finalize the profile.
Then click Load All to populate the Tables and Fields from your InterProse environment.

Your InterProse ACE connection is now ready to use in views and reports.

Article Summary

This article explains how to set up a connection profile in VDM to securely access and query InterProse ACE via its API. The setup includes generating an API key, configuring roles and identifiers, and entering the appropriate values into VDM's connection wizard. Once saved and loaded, the ACE data becomes available for building views and reports.