It's now easier than ever to keep the datasource loosely but consistently coupled with the business logic within Progress Corticon. Read on to see how.
To help ensure your decision services can be deployed into different system configurations such as Dev, Test and Production, it’s important to keep your rules free of database configuration. In Progress Corticon 5.7, we’ve improved the process by packaging all database configuration details in one XML file for easier integration.
Once the datasource connection has been set up, you can export the file and use it for any rule project. Developers and database administrators can also update the file for fine-grained control over how Decision Services access the database.
In the Vocabulary menu in Corticon Studio, select Add Datasource and choose either ADC or EDC. Then enter the datasource connection information as shown below. For more information on how to set up datasource access, see the Corticon Server: Data Integration Guide.
Figure 1: Set-up screen for datasource configuration
In the Vocabulary menu, select Datasource Configuration File > Export…
Figure 2: Menu selection to export the Datasource Configuration file.
The resulting XML file includes all the defined connections to external datasources and looks similar to the code shown below.
Database administrators can use the Datasource Configuration file to specify exactly how Corticon accesses the database, including authentication protocols, properties, trace generation and logs. Simply include any properties supported by the database driver in the connection URL, as in the example below.
This approach solves some challenges of past Corticon versions that made it hard for DBAs to tightly manage database access.
Developers can easily move from one environment to another as the project proceeds. Just export the Datasource Configuration file, update the URL and include the appropriate username and password. The deployment administrator can then seamlessly integrate the file in the new environment.
In the Datasource Configuration file, the username and password are encrypted. And if the same configuration needs to be used for another database instance with different credentials, Corticon ships with an encryption utility you can invoke by accessing CORTICON_HOME]\Server\bin\ and typing the command corticonManagement -en -i <string to encrypt>. The script yields an encrypted string you can specify in the XML.
corticonManagement -en -i <string to encrypt>
Since the Datasource Configuration manages all aspects of the connection, rule modelers can leave database details to administrators and deployment engineers. And with those details in just one XML file, it’s much easier to keep the datasource loosely but consistently coupled with the business logic.
We hope this ability, along with the new feature upgrades in Corticon 5.7, make your life as a developer easier. You can check out everything that’s new in the latest version of Corticon here, and if you’re new to Corticon feel free start a free trial or reach out and request a demo.
Zoheb works in the capacity of a Principal Technical Support Engineer supporting Corticon and DataDirect. He has spent about a decade developing and supporting software systems and Customer Service is his calling.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You have the right to request deletion of your Personal Information at any time.
You can also ask us not to pass your Personal Information to third parties here: Do Not Sell My Info
Copyright © 2020 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.