Category: Database Connectors
Introduction
This document is created to help setup a mindzieDataDesigner connector to Oracle 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 Oracle connector provides native connectivity to Oracle Database instances using Oracle Managed Data Access (ODP.NET). This connector offers high performance, full Oracle feature support, and optimized timezone handling for global enterprises.
System Requirements
- Database System: Oracle Database 11g Release 2 or later (19c recommended)
- Supported Editions: Express Edition (XE), Standard Edition, Enterprise Edition
- Platform Support: Windows, Linux, Unix
- Cloud Support: Oracle Cloud Infrastructure (OCI), Amazon RDS for Oracle, Oracle Autonomous Database
- Dependencies: Oracle Managed Data Access (ODP.NET) - included with connector
Connection String Format
Basic Format (Easy Connect)
Data Source=hostname:port/service_name;User Id=username;Password=password;
TNS Names Format
Data Source=tns_alias;User Id=username;Password=password;
Connection Parameters
| Parameter | Description | Required | Example |
|---|---|---|---|
Data Source |
Server connection details | Yes | oracle-server:1521/ORCL |
User Id |
Oracle username | Yes | PROCESS_MINING |
Password |
Oracle password | Yes | SecurePassword123 |
Connection Timeout |
Connection timeout (seconds) | No | 60 |
Command Timeout |
Command timeout (seconds) | No | 600 |
Pooling |
Enable connection pooling | No | true |
Min Pool Size |
Minimum pool connections | No | 1 |
Max Pool Size |
Maximum pool connections | No | 100 |
DBA Privilege |
Administrative privileges | No | SYSDBA |
Persist Security Info |
Persist credentials | No | false |
Connection Examples
Local Oracle Express Edition (XE)
Data Source=localhost:1521/XE;User Id=MINDZIE_USER;Password=password;
Oracle Enterprise Database
Data Source=oracle-prod.company.com:1521/PRODDB;User Id=PROCESS_MINING;Password=SecurePassword123;Connection Timeout=60;
Using TNS Names
Data Source=PROD_ORACLE;User Id=MINDZIE_USER;Password=SecurePassword123;
Oracle Autonomous Database (Cloud)
Data Source=mydb_high;User Id=ADMIN;Password=CloudPassword123;
Connection with Advanced Settings
Data Source=oracle-server:1521/ORCL;User Id=MINDZIE_USER;Password=password;
Pooling=true;Min Pool Size=5;Max Pool Size=50;Connection Timeout=30;
Pluggable Database (PDB) Connection
Data Source=oracle-server:1521/PDB1;User Id=PROCESS_USER;Password=password;
Authentication Methods
Database Authentication
- Standard Oracle username/password authentication
- Users created with
CREATE USERstatements - Most common authentication method
OS Authentication
Data Source=oracle-server:1521/ORCL;Integrated Security=yes;
Proxy Authentication
Data Source=oracle-server:1521/ORCL;User Id=app_user;Password=password;Proxy User Id=end_user;
Troubleshooting
Common Connection Issues
"ORA-12154: TNS:could not resolve the connect identifier" Error
- Verify TNS names configuration in tnsnames.ora
- Check ORACLE_HOME and TNS_ADMIN environment variables
- Use Easy Connect syntax as alternative
- Validate service name and hostname
"ORA-01017: invalid username/password" Error
- Verify credentials are correct and user exists
- Check if account is locked:
ALTER USER username ACCOUNT UNLOCK; - Ensure user has CREATE SESSION privilege
- Validate password hasn't expired
"ORA-12505: TNS:listener does not currently know of SID given" Error
- Verify service name vs SID usage
- Check Oracle listener status:
lsnrctl status - Use service name instead of SID in modern Oracle versions
- Validate database service registration
"ORA-00257: archiver error" Error
- Check Oracle archive log space
- Contact Oracle DBA for maintenance
- Consider using read-only connection if available
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.
Oracle Cloud Issues
"ORA-28040: No matching authentication protocol" Error
- Update Oracle client to compatible version
- Check Oracle Cloud authentication requirements
- Verify SSL/TLS configuration
Oracle Autonomous Database Setup
Prerequisites
- Download Wallet: Get connection wallet from Oracle Cloud Console
- Extract Wallet: Place files in accessible directory
- Set TNS_ADMIN: Point to wallet directory
- Connection String: Use service names from tnsnames.ora
Autonomous Database Connection
Data Source=mydb_high;User Id=ADMIN;Password=WalletPassword123;
Wallet Configuration
- Extract wallet.zip to secure directory
- Set TNS_ADMIN environment variable
- Use predefined service names (HIGH, MEDIUM, LOW)
Related Information
- Official Documentation: Oracle Database Documentation
- ODP.NET Guide: Oracle Data Provider for .NET
- Connection Strings: Oracle Connection String Reference
- Oracle Cloud: Oracle Autonomous Database
- Performance Tuning: Oracle Performance Tuning Guide
💡 Tip: For enterprise Oracle deployments, consider using Oracle Real Application Clusters (RAC) connection strings with multiple hosts for high availability and load distribution.