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. 

   

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. 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". 
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.