Creating An InterProse ACE Connection

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 

VDM is able to establish a connection to InterProse ACE databases. In this article we will cover creating an InterProse ACE Connection and getting connected inside VDM.

 

Please Note: BridgeWorks does not provide support for the InterProse ACE application. Please contact InterProse ACE support for assistance with creating a report template and API key for 3rd party reporting applications.

 

Steps To Create An InterProse ACE Connection

 

1. Login to InterProse ACE with an administrator account.  Select Reports then select SQL Designer.

mceclip0.png

 

2. Set the Label to BridgeWorks VDM

mceclip1.png

 

3. Set the Identifier to BRIDGEWORKS_VDM

mceclip2.png

 

4. Set the Role that will include the users building, editing or running reports in VDM.

mceclip3.png

 

5. Set SQL to ${String:QueryString} LIMIT 500000. This value is used to limit the maximum number of records that can be returned in a query.

mceclip4.png

 

6. Click Setup and then select User. Inside the User Setup, click Generate API Key.  Once the API Key is generated, copy the value. It will be used when creating the VDM Connection Profile.

mceclip5.png

 

7. Click Setup then select System. Set the Maximum Report Rows to match the Limit Value defined in step 5. This number can be increased or decreased based on your needs and will limit the maximum number of records that will be returned in your reports. 

mceclip1.png

 

8. Add a new InterProse ACE connection inside VDM.

mceclip0.png

 

9. Copy and paste the API Key from Step 6 into the API Key section.

mceclip1.png

 

10. Enter your company URL. https://YourCompanyId.interprose.com/report/runner.do

mceclip0.png

 

11. Enter your CompanyId used in Step 10 for the Customer ID.

mceclip1.png

 

12. Enter the identifier set in Step 3 for the Report Name.

mceclip4.png

 

13. Enter QueryString for the Parameter Name

mceclip5.png

 

14. Test the connection and verify that it is successful. If the Connection Passed, then click Next.

mceclip7.png

 

 

15. Save the Connection and then reload the tables using the Load All Button.

mceclip6.png

 

 

Have more questions? Submit a request

Comments