Relational Database Integration

Rule DB – Setting Up Database

Prepare MariaDB or MySQL, import the classicmodels sample database, create the sample user, and start the database service before running Rule DB projects.

Database setup

Install the classic sample database.

Install free MariaDB or MySQL, then download the Sample Database SQL file. Open the database client and import it:

c:\Program Files\MariaDB 10.5\bin> mysql -u root -p
MariaDB [(none)]> source /mysql/mysqlsampledatabase.sql
MariaDB [classicmodels]> show databases;
MariaDB> create user 'sample'@'localhost' identified by 'sample';
MariaDB> grant all privileges on classicmodels.* to 'sample'@'localhost';

Classicmodels sample database diagram — The classicmodels database used by Rule DB samplesOpen full size ↗

Run the database

Start MariaDB before executing a sample.

In the Windows Start menu, type services in the search box.
Find MariaDB, right-click it, and choose Start the service.

Try Rule DB

Build a decision model that works directly with your data.

The free evaluation includes Rule DB and ready-to-run database examples.

Free Evaluation Quick Start