# Hands-On Tutorial: Configure the Connection Between Dataiku and PostgreSQL[¶](https://knowledge.dataiku.com/latest/courses/sql-integration/connect-postgresql/configure-connection.html#hands-on-tutorial-configure-the-connection-between-dataiku-and-postgresql "Permalink to this headline")

Tip

This article assumes you have an available local PostgreSQL connection as explained in the prerequisites for SQL integration.

To complete this tutorial, you need to establish a connection between Dataiku and your PostgreSQL database using the instructions given in the product documentation. However, note that *only* the **Dataiku Administrator** has permission to do this.

## Steps[¶](https://knowledge.dataiku.com/latest/courses/sql-integration/connect-postgresql/configure-connection.html#steps "Permalink to this headline")

Log in as the Dataiku Administrator. Next, from the Applications menu in the top navigation bar, choose **Administration**.

Navigate to the **Connections** tab and select **New Connection > PostgreSQL**.

Finally, fill in the information required for the connection. Don’t forget to give a name to your connection!

Note

You cannot change the connection name afterward.

You can then test and create your PostgreSQL connection.

## Import Datasets into Dataiku[¶](https://knowledge.dataiku.com/latest/courses/sql-integration/connect-postgresql/configure-connection.html#import-datasets-into-dataiku "Permalink to this headline")

After creating your connection, if you are connecting to a pre-existing PostgreSQL database, you can create a Dataiku dataset for every table in the database.

* Click **Import tables to datasets**.

* Select the tables you want to import.

* Click **Import tables**.

* Select the project in which the datasets associated with these tables should appear.
