Costpoint GCCM Environments

The table in this topic details the Environments and Systems (databases) that are included in the GCCM offering.

In the table below, CompanyName is equal to the System Name that was provided, by your company, to Deltek prior to your cloud activation.

Environment	System Name(s)	Description
Production	REGENT (PROD)	Purpose Your company's live production database is deployed and maintained in this environment. Access Only the Deltek Cloud Operations team has access to the database residing in the Production Environment. Direct access (using a database tool) to the database in the Production Environment is not permitted. Deltek does provide ODBC access to your Production database. Application Version The applications running in the Production Environment run the latest version of the application software. Attention: For more information on when updates are made to the applications running in the Production Environment, refer to the Application Lifecycle topic.
Non Production	REGENTCONFIG REGENTSBOX Customers can purchase additional Systems (databases).	Purpose The CONFIG databases are intended to be used when implementing Costpoint. The SBOX database can be used for multiple purposes. It can be used to support your company's implementation of Costpoint, training users and/or to test your configuration changes before these changes are applied to your Production database. This Sandbox database is where you can test configuration changes before you implement these changes in your company's production database. Companies should implement Costpoint using both their CONFIG and Production database. Companies should plan to be live in their Production database when they complete their implementation. SQL Access Users have elevated rights to their databases in the Non Production Environment. This allows users to perform implementation services, data migration and testing. Users have access to database tools in the Non Production Environment allowing them to connect directly to the databases in the Non Production Environment. The SaaS Customer Administrator must submit the Request SQL Access to Non Production Databases service request to grant a user with rights to the database tool. You can grant a user either read only or read/write SQL rights. Citrix is required to access the database tools. SQL Rights Granted Command Read Only Rights Read/Write Rights SELECT on Objects X X INSERT on Objects X UPDATE on Objects X DELETE on Objects X ALTER ANY INDEX ALTER ANY PROCEDURE ALTER TABLE CREATE ANY PROCEDURE CREATE ANY TABLE CREATE ANY TYPE CREATE ANY TRIGGER CREATE ANY VIEW CREATE ANY INDEX DELETE ANY TABLE DROP ANY TABLE EXECUTE ANY PROCEDURE INSERT ANY TABLE SELECT ANY TABLE UPDATE ANY TABLE Cloud AD Group Membership {client}-SQL-READONLY {client}-SQL The SaaS Admin must also add the user's Cloud AD Account to the following Group Memberships in the Cloud Active Directory: {client}-SQL-READONLY {client}-SQL Application Version (Costpoint Updates) When applying major or minor updates to the cloud, these updates will be applied to the Non Production Environment prior to applying these updates to the Production Environment. Maintenance Releases, referred to as MR's, are applied to all Environments at the same time. Attention: For more information on when updates are made to the applications running in the Production Environment, refer to the Application Lifecycle topic. Database Refresh Up to a maximum of 12 times per year, customers can request their Costpoint database (CONFIG, SBOX) to be refreshed. A Database Refresh service request must be submitted in order for Deltek to process a database refresh. At certain times Database refreshes are not permitted. Attention: Please refer to the Application topic as well as the detailed instructions for the Database Refresh service request in order to understand these blackout periods. IMPORTANT: Deltek reserves the right to reset your Sandbox database back to a blank database at anytime. Typically resetting your Sandbox database is only done when a major upgrade is scheduled. If Deltek plans to reset your Sandbox database to a blank database, this will be communicated to you prior to any action taking place.
Web Services Development Environment (WIC)		If you plan to use Costpoint's Web Services feature you can request access to a Web Services Development Environment. The Web Services Development Environment will provide you with access to the Costpoint Web Integration Console (WIC). Note: Deltek will decommission Web Services Development Environments that are not actively being used. Please submit the Request Web Services service request to provision a Web Services Development Environment.