top of page

MS SQL Server Connection Guide

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

 

The MS SQL Server connector is available for the Promethium Enterprise plan.

Connect MS SQL Server
Connecting to MS SQL Server is fast and easy. Simply click Data Sources from the menu, then click + New Data Source. Select MS SQL Server and enter the information for your MS SQL Server.
Connectors - MS SQL Server.png
MS SQL Server Connection
Title
Description
Data Source Topic
Optional. Categorize the MS SQL Server connection. For example, Marketing.
Database Name
Enter the database containing the data you want to retrieve.
Password
Enter the password associated with your MS SQL Server account.
User Name
Enter the username associated with your MS SQL Server account.
DB Port
Enter the port number for your MS SQL Server database.
Host Name
Enter the host name for your MS SQL Server database. For example: db.company.com
Description
Optional. A meaningful description for this connection.
Data Source Name
Give the MS SQL Server connection a unique name for easy identification.
What Happens Next - Finish MS 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 MS SQL Server, then make the data easily searchable and usable.

Click Data Explorer from the menu and begin exploring the data in your MS SQL Server.
Promethium Data Catalog MS SQL Server.png
FAQs
  • Is my data moved or copied out of MS SQL Server?
No. Your data stays in MS 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 MS SQL Server or as a dbt model.
  • Is this a Production-level connector?

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

Watch how to connect a Data Source
Video

Greenplum Connection Guide

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

 

The Greenplum connector is available for the Promethium Enterprise plan.

Connect Greenplum
Connecting to Greenplum is fast and easy. Simply click Data Sources from the menu, then click + New Data Source. Select Greenplum and enter the information for your Greenplum database.
Connectors - MS SQL Server.png
Greenplum Connection
Title
Description
Data Source Topic
Optional. Categorize the MS SQL Server connection. For example, Marketing.
Database Name
Enter the database containing the data you want to retrieve.
Password
Enter the password associated with your MS SQL Server account.
User Name
Enter the username associated with your MS SQL Server account.
DB Port
Enter the port number for your MS SQL Server database.
Host Name
Enter the host name for your MS SQL Server database. For example: db.company.com
Description
Optional. A meaningful description for this connection.
Data Source Name
Give the MS SQL Server connection a unique name for easy identification.
What Happens Next - Finish MS 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 MS SQL Server, then make the data easily searchable and usable.

Click Data Explorer from the menu and begin exploring the data in your MS SQL Server.
Promethium Data Catalog MS SQL Server.png
FAQs
  • Is my data moved or copied out of MS SQL Server?
No. Your data stays in MS 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 MS SQL Server or as a dbt model.
  • Is this a Production-level connector?

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

Watch how to video

Want to Learn More?

Promethium's data fabric offering is flexible. Scale data product discovery for less.

bottom of page