Category: Database Connectors
Introduction
This document is created to help setup a mindzieDataDesigner connector to Firebird 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 Firebird connector provides connectivity to Firebird databases across all supported platforms. This connector supports both embedded and server architectures, making it suitable for applications ranging from single-user desktop applications to multi-user enterprise systems.
System Requirements
- Database System: Firebird 2.5 or later (Firebird 4.0+ recommended)
- Architecture: Classic, SuperServer, SuperClassic
- Platform Support: Windows, Linux, macOS, Unix
- Dependencies: FirebirdSql.Data.FirebirdClient .NET provider
Connection String Format
Basic Format
Server=hostname;Database=database_path;User=username;Password=password;
Connection Parameters
| Parameter | Description | Required | Example |
|---|---|---|---|
Server or DataSource |
Server hostname | Yes | firebird.company.com |
Port |
Server port | No | 3050 (default) |
Database |
Database file path | Yes | /data/process.fdb |
User or User ID |
Username | Yes | SYSDBA |
Password |
Password | Yes | masterkey |
Charset |
Character set | No | UTF8 |
Connection Timeout |
Connection timeout | No | 15 |
Pooling |
Connection pooling | No | true |
Connection Examples
Local Embedded Database
Server=localhost;Database=C:\Data\ProcessMining.fdb;User=SYSDBA;Password=masterkey;
Remote Server Connection
Server=firebird-server.company.com;Database=/opt/firebird/data/analytics.fdb;User=MINDZIE_USER;Password=SecurePassword123;
Connection with Charset
Server=firebird.company.com;Database=/data/process.fdb;User=SYSDBA;Password=password;Charset=UTF8;
Embedded Database (No Server)
Database=C:\MyApp\data\embedded.fdb;User=SYSDBA;Password=masterkey;ServerType=1;
Troubleshooting
Common Issues
"Connection rejected by remote interface" Error
- Check Firebird server is running
- Verify hostname and port configuration
- Check firewall settings
- Ensure database file exists and is accessible
"Login failed" Error
- Verify username and password
- Check if user account exists
- Ensure user has connect privileges
- Validate authentication method
"Database file not found" Error
- Verify database file path is correct
- Check file permissions
- Ensure path uses correct directory separators
- Confirm database file exists
"Arithmetic overflow or division by zero" Error
- Check for numeric overflow in calculations
- Validate data types in operations
- Review stored procedure logic
- Check for division by zero conditions
Related Information
- Official Documentation: Firebird Documentation
- Firebird .NET Provider: FirebirdSql.Data.FirebirdClient
- SQL Reference: Firebird SQL Reference
- Performance Guide: Firebird Performance Tips
💡 Tip: Firebird's multi-generational architecture provides excellent concurrency for read-heavy process mining workloads without reader-writer conflicts.