Setting up the tutorial

Step 1: Installing Microsoft SQL Server 2019 Developer and SQL Server Management Studio (SSMS)

Microsoft SQL Server Developer is a version of SQL Server that is free to use and distribute.

Follow these steps to download, install, and configure SQL Server 2019 Developer and the recommended SQL Server Management Studio (SSMS) software:

1. Browse to https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2019 .
2. Download the free EXE edition installer.
3. Launch the downloaded package, SQL2019-SSEI-Eval.
4. Typically, accept all the default options and locations. Proceed through all the installer panels.
5. On the last panel, choose Install SSMS, to open its browser page. There, click Download SSMS, and then click Download SQL Server Management Studio. Run SSMS-Setup-ENU.exe, its installer.
6. When completed, launch SQL Server Management Studio 20. Click Install.
7. Launch C:\SQL2019\Evaluation_ENU\SETUP.EXE
   1. Choose Installation.
   2. Choose New SQL Server standalone installation...
   3. Proceed through the panels.
      1. On the Product Key panel, specify the free edition Developer.
      2. On the Feature Selection panel, choose Database Engine Services, and then click Next.
      3. On the Instance Configuration panel, choose Default instance.
      4. On the Database Engine Configuration panel:
   1. Select Mixed Mode (SQL Server authentication and Windows authentication)
   2. In the Enter Password and Confirm Password fields, enter

      sqlserver2019

      This password is for a default administrator user named sa as will be used in the sample's connections.
8. Click Next on the remaining panels, and then click Close to exit the wizard.

You’ve now installed SQL Server Developer and its tools. The SQL Server Developer database engine starts up automatically.

Step 2: Configuring Microsoft SQL Server Developer

Corticon wants to connect to a database through TCP/IP on a designated port. Configure SQL Server for that in these steps:

1. Choose Start > SQL Server 2019 Configuration Manager.
2. Expand SQL Server Network Configuration in the left pane and select Protocols for SQLEXPRESS.
3. Right-click TCP/IP in the right pane, and then select Enabled:
   
   In the TCP/IP Properties window, click the IP Addresses tab and scroll to the bottom:
   
   
4. In the IPAll section’s TCP Port field, enter 1433, click Apply, and then click OK.
5. Restart SQL Server Express by selecting SQL Server Services in the left pane, right-clicking SQL Server (MSSQLSERVER) on the right, and then choosing Restart< as shown:
   
   

Step 3: Downloading and importing a sample rule project

Next, download and import the sample rule project Connecting_EDC which contains two Vocabularies, several Rulesheets and Ruletests, and a Ruleflow. As part of this tutorial, you will map these Vocabularies to databases in SQL Server. You can then run the Ruletests to verify that the rules in the Rulesheets are able to perform operations on the databases. Later in the tutorial, you will deploy the Ruleflow as a Decision Service using the appropriate database settings.

Follow these steps to download and import the sample rule project:

1. Click here to access the sample rule project Connecting_EDC.
2. Choose the Start menu command Progress > Corticon Studio.
3. In Studio, select the menu command File > Import.
4. In the Import wizard, select General > Existing Projects into Workspace and click Next.
   
   
5. On the Import Projects page:
   1. Click Select archive file and specify the location of the Connecting_EDC.zip file.
   2. Click Finish.
6. Expand the Connecting_EDC rule project, and you see two folders: Scenario1 and Scenario2. Each folder contains a Vocabulary and some Rulesheets and Ruletests. The Scenario2 folder also includes the Ruleflow that you will deploy later.
   
   
   
7. Select the menu command Project > Upgrade Rule Assets. Click through the dialogs to ensure that the assets in both scenarios are up to date.

Success! Your environment is now ready to use!

You will use the Cargo Vocabulary in Scenario1 to generate a database schema, and you will map the Cargo Vocabulary in Scenario2 to an existing database schema that you will create later. The Rulesheets and Ruletests enable you to do some testing. By running the Ruletests, you can verify that the rules are able to access the database. The Ruleflow in Scenario2 enables you to perform the last task in this tutorial—configuring database settings in Corticon Server during deployment.