Data Platforms Reference

This reference provides comprehensive technical details about Coginiti's supported data platforms, connection parameters, authentication methods, and platform-specific configurations.

Platform Support Overview

Coginiti supports two tiers of database connectivity:

Primary Connectors: Full CoginitiScript integration, deep object browsing, automatic script generation, and data insert capabilities
Generic JDBC: Basic SQL querying capabilities with manual JDBC configuration

Primary Connector Platforms

Cloud Data Platforms

Amazon Redshift

Platform Type: Cloud Data Warehouse
Default Port: 5439
JDBC Driver: Amazon Redshift JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Host: Redshift cluster endpoint
Port: 5439 (default)
Database: Target database name
SSL Mode: disable, allow, prefer, require

Authentication Methods:

Standard (Username/Password)
AWS Profile
AWS IAM Credentials
Identity Provider Federation (SAML/OIDC)

Advanced Properties:

ApplicationName=Coginiti
loginTimeout=30
socketTimeout=0
tcpKeepAlive=true

Features:

Automatic schema discovery
Table and view browsing
Stored procedure support
Query result caching
Distribution key awareness

Amazon Athena

Platform Type: Serverless Query Service
Default Port: 443
JDBC Driver: Amazon Athena JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

S3 Output Location: Required for query results
Region: AWS region
Workgroup: Athena workgroup (optional)

Authentication Methods:

AWS Profile
AWS IAM Credentials
Instance Profile (EC2)

Advanced Properties:

S3OutputLocation=s3://your-bucket/athena-results/
Workgroup=primary
LogLevel=INFO

Features:

Glue Data Catalog integration
Partitioned table support
Cost optimization features
Query history tracking

Databricks

Platform Type: Unified Analytics Platform
Default Port: 443
JDBC Driver: Databricks JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Server Hostname: Databricks workspace URL
HTTP Path: Cluster or SQL warehouse path
Port: 443 (HTTPS)

Authentication Methods:

Personal Access Token
OAuth 2.0
Azure Active Directory (Azure Databricks)

Advanced Properties:

AuthMech=3
UID=token
PWD=<personal-access-token>
ConnCatalog=<catalog-name>
ConnSchema=<schema-name>

Features:

Unity Catalog support
Delta Lake integration
Cluster auto-scaling awareness
Notebook integration capabilities

Snowflake

Platform Type: Cloud Data Platform
Default Port: 443
JDBC Driver: Snowflake JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Account: Snowflake account identifier
Warehouse: Compute warehouse
Database: Default database
Schema: Default schema
Role: User role (optional)

Authentication Methods:

Username/Password
Key Pair Authentication
OAuth 2.0
SAML 2.0

Advanced Properties:

warehouse=COMPUTE_WH
db=ANALYTICS_DB
schema=PUBLIC
role=ANALYST
application=Coginiti

Features:

Multi-cluster warehouse support
Time travel query capabilities
Secure data sharing
Resource monitoring integration

Google BigQuery

Platform Type: Serverless Data Warehouse
Default Port: 443
JDBC Driver: Google BigQuery JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Project ID: Google Cloud project
Dataset: Default dataset (optional)
Location: Data location (optional)

Authentication Methods:

Service Account JSON Key
Application Default Credentials
OAuth 2.0 User Credentials

Advanced Properties:

ProjectId=my-gcp-project
DefaultDataset=analytics
Location=US
JobCreationMode=JOB_CREATION_REQUIRED

Features:

Standard SQL support
Partitioned table optimization
Geographic data types
Machine learning integration

Microsoft Synapse

Platform Type: Analytics Service
Default Port: 1433
JDBC Driver: Microsoft SQL Server JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Server: Synapse SQL endpoint
Database: SQL pool database
Port: 1433 (default)

Authentication Methods:

SQL Authentication
Azure Active Directory (Password)
Azure Active Directory (Integrated)
Azure Active Directory (MFA)

Advanced Properties:

encrypt=true
trustServerCertificate=false
loginTimeout=30
applicationName=Coginiti

Features:

Dedicated SQL pool support
Serverless SQL pool support
Azure Data Lake integration
Apache Spark pool connectivity

Microsoft Fabric

Platform Type: Analytics Platform
Default Port: 1433
JDBC Driver: Microsoft SQL Server JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Server: Fabric SQL endpoint
Database: Fabric database
Workspace: Fabric workspace

