LogoLogo
HOMEBLOG
  • Getting Started
  • Connect to Data
    • Projects
    • Data Connectors
      • Google BigQuery
      • Google Cloud Storage
      • Iceberg
      • Snowflake
      • AWS S3
      • AWS Athena
      • AWS Redshift
      • Databricks Delta
      • Azure Blob
      • Salesforce
      • SAP Hana
      • File Path Options
      • SQL Server
      • Trino
    • Connection Modes
    • Triggering Scans
    • Configuring a Data Source
  • Profiling Data
    • Data Health Metrics
    • Data Health Overview Page
    • Interactive Profiling Tool: Investigator
    • Data Diff
    • Compound Attributes
      • List of Supported Functions
  • Monitoring Data
    • Data Quality Metrics
    • Alert Policies
    • Data Trends and Alerts
    • Metrics Inspector
  • Data Quality Rules
    • Rules Expression Examples
  • PII Data Detection
  • Remediation
    • Data Binning
    • Circuit Breaker
  • Integrations
    • Jira Integration
    • Slack
    • Jobs Status Notification
  • User Management
    • Okta SSO Setup
    • SSO Configuration
  • API Reference
    • Authentication API
    • API Keys
    • Telmai IP List
    • Get Google Service Account API
  • Source APIs
    • Source APIs
  • Upload Data APIs
    • Upload data from Cloud
      • RedShift Request data
      • GCS Request data
      • Azure Request data
      • GBQ Request data
      • Snowflake Request data
      • Amazon S3 Request data
      • Delta Lake Request
      • Trino Request data
    • Track upload job
    • Check for alerts
  • Admin APIs
    • User Management
  • Telmai Releases
    • Release Notes
      • 25.2.0
      • 25.1.3
      • 25.1.2
      • 25.1.0
Powered by GitBook
On this page
  1. Connect to Data
  2. Data Connectors

SQL Server

SQL Server can be hosted on prem or run in Azure, GCP or AWS.

PreviousFile Path OptionsNextTrino

Last updated 7 months ago

To connect to SQL Server, chose it's icon from the list of available connections which will open the following dialog

Fill in following details in the form. We use Azure SQL service as an example here:

  1. Server: The server name. It can be found in Azure Portal: SQL Server -> Server Name -> Overview -> Server Name

  2. Database: The database name. This can be found in the Azure Portal at the following location: SQL Server -> Server Name -> Overview -> Available Resources -> (x) databases. Pls choose the appropriate database to connect to from this list

  3. Database or Schema: The schema to connect to

  4. User: The username

  5. Password : The password

Note:

  1. The User and Password above are for the SQL Authentication.

  2. In order to connect to a privately hosted instance, the customer will need to whitelist the IPs from Telmai. Please reach out to Telmai support for the updated list of IP’s for whitelisting.

Data Types Supported:

JSON data type is not supported for SQL Server connections out of the box. Please reach out to Telmai support if it needs to be enabled

Please ensure that your environment has whitelisted .

Telmai IP list
Add Source for MS Sql Server