Database Connectors Overview
Category: mindzieDataDesigner
Supported Data Connections
Click any connector below to view its detailed documentation.
Introduction
mindzieDataDesigner provides native database connectors that enable direct connectivity to your data sources. These connectors are used to extract data from various database systems and transform it into event logs for process mining analysis in mindzieStudio.
Supported Database Systems
mindzieDataDesigner supports a wide range of relational database systems, from lightweight embedded databases to enterprise-grade data warehouses.
Enterprise Databases
| Connector | Description |
|---|---|
| Microsoft SQL Server | Full support for SQL Server 2012+, Azure SQL Database, and Azure SQL Managed Instance |
| Oracle | Native connectivity to Oracle Database 11g and later versions |
| IBM DB2 | Support for IBM DB2 on z/OS, i Series, and LUW platforms |
| SAP HANA | High-performance connectivity to SAP HANA in-memory database |
| SAP SuccessFactors | OData API connectivity to SAP SuccessFactors HCM |
| Teradata | Enterprise data warehouse connectivity |
Cloud Data Warehouses
| Connector | Description |
|---|---|
| Snowflake | Cloud-native data warehouse connectivity |
| Amazon Redshift | AWS cloud data warehouse support |
Open Source Databases
| Connector | Description |
|---|---|
| PostgreSQL | Full support for PostgreSQL 9.4 and later |
| MySQL | Support for MySQL 5.6+ and MariaDB |
| Firebird | Open source relational database support |
| H2 | Lightweight Java SQL database |
Desktop and Embedded Databases
| Connector | Description |
|---|---|
| SQLite | Lightweight file-based database |
| Microsoft Access | Microsoft Access database files (.mdb, .accdb) |
Legacy and Specialized Systems
| Connector | Description |
|---|---|
| Sybase ASE | Sybase Adaptive Server Enterprise |
| Vertica | High-performance analytics database |
| ODBC | Generic ODBC connectivity for any ODBC-compliant data source |
Choosing the Right Connector
When selecting a connector, consider:
Native vs ODBC: Use native connectors when available for better performance and feature support. Use ODBC only when a native connector is not available for your database.
Authentication: Most connectors support both database authentication and integrated authentication (Windows/Kerberos). Choose based on your security requirements.
Network Configuration: Ensure proper firewall rules and network access between mindzieDataDesigner and your database server.
Common Configuration Steps
All database connectors follow a similar configuration pattern:
- Install Required Drivers: Some connectors require additional client drivers to be installed
- Configure Connection String: Build the connection string with server, database, and authentication details
- Test Connectivity: Verify the connection before using it in data transformation scripts
- Set Up Security: Configure appropriate database permissions for the mindzie service account
Security Best Practices
- Use dedicated service accounts with minimum required permissions
- Enable encrypted connections (SSL/TLS) when possible
- Store credentials securely using environment variables or secure vaults
- Regularly rotate database passwords
- Monitor and audit database access
Getting Help
If you encounter issues with a specific connector:
- Check the individual connector documentation for troubleshooting steps
- Verify network connectivity and firewall configuration
- Confirm database credentials and permissions
- Contact mindzie support for additional assistance