Authentication Methods:

Azure Active Directory
Service Principal
Managed Identity

Advanced Properties:

encrypt=true
authentication=ActiveDirectoryPassword
applicationName=Coginiti-Fabric

Features:

OneLake integration
Power BI connectivity
Real-time analytics
Data pipeline integration

Yellowbrick

Platform Type: Hybrid Cloud Data Warehouse
Default Port: 5432
JDBC Driver: PostgreSQL JDBC Driver (compatible)
CoginitiScript Support: ✅ Full

Connection Parameters:

Host: Yellowbrick cluster endpoint
Port: 5432 (default)
Database: Database name
SSL Mode: prefer, require

Authentication Methods:

Username/Password
LDAP Authentication
Kerberos Authentication

Advanced Properties:

ssl=true
sslmode=require
ApplicationName=Coginiti
prepareThreshold=0

Features:

Massive parallel processing
Columnar storage optimization
Advanced analytics functions
GPU acceleration support

Cloud Databases

Amazon Aurora

Platform Type: Cloud Database
Default Port: 3306 (MySQL), 5432 (PostgreSQL)
JDBC Driver: MySQL or PostgreSQL JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Endpoint: Aurora cluster or instance endpoint
Port: 3306 (MySQL), 5432 (PostgreSQL)
Database: Database name

Authentication Methods:

Username/Password
IAM Database Authentication
RDS Proxy Authentication

Advanced Properties:

# MySQL Aurora
useSSL=true
requireSSL=true
serverTimezone=UTC

# PostgreSQL Aurora
ssl=true
sslmode=require
ApplicationName=Coginiti

Features:

Multi-AZ deployment support
Read replica awareness
Performance Insights integration
Serverless v2 support

Amazon RDS (Multiple Engines)

PostgreSQL

Default Port: 5432
JDBC Driver: PostgreSQL JDBC Driver

Connection Parameters:

Host: RDS instance endpoint
Port: 5432 (default)
Database: Database name
SSL Mode: disable, allow, prefer, require

Oracle

Default Port: 1521
JDBC Driver: Oracle JDBC Driver

Connection Parameters:

Host: RDS instance endpoint
Port: 1521 (default)
Service Name: Oracle service name
SID: Oracle SID (alternative)

DB2

Default Port: 50000
JDBC Driver: IBM DB2 JDBC Driver

Connection Parameters:

Host: RDS instance endpoint
Port: 50000 (default)
Database: Database name

SQL Server

Default Port: 1433
JDBC Driver: Microsoft SQL Server JDBC Driver

Connection Parameters:

Host: RDS instance endpoint
Port: 1433 (default)
Database: Database name
Instance: Named instance (if applicable)

Google Cloud SQL

Platform Type: Fully Managed Relational Database
Default Port: Varies by engine
JDBC Driver: Engine-specific driver
CoginitiScript Support: ✅ Full

Supported Engines:

PostgreSQL (Port 5432)
MySQL (Port 3306)
SQL Server (Port 1433)

Connection Parameters:

Instance Connection Name: project:region:instance
Database: Database name
SSL: Required for secure connections

Authentication Methods:

Username/Password
Cloud SQL Auth Proxy
Private IP connectivity

Google AlloyDB

Platform Type: PostgreSQL-Compatible Database
Default Port: 5432
JDBC Driver: PostgreSQL JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Host: AlloyDB instance endpoint
Port: 5432 (default)
Database: Database name
SSL Mode: require (recommended)

Authentication Methods:

Username/Password
IAM Authentication
Built-in connection pooling

Features:

PostgreSQL compatibility
Columnar engine support
Intelligent indexing
Read pool scaling

Microsoft Azure SQL

Platform Type: Cloud Database Service
Default Port: 1433
JDBC Driver: Microsoft SQL Server JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Server: Azure SQL server name
Database: Database name
Port: 1433 (default)

Authentication Methods:

SQL Authentication
Azure Active Directory (Password)
Azure Active Directory (Integrated)
Managed Identity

Advanced Properties:

encrypt=true
trustServerCertificate=false
authentication=ActiveDirectoryPassword
applicationName=Coginiti-Azure

Features:

Elastic pools support
Automatic tuning
Threat detection
Backup and restore automation

