--- title: PostgreSQL Connector - Catalog, Transform, Query, Visualize description: The PostgreSQL connector allows data to be cataloged, queried, transformed and to create tables in PostgreSQL. image: https://blog.promethium.ai/hubfs/Imported_Blog_Media/file-Apr-26-2022-04-41-31-45-PM.png --- Mar 22, 2022 12:00:00 AM # PostgreSQL Connector - Catalog, Transform, Query, Visualize [ Brett Arnott, VP Marketing ](https://blog.promethium.ai/author/brett-arnott-vp-marketing) Share: [Share this page on LinkedIn ](http://www.linkedin.com/shareArticle?mini=true&url=https://blog.promethium.ai/post/postgresql-connector-catalog-transform-query-visualize) [Share this page on Twitter ](https://twitter.com/intent/tweet?url=https://blog.promethium.ai/post/postgresql-connector-catalog-transform-query-visualize) [Send us an email ](mailto:?body=https://blog.promethium.ai/post/postgresql-connector-catalog-transform-query-visualize) The PostgreSQL connector allows data to be cataloged, queried, transformed and to create tables in PostgreSQL. This can be used to quickly and easily join data between different systems like PostgreSQL and Hive, or between different PostgreSQL instances. The PostgreSQL connector is available for all Promethium editions, including Free (coming soon), Professional and Enterprise. > 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/postgresql-connector-catalog-transform-query-visualize#viewer-fvs9a). ## **Connect PostgreSQL** Connecting to PostgreSQL is fast and easy. Simply click **Data Sources** from the menu, then click **+ New Data Source**. Select **PostgreSQL** and enter the information for your PostgreSQL. ![Image of PostgreSQL connection in Promethium](https://blog.promethium.ai/hs-fs/hubfs/Imported_Blog_Media/14385e_9f0224f5b4d64669bcdb10a1ab29e929~mv2.png?width=1802&height=944&name=14385e_9f0224f5b4d64669bcdb10a1ab29e929~mv2.png) PostgreSQL Connection PostgreSQL connection details can be case sensitive. Ensure that data is entered with the correct case for your PostgreSQL. | **Field** | **Description** | | --- | --- | | Data Source Name | Give the PostgreSQL connection a unique name for easy identification. | | Description | Optional. A meaningful description for this connection. | | Data Source Topic | Optional. Categorize the PostgreSQL connection. For example, Marketing. | | Host Name | Enter the host name for your PostgreSQL database. For example: [db.company.com](http://db.company.com) | | DB Port | Enter the port number for your PostgreSQL database. | | User Name | ​Enter the username associated with your PostgreSQL account. | | Password | Enter the password associated with your PostgreSQL account. | | Database Name | Enter the database containing the data you want to retrieve. | ## What Happens Next - Finish PostgreSQL Connection Click the **Connect** button then select schemas. After successful connection and schema selection Promethium will automatically crawl and catalog data in your PostgreSQL, then make the data easily searchable and usable. Click **Data Explorer** from the menu and begin exploring the data in your PostgreSQL Data Cloud. ![Screenshot of PostgreSQL data in Promethium](https://blog.promethium.ai/hs-fs/hubfs/Imported_Blog_Media/14385e_3fdb100b344a469299bcf1fbcd7d5fe8~mv2.png?width=2696&height=1848&name=14385e_3fdb100b344a469299bcf1fbcd7d5fe8~mv2.png) PostgreSQL Data Catalog Promethium ## FAQs ### Is my data moved or copied out of PostgreSQL? No. Your data stays in PostgreSQL and isn't moved to Promethium. ### What options are available for publishing datasets? Datasets can be published as a view, as a table in PostgreSQL or as a dbt model. ### Is this a Production-level connector? Yes. The PostgreSQL connector is designed for all-sized Datasets. ## Watch how to video [Metadata Catalog](https://blog.promethium.ai/tag/metadata-catalog), [Product Documentation](https://blog.promethium.ai/tag/product-documentation), [Data Catalog](https://blog.promethium.ai/tag/data-catalog) ## Related posts [![](https://blog.promethium.ai/hs-fs/hubfs/Imported_Blog_Media/file-Apr-26-2022-04-41-11-04-PM.png?height=200&name=file-Apr-26-2022-04-41-11-04-PM.png) ](https://blog.promethium.ai/post/forrester-includes-promethium-in-now-tech-machine-learning-data-catalogs) [Analyst Coverage](https://blog.promethium.ai/tag/analyst-coverage), [Forrester](https://blog.promethium.ai/tag/forrester), [Data Catalog](https://blog.promethium.ai/tag/data-catalog) ## [Forrester includes Promethium in Now Tech: Machine Learning Data Catalogs](https://blog.promethium.ai/post/forrester-includes-promethium-in-now-tech-machine-learning-data-catalogs) [Brett Arnott, VP of Marketing](https://blog.promethium.ai/author/brett-arnott-vp-of-marketing) Nov 10, 2020 12:00:00 AM Forrester's Michele Goetz has included Promethium in the Now Tech: Machine Learning Data Catalogs,... [ Read more ](https://blog.promethium.ai/post/forrester-includes-promethium-in-now-tech-machine-learning-data-catalogs) [![](https://blog.promethium.ai/hs-fs/hubfs/Imported_Blog_Media/file-Apr-26-2022-04-41-28-84-PM.png?height=200&name=file-Apr-26-2022-04-41-28-84-PM.png) ](https://blog.promethium.ai/post/how-to-make-your-data-catalog-project-a-success) [Metadata Catalog](https://blog.promethium.ai/tag/metadata-catalog), [Data Discovery](https://blog.promethium.ai/tag/data-discovery), [Data Catalog](https://blog.promethium.ai/tag/data-catalog) ## [How To Make Your Data Catalog Project a Success](https://blog.promethium.ai/post/how-to-make-your-data-catalog-project-a-success) [Brett Arnott, VP Marketing](https://blog.promethium.ai/author/brett-arnott-vp-marketing) Jul 27, 2021 12:00:00 AM Separate fact from fiction and learn what it takes to make a Data Catalog work for your business... [ Read more ](https://blog.promethium.ai/post/how-to-make-your-data-catalog-project-a-success) [![](https://blog.promethium.ai/hs-fs/hubfs/Imported_Blog_Media/file-Apr-26-2022-04-41-38-68-PM.png?height=200&name=file-Apr-26-2022-04-41-38-68-PM.png) ](https://blog.promethium.ai/post/5-reasons-why-you-need-more-than-a-data-catalog-for-fast-data-analytics) [Data Discovery](https://blog.promethium.ai/tag/data-discovery), [Data Catalog](https://blog.promethium.ai/tag/data-catalog) ## [5 Reasons Why You Need More Than a Data Catalog For Fast Data Analytics](https://blog.promethium.ai/post/5-reasons-why-you-need-more-than-a-data-catalog-for-fast-data-analytics) [Brett Arnott, VP Marketing](https://blog.promethium.ai/author/brett-arnott-vp-marketing) Sep 24, 2020 12:00:00 AM Ask many data teams about how they fulfill data requests for business analytics and they will say,... [ Read more ](https://blog.promethium.ai/post/5-reasons-why-you-need-more-than-a-data-catalog-for-fast-data-analytics)