Adding Stored Procedures to Vantagepoint

Integrating some data from Vantagepoint into Mosaic requires a stored procedure to be added to your Cloud application. After speaking with your Mosaic Customer Success Manager about your company's needs, they will provide you with a file containing the stored procedures required for your integration.

Request to add stored procedures to your Cloud application

Go to https://deltek.custhelp.com/
Click on “Cloud Solutions”

Select your product (Vision or Vantagepoint)

On the next page, scroll to the right and under “SERVICE REQUESTS” select the “SQL Script Upload” option. There, pick the environment and database name you want the script applied to, upload the script and click on submit. These requests can take up to 3 business days to be executed…

📘
Choosing a Deltek Environment and Database Name:
Choose the Environment and Database that you have an integration with Mosaic set up for.

The Database Name will be the same one that matches your Server URL as well as the Database that you select in your Vantagepoint Login for the Vision instance that is integrated with Mosaic.

The Environment will likely be Production (i.e., your live database). If you are using a Sandbox (test environment), you will have an option to choose a "xxx_Sandbox" database in your login screen. The Production Database is usually a selection with your client name.