Skip to main content

SQl Server

Connecting to SQL Server​

Promethium integrates with Microsoft SQL Server to enable metadata discovery and distributed querying. Once connected, Promethium will crawl schemas and tables, build a searchable catalog, and allow users to query SQL Server data alongside other connected sources.

This guide walks you through the steps to securely connect your SQL Server instance to Promethium using read-only access.

Prerequisites​

To connect SQL Server to Promethium, you’ll need the following:

  • SQL Server Hostname
    • Example: sqlserver.company.com
  • Port
    • Default: 1433
  • Database Name
    • The database Promethium should crawl and query
  • Network Access
    • Promethium must be able to reach the SQL Server host (VPN, peering, or firewall allowlist)

Authentication​

Two forms of authentication are supported;

  1. Local user: Requires a local user and password on the SQL Server instance.
  2. Active Directory Service Principal: Preferred method for Azure SQL. Requires a service principal ID and secret.

💡 We recommend creating a dedicated SQL Server user for Promethium with limited read-only privileges.

Supported Objects​

Promethium supports crawling and querying the following SQL Server objects:

  • Tables
  • Views
  • Primary and foreign keys (where available)