Odbc

Category: Database Connectors

Introduction

This document is created to help setup a mindzieDataDesigner connector to any ODBC-compatible database. The mindzieDataDesigner is the ETL tool used by mindzieStudio to convert database tables to process mining event logs. The purpose of this document is to help creating the connection string and opening ports on the firewall if required.

Overview

The ODBC connector provides universal connectivity to any database system that supports ODBC drivers. This connector is ideal for connecting to databases that don't have native .NET providers or for standardized database access across multiple systems.

System Requirements

Database System: Any ODBC-compliant database
ODBC Driver: Specific driver for your target database
Platform Support: Windows (primary), Linux (limited)
Dependencies: ODBC driver for target database system

Connection String Format

DSN-Based Connection

DSN=MyDataSource;UID=username;PWD=password;

DSN-Less Connection

Driver={Database Driver Name};Server=hostname;Database=database_name;UID=username;PWD=password;

Connection Examples

Using System DSN

DSN=ProductionDB;UID=mindzie_user;PWD=SecurePassword123;

Direct Driver Connection

Driver={SQL Server};Server=server_name;Database=database_name;UID=username;PWD=password;

IBM DB2 via ODBC

Driver={IBM DB2 ODBC DRIVER};Database=SAMPLE;Hostname=db2server;Port=50000;Protocol=TCPIP;UID=username;PWD=password;

Microsoft ODBC Documentation: ODBC API Reference
Driver-Specific Documentation: Consult your database vendor's ODBC driver documentation

💡 Tip: Configure ODBC Data Sources through Windows ODBC Data Source Administrator for easier connection string management.