Overview
A Development Environment enables users to work within non-production environments. This is useful when an organization needs to ensure that the production environment is always available for end users. For example, the organization could have an environment called “ development ” where changes are made, dimensions are updated, measures are created, and so on. Once these modifications are tested they can be transferred to the live production environment.
This article details how to properly setup a development and production environment without the use of the Development Toolkit. For more information on the Development Toolkit see the following: Development Toolkit
One can setup a development and production environment on the same server or on a different server. The process is similar in either case. Where there is a difference it will be noted in the article.
Create the Development Environment
Create Project Repository (Development)
-
Open the Jet Data Manager
-
On the Tools tab select General Settings...
The Project Repository Dialog window opens.
-
In the Server Name field enter the name of the server. In this example we are using localhost.
-
In the Database field assign a name for your project repository and click the Create button. In this example we are using DevProjectRepository.
-
Click OK
Download Project from the Cube Store
-
Click on the Jet logo and select CubeStore.
-
Select the project you would like to use and click download.
If the download button is grayed out click the Request Trial Button -
Once downloaded the Connection Manager dialog will open, Click Yes.
-
Click the Run Wizard button
Creating the Staging Database (Development)
-
In the Server name field enter the name of the server where you would like to create the staging database. In this example we will be using localhost.
-
In the Database field assign a name for the staging database. In this example we choose DevNavStage.
-
Click the Create button to create the database.
-
Click OK
Connecting the Data source
-
In the Server Name field enter the name of the server that contains the data source database.
-
In the Database field select the drop down and select the data source you wish to connect.
Create the Data Warehouse (Development)
-
In the Server name field enter the name of the server.
-
In the Database field enter the name of the data warehouse. In this example we choose the Name DevNavDwh.
-
Click the Create button.
-
Click OK
Create the OLAP Server (Development)
-
In the Server name field enter the name of the server where analysis services is located.
-
In the Database field enter the name of the OLAP server. In this example we choose DevJetNavOLAP
-
Click OK
Synchronizing Table Definitions
-
Click the blue arrows.
-
Click the Yes button.
-
Accept the default values and click OK.
-
Click Yes .
-
Select the Company(s) you would like to report from and select the matching template. Click OK
If selecting more than one company select the template of the main company -
The Jet Data Manger will begin synchronizing the table definitions. Once completed the updated tables and fields will be displayed. Click OK.
-
Close the connection manager dialog.
-
On the Project tab click Manual Deployment and Execution .
-
Click Start.
Exporting the Project from the Development Environment
Once changes have been made to the development environment we will need to transfer these changes to the production environment.
-
Click on the Jet logo, click Import/Export and select Export Quick Cube Project
-
Assign a name to the project and save the file as an XML document.
-
Save the project if you haven't done so already and close the Jet Data Manager. Import the Project to the Production Environment
Import the Project and Create the Production Environment
-
Open the Jet Data Manager.
-
Navigate to Tools General Settings...
The Project Repository Dialog window opens.
-
In the Server Name field enter the name of the server. In this example we are using localhost.
-
In the Database field assign a name for your project repository and click the Create button. In this example we are using ProdProjectRepository.
-
Click OK
-
Click on the Jet logo and navigate to Import/Export → Click Import Project..
-
Select the XML file you exported in the prior section.
-
Click OK
A success dialog will appear.
-
Click Yes
-
Click Run Wizard
Create the Staging Database (Production)
-
In the Server name field enter the name of the server where you would like to create the staging database. In this example we will be using localhost.
-
In the Database field assign a name for the staging database. In this example we choose ProdNavStage.
-
Click the Create button to create the database.
-
Click OK
Connecting the Data Source
-
In the Server Name field enter the name of the server that contains the data source database
-
In the Database field select the drop down and select the data source you wish to connect.
Create the Data Warehouse (Production)
-
In the Server name field enter the name of the server.
-
In the Database field enter the name of the data warehouse. In this example we choose the Name ProdNavDwh.
-
Click the Create button.
-
Click OK
Create the OLAP Server (Production)
-
In the Server name field enter the name of the server where analysis services is located.
-
In the Database field enter the name of the OLAP server. In this example we choose ProdNavOLAP
-
Click OK
Close the connection manager dialog.
-
On the Project tab click Manual Deployment and Execution .
-
Click Start.
Special Note when Using SSIS
To prevent the PROD and DEV environments from overwriting the SSIS packages, you must:
- Use SSIS folders
and either - Rename the project in PROD after copying the project over from DEV
or - Rename the custom SSIS folder
In this example:
you must select Use SSIS folder and rename either Name (1) or Custom SSIS root folder (2)
- Use SSIS folders
Comments