Enterprise Data Platforms

Apache Hive

Platform Type: Data Warehouse Software
Default Port: 10000
JDBC Driver: Apache Hive JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Host: HiveServer2 endpoint
Port: 10000 (default)
Database: Hive database (default: 'default')

Authentication Methods:

No Authentication (for development)
Kerberos
LDAP
Custom authentication

Advanced Properties:

AuthMech=1
KrbRealm=HADOOP.COM
KrbHostFQDN=hive.hadoop.com
KrbServiceName=hive

Features:

Hadoop ecosystem integration
Partitioned table support
SerDe customization
ACID transaction support (Hive 3.0+)

Apache Spark (with Thrift)

Platform Type: Unified Analytics Engine
Default Port: 10000
JDBC Driver: Apache Spark JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Host: Spark Thrift server endpoint
Port: 10000 (default)
Database: Spark database

Authentication Methods:

No Authentication
Kerberos
Custom authentication

Advanced Properties:

AuthMech=0
transportMode=http
httpPath=cliservice

Features:

DataFrame API integration
Catalyst optimizer awareness
Delta Lake support
Streaming query capabilities

Greenplum

Platform Type: Massively Parallel Processing Database
Default Port: 5432
JDBC Driver: PostgreSQL JDBC Driver (compatible)
CoginitiScript Support: ✅ Full

Connection Parameters:

Host: Greenplum master host
Port: 5432 (default)
Database: Database name

Authentication Methods:

Username/Password
LDAP Authentication
Kerberos Authentication

Advanced Properties:

ssl=true
sslmode=prefer
ApplicationName=Coginiti-Greenplum
prepareThreshold=0

Features:

Segment-aware query planning
External table support
PXF (Platform Extension Framework)
In-database analytics

IBM DB2

Platform Type: Enterprise Relational Database
Default Port: 50000
JDBC Driver: IBM DB2 JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Host: DB2 server hostname
Port: 50000 (default)
Database: Database name
Schema: Default schema (optional)

Authentication Methods:

Username/Password
Kerberos Authentication
SSL Client Certificates

Advanced Properties:

currentSchema=ANALYTICS
applicationName=COGINITI
keepAlive=true
loginTimeout=30

Features:

Advanced SQL features
XML data type support
Temporal tables
Column-organized tables

IBM Netezza

Platform Type: Data Warehouse Appliance
Default Port: 5480
JDBC Driver: IBM Netezza JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Host: Netezza host
Port: 5480 (default)
Database: Database name

Authentication Methods:

Username/Password
LDAP Authentication

Advanced Properties:

loginTimeout=30
queryTimeout=0
logLevel=0

Features:

Zone maps optimization
Materialized views
User-defined functions
Advanced analytics functions

Microsoft SQL Server

Platform Type: Enterprise Database Platform
Default Port: 1433
JDBC Driver: Microsoft SQL Server JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Host: SQL Server hostname
Port: 1433 (default)
Database: Database name
Instance: Named instance (optional)

Authentication Methods:

SQL Server Authentication
Windows Authentication (Integrated Security)
Azure Active Directory

Advanced Properties:

encrypt=false
trustServerCertificate=true
applicationName=Coginiti
selectMethod=cursor

Features:

Always On Availability Groups
Columnstore indexes
In-memory OLTP
JSON data support

Oracle

Platform Type: Enterprise Database System
Default Port: 1521
JDBC Driver: Oracle JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Host: Oracle server hostname
Port: 1521 (default)
Service Name: Oracle service name (recommended)
SID: Oracle SID (legacy)

Authentication Methods:

Username/Password
Kerberos Authentication
Oracle Wallet

Advanced Properties:

oracle.jdbc.J2EE13Compliant=true
oracle.net.CONNECT_TIMEOUT=10000
oracle.jdbc.ReadTimeout=30000

Features:

Pluggable databases (PDB)
Advanced security features
Partitioning support
Advanced analytics

Trino

Platform Type: Distributed SQL Query Engine
Default Port: 8080
JDBC Driver: Trino JDBC Driver
CoginitiScript Support: ✅ Full

Connection Parameters:

Host: Trino coordinator
Port: 8080 (default)
Catalog: Data catalog
Schema: Default schema

Authentication Methods:

No Authentication (development)
Password Authentication
Kerberos
JWT Authentication

