Contents x
- Introduction
- Installation
- Self Service Licensing Guide Updated
- Prerequisites
- Decisions License Updated
- Basic
- Advanced
- Enterprise
- Containers
- Containers Overview
- Decisions Container Updated
- Decisions Environment Variables
- Deploying Containers on Docker
- Deploying Containers on Azure
- Deploying Containers on Amazon ECS
- Deploying Containers on GCP
- Deploying Azure Kubernetes Services (AKS) Updated
- Deploying an AWS Kubernetes Cluster
- Securing Decisions Container Environment
- Clustering
- Multi Tenancy
- Containers
- Upgrading
- Getting Started
- Data Structures
- Starting with Data Structures
- Creating Data Structures
- Creating Case Entities
- Creating Entities
- Creating Leased Entities
- Creating External Entities
- Creating Entity Extensions
- Creating Folder Extension Data Structures
- Creating Flow Execution Extension Data Structures
- Creating Flow Structures
- Creating Defined Data Structures
- Creating Database Structures
- Creating Value Lists
- Creating a CSV Data Structure
- Creating Types From JSON Schema
- Creating Types From XSD
- Creating Types From JSON
- Data Fields
- Building Data Structures CRUD Actions
- Data Structure CRUD Overview
- Case Entity CRUD Actions
- Database Structure CRUD Actions
- Defined Data Structure CRUD Actions
- Entity Structure CRUD Actions
- Entity Extension CRUD Actions Updated
- External Entity CRUD Actions
- Flow Execution Extension CRUD Actions Updated
- Folder Extension CRUD Actions Updated
- Managing Data Structures
- Flows
- Create Flows
- Flow Behaviors
- About Flow Behaviors Updated
- Building and Using Converter Flows
- Flow Step Trigger (After, Before, Error) Flow Behavior
- Folder Count Flow Behavior
- Login User Flow Behavior
- Post to Flow Handler Behavior
- Login User UI Flow Behavior
- Tile Source Flow Behavior
- Turn Flow Statistics On
- Get Page Variable Updated
- Report Field Action Handler Flow
- Password Reset Flow
- Creating a BPMN Flow
- Exporting BPMN Flow
- Report Group Action Flow
- Steps
- Simple Flows
- Sub Flows
- Flow Behaviors
- Configure Flows
- Debug Flows
- Implement Flows
- Best Practices
- Create Flows
- Forms
- Create Forms
- Form Controls
- Form Control Comparison
- Data Grids
- Data Repeaters
- Dropdown Lists
- Javascript Controls
- Form Control Glossary
- Form Control Behavior Overview
- Form Control Key Triggers
- Adding a Timeline to a Series of Forms
- Color Picker
- Copy-able Label
- Creating Help Text Messages for Form Fields
- Masked Textbox Control
- Currency Box and Number Box/Spinner
- Document Viewer
- Multiple File Upload and Download Controls
- Tree View Control
- User Controls
- Video Control
- Latitude and Longitude Control Updated
- HTML Display Control
- Create Form with Property Grid
- Editing Data Objects in a Wizard Property Grid
- Progress Bar Overview
- Editing CSV Records in a Form
- Simple Forms
- Form Controls
- Configure Forms
- Layout & Design
- Creating Form Backgrounds
- Layouts Overview
- Form Organization
- Grid Layout
- Canvas Layout
- Header Container Layout
- Horizontal and Vertical Stacks
- Split Panel Layout
- Responsive Containers and Grids
- Tabs Container Layout
- Using the Tab Editor to Set Tab Order
- Side Menu Containers
- Creating End Forms Updated
- Data & Logic
- CSS
- Form Settings in the Flow Designer
- Layout & Design
- Implement Forms
- Create Forms
- Rules
- Create Rules
- Creating Statement Rules
- Creating an Expression Rule
- Creating a Truth Table
- Creating an External Truth Table
- Creating a Rule Table
- Creating a Matrix Rule
- Creating a Tree Rule
- Creating a Rule Set
- Creating an Interceptor Rule
- Creating a Rule Chain
- Creating a Sequential Rule
- Leveraging Default Rules
- Rule Verbs
- Configure Rules
- Debug Rules
- Implement Rules
- Create Rules
- Reports Updated
- Pages / Dashboards
- Create Page / Dashboard
- Page Controls
- Charts
- Tiles
- Selecting a Data Drill View for the Report Viewer
- Report Viewer Control
- Flow Run Part Updated
- Folder Activity Panel
- Folder Viewer
- Tag Browser
- Adding Folder Navigation Buttons to a Page
- Horizontal Folder Timeline
- Adding Run Flow Links or Buttons to a Page
- Adding User Actions with a Page/Dashboard with the Action Bars Component
- Date Range Filter on Pages
- Filtering Reports via Page Control
- Adding an Image to a Page/Dashboard
- Page Controls
- Configure Page
- Implement Page
- Create Page / Dashboard
- Networking
- Integrations
- Azure Account and Group Sync
- Starting with Integrations
- Agents
- Database Integrations
- Integrating an External Database with a Flow
- Creating Database Table Relationships
- Creating a Database in MSSQL for Decisions
- External Database Integration
- Advanced Postgres Connection
- Integrate with Database Table
- Fetching External Data to a CSV
- Connecting with an ODBC
- Return Dynamic Data Rows When Fetching Data From Database
- Creating Access Pattern For Table Integrations
- Using Stored Procedure in Flows
- Raw SQL Step
- Integrating Decisions with External Oracle Database
- Connect to MySQL
- External Service for OData
- Adding a Query to a Database
- Add Query (Parameterized Queries)
- Using Transaction Steps
- Connecting to Amazon Redshift
- Integrating with Snowflake
- Managing Database Connection Timeouts
- Troubleshooting Database Connection Response Times
- External Webservices
- JWT
- OAuth
- REST Service Integration
- Using Decisions in External Applications
- Services
- Query Editor
- Decisions Backend
- Process Mining
- Modules
- About Modules
- Available Modules Updated
- Installing Modules
- Modules in GitHub
- Uploading and Installing Custom Modules
- Updating Custom Modules
- Generating Certificates with OpenSSL
- Active Directory
- Adobe Sign
- AI.Common
- AWS
- AWS Bedrock
- Azure
- Box Module
- Datamatics
- Docker
- Docusign
- Dropbox
- Enterprise Module
- Equifax
- Exchange Web Services
- Experian
- FHIR
- Financial
- Foreign Exchange
- Google Cloud
- Google Drive
- HL7
- HubSpot
- iCal
- Jira
- Logging.WindowsEvent
- Messaging
- MongoDB
- MSMQ
- MS OneDrive
- Okta
- OpenAI
- OpenID
- PGP
- Plaid
- PowerShell
- Python
- QR Codes
- Remedy
- R Module
- Salesforce
- SAML
- Sharepoint
- Slack
- SSH
- Symantec
- Telephony
- UnitTestCore
- USPS
- Word To PDF
- X12
- Advanced
- API and Authentication
- Troubleshooting
- Using Selenium and NUnit for Front-end Testing
- Understanding Thread Jobs and Processes
- Logging & Auditing
- Logging Overview Updated
- Logging Settings
- Reading Logs
- Using the Log Step
- Writing To Log Files
- Creating Custom Log Files
- Setting up AWS Cloudwatch Logging
- Setting Up Azure Log Analytics Integration
- Enabling W3C Logging
- Enabling Auditing
- Viewing Audit History
- Troubleshooting Using the Profiler
- Configuring Decisions with Grafana Loki
- Decisions Disaster Recovery Architecture
- SDK
- Administrators
- User Management
- Deployment
- Import & Export
- Best Practices for Decisions Deployment
- Repository
- Repository Overview
- Repository Installation
- Connecting a Decisions Server to a Repository Server
- Repository Settings
- Using The Repository
- Configuring CICD Process Using Azure DevOps
- Configuring Repository with Repo-SSO
- Repository Features and Functions
- Troubleshooting Repository
- Repository Revisions
- Repository Branches
- Sub Project Overview
- Repository Action Flows
- Customization
- Permissions
- System Folders
- System Settings
- System Folders Tree
- Customizing System Page
- Controlling Assignment Notification Types for Server
- Creating Custom Modes of Notification with Notification Flows
- Event Viewer
- Flow Management Dashboard
- System Validation Folder
- Turn Portal Statistics On
- Configuring Locations
- Stored Workflows
- Setting Up Notifications for Events
- Toolbox Visibility Rules
- Email and SMTP in Decisions
- File Archiving and Deletion
- Integration Activities
Have Questions? Need Expert Answers? JOIN LUNCH N' LEARNS!
Article summary
Did you find this summary helpful?
Thank you for your feedback
Administrators have the option to enhance the open-source database offerings and broaden their data management capabilities by integrating their SQL-based Decisions environment with a MySQL Database.
The following document demonstrates how to properly install MySQL and integrate it with a pre-existing Decisions Installation.
Upgrading from v6 to v8?
Please review Upgrading Decisions (v6 to v8) for IMPORTANT CONSIDERATIONS.
Upgrading to v8.15 and higher?
In MySQL connector versions 8.0.32 and lower, there was a dependency on the Google.Protobuf.dll. However, starting from Decisions version 8.15, it is included in the platform by default. Attempting to upgrade to version 8.15 or higher while using older MySQL connector versions can result in a failed upgrade.
To ensure a smooth upgrade to version 8.15 or later, it is recommended to delete the Google.Protobuf.dll file from the
To ensure a smooth upgrade to version 8.15 or later, it is recommended to delete the Google.Protobuf.dll file from the
C:\Program Files\Decisions\Decisions Server\Instances\Control\CustomReferences
folder before initiating the upgrade process.MySQL Install
- Install MySQL.
- Via the MySQL Product Archives, select a Product Version 8.0.33 or later from the respective drop-down. Then, select .NET & Mono under Operating System, and Download the resulting ZIP Archive.
- Extract and open the downloaded .zip file (ex: "mysql-connector-net-8.0.33-noinstall"). Open folder
net7.0
. CopyMySql.Data.dll
. Refer to the following table to copy the .dll file from the .Net version.Decisions Version Copy the .dll from 8.0 - 8.8 net6.0 8.9 + net7.0 - Paste the .dll file at
C:\Program Files\Decisions\Decisions Server\Instances\Control\CustomReferences\
. - Restart the Decisions Server (or IIS App Pool).
- Upon reconnection to the Studio, navigate to System > Integrations > Databases. Then, click CREATE CONNECTION.
- In the Database Integration window, specify a Connection Name (ex: "MySQLtest") and set the Database Type to MYSQL. Then configure the MYSQL SERVER settings, or define a Custom Connection String.
- Click TEST to confirm successful connectivity, then click OK.
- Once the database has been integrated, search and view its contents via the Query Editor.
For further information on Installation, visit the Decisions Forum.
Was this article helpful?
Thank you for your feedback! Our team will get back to you
How can we improve this article?
Your feedback
Comment
Comment (Optional)
Character limit : 500
Please enter your comment
Email (Optional)
Email
Please enter a valid email
Table of contents
Related articles