Managing Database Connection Timeouts

Overview 

Database Connections allow the integration of external systems and 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, then the operation is cut off and an error is thrown. Timeouts can be configured on both the connection and step level. 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. 

   

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.

   

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.

Using the Run Query Step

1. Navigate to a Designer Folder and click CREATE FLOW.
2. Give the Flow a Name and select CREATE.

   

3. In the Flow Designer, navigate to Integration > Database > [the new database].
4. Click and drag the Run Query step into the Flow.

   

5. Connect the paths to the Start Step and End Step.
6. Select the Run Query step and, in the properties panel under ADVANCED, select the Specify Timeout checkbox.
   Specify Timeout

   This allows a user to specify a different timeout when using the Run Query step to override the timeout that was 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.
7. Input a desired timeout for the step.

   

8. Under Output Settings in the Run Query step's properties panel, select Data Rows from the drop down.
9. Then, under Inputs, set the mapping type to Constant and input "10". 
10. Select Debug from the Top Action Bar to debug the Flow.

    

11. After the Flow has run, select the Run Query step and click Execution 1 > View Input/Output Data.