---
title: "Managing Database Connection Timeouts"
slug: "managing-database-connection-timeouts"
updated: 2025-06-23T20:41:32Z
published: 2025-06-23T20:41:32Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Managing Database Connection Timeouts

## Overview

Database Connections allow the integration of external systems and the utilization of new data. Timeouts are used alongside databases to prevent a requested operation from taking an entire database's bandwidth with one large query. If a query takes longer than the input amount of time allowed in the timeout, the operation is cut off, and an error is thrown. Timeouts can be configured on both the connection and step levels. This article will discuss how to create a **Database Connection** and how to use the **Run Query** step.

---

## Setting Up the New Connection

1. Navigate to a Designer Folder and select CREATE DATATYPES/INTEGRATION.
2. Click on **Database Integration**, and select **Add Query**. 

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-24_16h10_30.png)
3. On the next page, select **Create A New Connection**.
4. Give the new connection a **Name**.
5. Provide the **Server Name** and **Database Name.**
6. Uncheck the **Windows Authentication**box and enter the **User Name**and **Password**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-24_16h16_47.png)
7. Once finished, select TEST, then click NEXT.If the Test fails, double-check the information that was entered.
8. Provide a Name for the new query and a **Query**.
9. Select **Run Query** before clicking OK to finish creating the Integration.  
![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-08-06_14h49_11.png)

---

## Using the Run Query Step

1. Create a Flow. In the Flow Designer, navigate to **Integration > Database > [the new database]**.
2. Click and drag the **Run Query**step into the Flow. Connect the paths to the **Start Step** and **End Step**.
3. Select the Run Query step and select the **Specify Timeout** checkbox in the properties panel under ADVANCED.  
This allows a user to specify a different timeout when using the Run Query step to override the timeout used when creating the Database Integration. If the Specify Timeout option is not used or left blank, then the timeout specified in the Connection will be used instead. Query Timeout is in seconds.
4. Input a desired timeout for the step.
5. Under **Output Settings**in the Run Query step's properties panel, select **Data Rows**from the drop-down.
6. Then, under **Inputs**, set the mapping type to **Constant**and input "10". ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-23_16h38_06.png)
7. Select **Debug**from the Top Action Bar to debug the Flow.
8. After the Flow has run, select the Run Query step and click **Execution 1 > View Input/Output Data**. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-23_16h41_01.png)
9.