Integrating some data from Vision 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.
- Go to https://deltek.custhelp.com/
- Click on “Cloud Solutions”
- Select your product (Vision)
- 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 Vision 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.
Updated about 1 year ago