Category: Database Connectors
Introduction
This document is created to help setup a mindzieDataDesigner connector to Vertica 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 Vertica connector provides high-performance connectivity to Vertica analytical databases. Optimized for big data analytics and complex queries, this connector supports Vertica's columnar storage and massively parallel processing capabilities.
System Requirements
- Database System: Vertica 9.0 or later (Vertica 11+ recommended)
- Deployment: On-premise, Vertica on AWS, Vertica on Azure, Vertica on Google Cloud
- Platform Support: Linux, Windows
- Dependencies: Vertica ADO.NET driver
Connection String Format
Basic Format
Server=hostname;Port=5433;Database=database_name;User=username;Password=password;
Connection Parameters
| Parameter | Description | Required | Example |
|---|---|---|---|
Server |
Vertica server hostname | Yes | vertica-cluster.company.com |
Port |
Server port number | No | 5433 (default) |
Database |
Database name | Yes | analytics_db |
User |
Username | Yes | mindzie_user |
Password |
Password | Yes | SecurePassword123 |
ConnectionTimeout |
Connection timeout | No | 60 |
SSL |
Enable SSL connection | No | true |
Connection Examples
Standard Connection
Server=vertica-node1.company.com;Port=5433;Database=process_analytics;User=mindzie_user;Password=SecurePassword123;
SSL-Enabled Connection
Server=vertica-cluster.company.com;Port=5433;Database=analytics_db;User=analyst;Password=password;SSL=true;
Cloud Connection
Server=vertica-aws.company.com;Port=5433;Database=cloud_analytics;User=cloud_user;Password=CloudPassword123;SSL=true;
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: Vertica Documentation
- Performance Guide: Vertica Performance Tuning
💡 Tip: Design your queries to take advantage of Vertica's columnar storage by selecting only necessary columns and using efficient WHERE clause predicates.