Advanced Properties:

SSL=true
user=analytics_user
applicationNamePrefix=Coginiti

Features:

Multi-catalog queries
Connector ecosystem
Cost-based optimization
Dynamic filtering

Generic JDBC Support

Supported Databases

The following databases can be connected using generic JDBC drivers:

MySQL - Popular open-source database
MariaDB - MySQL-compatible database
DuckDB - Analytical in-process database
SQLite - Embedded database
H2 Database - Java-based database
Apache Derby - Pure Java database
Firebird - Cross-platform database
SAP HANA - In-memory database platform
Teradata - Enterprise data warehouse
Vertica - Columnar analytics platform

Generic JDBC Configuration

Connection Setup:

Upload custom JDBC driver JAR file
Specify JDBC URL manually
Configure authentication parameters
Test connection

JDBC URL Patterns:

MySQL: jdbc:mysql://host:port/database
PostgreSQL: jdbc:postgresql://host:port/database
SQLite: jdbc:sqlite:path/to/database.db
H2: jdbc:h2:file:path/to/database

Feature Limitations

Generic JDBC connections provide:

✅ SQL query execution
✅ Result set viewing
✅ Basic metadata access
❌ CoginitiScript support
❌ Automatic script generation
❌ Deep object browsing
❌ Data insert capabilities
❌ Platform-specific optimizations

Connection Best Practices

Security

Always use SSL/TLS in production
Implement proper authentication
Use least-privilege database accounts
Rotate credentials regularly
Monitor connection logs

Performance

Configure appropriate connection pooling
Use read replicas for analytics workloads
Optimize network connectivity
Set reasonable timeout values
Monitor query performance

Reliability

Test connections regularly
Implement retry logic
Monitor database health
Plan for failover scenarios
Keep drivers updated

Platform-Specific Notes

Cloud Platforms

Configure VPC/network security groups appropriately
Use managed authentication when available
Leverage platform-specific features (IAM, Key Vault, etc.)
Monitor costs and resource usage
Plan for regional availability

Enterprise Databases

Coordinate with database administrators
Follow corporate security policies
Plan for maintenance windows
Document connection configurations
Implement proper backup strategies

Big Data Platforms

Consider cluster scaling implications
Optimize for large result sets
Leverage partitioning strategies
Monitor resource utilization
Plan for data lifecycle management

For detailed connection setup instructions, see the Database Connections How-To Guide.

Platform Support Overview​

Primary Connector Platforms​

Cloud Data Platforms​

Amazon Redshift​

Amazon Athena​

Databricks​

Snowflake​

Google BigQuery​

Microsoft Synapse​

Microsoft Fabric​

Yellowbrick​

Cloud Databases​

Amazon Aurora​

Amazon RDS (Multiple Engines)​

PostgreSQL​

Oracle​

DB2​

SQL Server​

Google Cloud SQL​

Google AlloyDB​

Microsoft Azure SQL​

Enterprise Data Platforms​

Apache Hive​

Apache Spark (with Thrift)​

Greenplum​

IBM DB2​

IBM Netezza​

Microsoft SQL Server​

Oracle​

Trino​

Generic JDBC Support​

Supported Databases​

Generic JDBC Configuration​

Feature Limitations​

Connection Best Practices​

Security​

Performance​

Reliability​

Platform-Specific Notes​

Cloud Platforms​

Enterprise Databases​

Big Data Platforms​

Platform Support Overview

Primary Connector Platforms

Cloud Data Platforms

Amazon Redshift

Amazon Athena

Databricks

Snowflake

Google BigQuery

Microsoft Synapse

Microsoft Fabric

Yellowbrick

Cloud Databases

Amazon Aurora

Amazon RDS (Multiple Engines)

PostgreSQL

Oracle

DB2

SQL Server

Google Cloud SQL

Google AlloyDB

Microsoft Azure SQL

Enterprise Data Platforms

Apache Hive

Apache Spark (with Thrift)

Greenplum

IBM DB2

IBM Netezza

Microsoft SQL Server

Oracle

Trino

Generic JDBC Support

Supported Databases

Generic JDBC Configuration

Feature Limitations

Connection Best Practices

Security

Performance

Reliability

Platform-Specific Notes

Cloud Platforms

Enterprise Databases

Big Data Platforms