---
title: SQL Server Connector - Catalog, Transform, Query, Visualize
description: The SQL Server connector allows data to be cataloged, queried, transformed and to create tables in SQL Server.
---

[Promethium Blog ](https://blog.promethium.ai)

# [SQL Server Connector - Catalog, Transform, Query, Visualize](https://blog.promethium.ai/post/sql-server-connector-catalog-transform-query-visualize)

 Written by [Brett Arnott, VP Marketing](https://blog.promethium.ai/author/brett-arnott-vp-marketing) | Mar 28, 2022 7:00:00 AM

 The SQL Server connector allows data to be cataloged, queried, transformed and to create tables in SQL Server. This can be used to quickly and easily join data between different systems like SQL Server and Hive, or between different SQL Server instances.

 

The SQL Server connector is available for the Promethium Enterprise edition. The SQL Server connector is currently not available for the Free or Professional editions.

> If you don't have a Promethium account, get your [free account now](https://onboarding.pm61data.cloud/user/register)

[Jump to the how to video.](https://blog.promethium.ai/post/sql-server-connector-catalog-transform-query-visualize?hs_amp=true#video)

## **Connect SQL Server**

Connecting to SQL Server is fast and easy. Simply click **Data Sources** from the menu, then click **+ New Data Source**. Select SQL Server and enter the information for your SQL Server.

SQL Server Connection

 

SQL Server connection details can be case sensitive. Ensure that data is entered with the correct case for your SQL Server.

| **Field**   | **Description**   |
| --- | --- |
| Data Source Name   | Give the SQL Server connection a unique name for easy identification.   |
| Description   | Optional. A meaningful description for this connection.   |
| Data Source Topic   | Optional. Categorize the SQL Server connection. For example, Marketing.   |
| Host Name   | Enter the host name for your SQL Server database. For example: [db.company.com](http://db.company.com)   |
| DB Port   | Enter the port number for your SQL Server database.   |
| User Name   | ​Enter the username associated with your SQL Server account.   |
| Password   | Enter the password associated with your SQL Server account.   |
| Database Name   | Enter the database containing the data you want to retrieve.   |

## What Happens Next - Finish SQL Server Connection

Click the **Connect** button then select schemas. After successful connection and schema selection Promethium will automatically crawl and catalog data in your SQL Server, then make the data easily searchable and usable.

Click **Data Explorer** from the menu and begin exploring the data in your SQL Server Data Cloud.

 

SQL Server Data Catalog Promethium

 

## FAQs

### Is my data moved or copied out of SQL Server?

No. Your data stays in SQL Server and isn't moved to Promethium.

### What options are available for publishing datasets?

Datasets can be published as a view, as a table in SQL Server or as a dbt model.

### Is this a Production-level connector?

Yes. The SQL Server connector is designed for all-sized Datasets.

## Watch how to video

 

[View full post](https://blog.promethium.ai/post/sql-server-connector-catalog-transform-query-visualize)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Brett Arnott, VP Marketing"
  },
  "dateModified" : "2022-04-27T15:37:49.034Z",
  "datePublished" : "2022-03-28T07:00:00Z",
  "headline" : "SQL Server Connector - Catalog, Transform, Query, Visualize",
  "image" : {
    "@type" : "ImageObject",
    "height" : 624,
    "url" : "https://7260385.fs1.hubspotusercontent-na1.net/hubfs/7260385/Imported_Blog_Media/file-4.png",
    "width" : 999
  },
  "mainEntityOfPage" : "https://blog.promethium.ai/post/sql-server-connector-catalog-transform-query-visualize",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Promethium Blog"
  }
}
```