---
title: Connecting to a New Database
slug: kronpam-how-to-guides/connecting-to-a-new-database
description: Learn how to connect a database to Superset reporting module with this step-by-step guide. Configure the database connection, test and authenticate it, and save the configuration effortlessly.
docTags: 
createdAt: 2022-08-18T14:06:17.000Z
---

This is the first step of creating your own report with the Reporting module.

We assume you already have a database configured and can connect to it from the instance on which you’re running Superset. If you’re just testing Superset and want to explore sample data, you can load some sample PostgreSQL datasets into a fresh DB or configure the example weather data we use here.

To connect to a database:

1. Under the **Sources** menu, select the **Databases** option.


::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/PEA4M7xxQSQzWdGUFj3Nl_image.png" size="30" width="303" height="167" position="center" showCaption="false"}

- On the resulting page, click on the green plus + sign near the top right.

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/Uj1ZrulQBtjKNsmz7QkHU_image.png" size="28" width="284" height="205" position="center" showCaption="false"}

- You can configure several advanced options on this page, but for this walkthrough, you’ll only need to do two things:

 Name your database connection.

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/vn48XEaRhhBNRkuz6YVWV_image.png" size="32" width="469" height="92" position="center" showCaption="false"}

 Provide the **SQLAlchemy Connection URI** and test the connection.

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/mJzO1JZADw7Kf3wfpTnaQ_image.png" size="78" width="897" height="223" position="center" showCaption="false"}

:::hint{type="info"}
The example URI in the figure above is the connection string for our test weather database. As noted in the text below the URI field, you should refer to the SQLAlchemy documentation on creating new connection URIs for your target database.
:::

- Click the **Test Connection** button to confirm things work end to end. Once Superset can successfully connect and authenticate, you should see a popup like this:

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/GFjJiTWUmeUzYn737bupF_image.png" size="58" width="541" height="239" position="center" showCaption="false"}

Moreover, you should also see the list of tables Superset can read from the schema you’re connected to at the bottom of the page:

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/9hXH0141o_yEHX-zIQRSP_image.png" size="74" width="938" height="193" position="center" showCaption="false"}

- If the connection looks good, save the configuration by clicking the **Save** button at the bottom of the page.

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/SlGQ6VJQpEvY6Rnunbwo6_image.png" size="22" width="178" height="81" position="center" showCaption="false"}