Skip to main content

JDBC Connections

JDBC connections provide direct database access with support for both virtual and replicated modes.

Connection Parameters for Configuration

Essential Parameters

  • Host: Database server address

  • Port: Database port number

  • Database: Database/Schema name

  • Username: Database user

  • Password: User password

Advanced Parameters

  • SSL Mode: Encryption requirements

  • Additional Properties: Database-specific settings

  • Connect using JustPerform Agent: If enabled

    • Agent Host

    • Agent Port

    • Agent Username

    • Agent Password

Supported Databases

Database

Parameters

MySQL Server

yaml

Host: mysql.company.com

Port: 3306

Authentication Type: Basic

User ID: [username]

Password: [password]

Database: [database_name]

Additional Properties:

Connect Using SSL: Preferred/Required/VerifyCA/Certificate Identity

MS SQL Server

yaml

Host: sqlserver.company.com

Port: 1433

Authentication Type: Basic

User ID: [username]

Password: [password]

Database: [database_name]

Schema: [schema_name]

Additional Properties:

SSL Method:

UnEncrypted

Encrypted (verify certificate)

Encrypted (Trust server certificate)

PostgreSQL

yaml

Host: postgres.company.com

Port: 5432

Database: analytics

Additional Properties:

ssl: true

sslmode: require

BigQuery

yaml

Project ID: [project_id]

Dataset ID: [dataset_id]

Credentials JSON: Choose file

Snowflake

yaml

Host: [hostname]

Authentication Type: Basic Auth

Database: [database_name]

Schema: [schema_name]

Warehouse: [warehouse_name]

Role: [role_name]

Redshift

yaml

Host: [hostname]

Port: [port_number]

Authentication Type: Basic Auth

Database: [database_name]

Schema: [schema_name]

SAP HANA DB

yaml

Host: [hostname]

Port: [port_number]

Authentication Type: Basic Auth

Database: [database_name]

Schema: [schema_name]

NetSuite Analytics

yaml

Host: [hostname]

Port: 1708

Authentication Type: Basic Auth

Data Source: [data_source]

Role: [role_name]

Account: [account_id]

Configuring S3 Bucket Connection

Connection Type

S3 Bucket

Required Parameters

  • Connection ID: Unique identifier for the S3 connection

  • Description: Descriptive name for the connection

  • Source Type: S3 Bucket (automatically selected)

  • Access Key: AWS Access Key ID for authentication

  • Secret Key: AWS Secret Access Key (sensitive credential)

  • Region: AWS region where the S3 bucket is located

  • App Bucket Name: Name of the S3 bucket containing your data

Optional Parameters

  • Connect using JustPerform Agent: Enable for on-premises connectivity

Prerequisites

Supported File Formats:

  • CSV files with headers

  • JSON structured data

  • Parquet files (if supported)

  • Excel files (.xlsx, .xls)

Was this article helpful?

We're sorry to hear that.