Category: Database Connectors
Introduction
This document is created to help setup a mindzieDataDesigner connector to Amazon Redshift 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 Amazon Redshift connector provides optimized connectivity to Redshift clusters for large-scale analytical workloads and process mining scenarios.
System Requirements
- Cloud Platform: Amazon Web Services (AWS)
- Database System: Amazon Redshift clusters
- Authentication: Database credentials, IAM authentication
- Network: VPC configuration, security groups
- Dependencies: Amazon Redshift .NET driver
Connection String Format
Basic Format
Server=cluster-endpoint.region.redshift.amazonaws.com;Port=5439;Database=database_name;User ID=username;Password=password;
Connection Parameters
| Parameter | Description | Required | Example |
|---|---|---|---|
Server |
Redshift cluster endpoint | Yes | mycluster.abc123.us-east-1.redshift.amazonaws.com |
Port |
Port number | No | 5439 (default) |
Database |
Database name | Yes | analytics |
User ID |
Username | Yes | mindzie_user |
Password |
Password | Yes | SecurePassword123 |
SSL |
Enable SSL | No | true |
Connection Timeout |
Connection timeout | No | 60 |
Connection Examples
Standard Redshift Connection
Server=mycluster.abc123.us-east-1.redshift.amazonaws.com;Port=5439;Database=process_analytics;User ID=mindzie_user;Password=SecurePassword123;SSL=true;
IAM Authentication
Server=mycluster.abc123.us-east-1.redshift.amazonaws.com;Port=5439;Database=analytics;User ID=IAM:iam_user;Password=temp_password;SSL=true;
Redshift Serverless
Server=workgroup.account.region.redshift-serverless.amazonaws.com;Port=5439;Database=dev;User ID=admin;Password=password;SSL=true;
Troubleshooting
Common Issues
"Connection timeout" Error
- Check VPC security groups and network ACLs
- Verify Redshift cluster is publicly accessible if needed
- Validate DNS resolution of cluster endpoint
"Authentication failed" Error
- Verify username and password are correct
- Check if user has CONNECT privilege to database
- For IAM authentication, ensure proper roles and policies
"SSL connection failed" Error
- Ensure SSL=true in connection string
- Check certificate validation settings
- Verify network allows SSL connections on port 5439
mindzie Server Access: For enhanced security, you can configure your firewall to only allow connections from mindzie servers by whitelisting specific IP addresses. Contact mindzie support to obtain the current IP addresses for the mindzie servers you are using.
Related Information
- Official Documentation: Amazon Redshift Documentation
- Performance Tuning: Redshift Performance Tuning
- Security Guide: Redshift Security
💡 Tip: Use Redshift's COPY command to efficiently load large process datasets from S3, and leverage sort keys on timestamp columns for time-based process analysis queries.