Connections & Data Sources

inferonIQ connects to your existing databases and document stores. All credentials are encrypted at rest.

Supported Databases

DatabaseAuth MethodDefault PortNotes
PostgreSQLUsername/Password5432+ SSL, pgvector support
SnowflakeUsername/Password or Key Pair443Account identifier required
BigQueryService Account JSONProject ID + dataset
OracleUsername/Password1521Service name or SID
SQL ServerSQL Auth or Windows Auth1433TDS encryption supported
MySQL / MariaDBUsername/Password3306SSL optional

Supported Document Sources

SourceAuthUse Case
SharePointOAuth 2.0 (Microsoft)Enterprise document libraries
OneDriveOAuth 2.0 (Microsoft)Personal/shared invoice folders
AWS S3Access Key + SecretCloud document storage
Google DriveOAuth 2.0 (Google)Team drives and shared folders
Email (IMAP)OAuth 2.0 or App PasswordAuto-ingest emailed invoices

How It Works — Secure Agent

All database connections go through a lightweight inferonIQ Agent deployed inside your network. The agent connects outbound on port 443 — no firewall changes, no IP whitelisting, no public database exposure.

Your Database ←── Agent (your network) ── WSS 443 ──→ inferonIQ Relay ←── HTTPS ──→ Platform

  1. Add Connection — Select database type → Generate Agent Token
  2. Deploy Agent — Run our Docker container inside your network (Azure VNET, AWS VPC, on-prem, etc.)
  3. Enter Credentials — Host, port, database, username, password (as seen from the agent's network)
  4. Test & Save — Agent connects to your DB locally, verifies connectivity, reports back
  5. Auto-Profile — Schema discovery runs through the agent (tables, columns, types, relationships)
  6. Ready — Connection available for AI queries, matching, and pipelines

Security

  • Outbound-only — Agent initiates all connections on port 443. No inbound firewall rules
  • No data storage — Agent is a stateless query executor. Results stream back in real-time
  • Encrypted transport — TLS 1.3 (WSS) end-to-end, same encryption as HTTPS
  • Credentials encrypted at rest — AES-256-GCM encrypted in the platform
  • Read-only access recommended — inferonIQ only needs SELECT permissions
  • HMAC-authenticated — Each agent has a unique signed token
  • Auto-reconnect — Exponential backoff recovery (5s → 60s)
  • SOC 2 compliant — Principle of least privilege throughout

Firewall Requirements

RuleDirectionPortDestination
Allow outbound HTTPSOutbound443relay.inferoniq.com

No inbound rules needed. No IP whitelisting. No VPN. If your network allows outbound HTTPS, the agent will work.