---
title: "Creating Access Pattern For Table Integrations"
slug: "alternate-access-pattern-table-integrations"
description: "This document shows how to speed up data retrieval in large databases by using the Alternate Access Pattern. The Alternate Access Pattern acts how an index would and points to specific data in a table.  This can be setup by using the Add Access Pattern option, underneath the Manage Additional Access action for a database. "
updated: 2025-06-24T15:06:49Z
published: 2025-06-24T15:06:49Z
---

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

# Creating Access Pattern For Table Integrations

## Overview

**Access Patterns** can be used to speed up data retrieval by allowing more customized procedures. This is like using an index, where it points to data in a table and can be useful for databases with massive amounts of data to increase performance speed. Access Patterns****can be defined for any database integrated with Decisions. This tutorial demonstrates how to use****Access Patterns for a database table. An Access Pattern generates a step that can be used in the workflow to retrieve information from the integrated table based on input fields that are defined when the pattern was created.

Database and Table Integration

To use Access Patterns on an External database integration, review the following articles:

- [External Database Integration](/v9/docs/insert-update-delete-steps-integration-database)
- [Integrating With A Database Table](/v9/docs/integrate-with-database-table)

---

## Example

1. To create an Access Pattern, navigate to the **[Project Name] > Manage > Integrations** **> Databases**Folder and select a database connection.
2. Right-click a database table that has been integrated with and click **Manage Additional Access**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-03_16h42_25(1).png)
3. Clicking Manage Additional Access will open a new browser tab.
4. Click on ADD ACCESS PATTERN.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-23_16h17_15(1).png)
5. That Folder Action will display a Form that contains all the properties of that table.
6. Select the property to configure a pattern for. Multiple items can be selected. This will allow the Access Pattern step to have those columns as inputs to the step. 

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-23_16h18_23.png)
7. Navigate to a Designer Project Folder and open the Flow Designer.
8. In the steps toolbox, navigate to **I****ntegration > Database > [****TheIntegratedDatabase]*****>*****[****TheIntegratedTable]*****>*****[****TheNamedAccessPattern].**
9. Drag the step onto the canvas.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1750777456396.png)
10. The Created Access Pattern step has configurable options to allow users to customize what type of data to retrieve. Access Pattern OptionsFor more information on the Access Pattern settings review the article on [Configuration Folders](https://documentation.decisions.com/v9/docs/configuration-folder).

---

## Moving Access Patterns

Access Patterns that were created in any version prior to v9.5 will not export with a Project automatically if they are used as a dependency. The Access Pattern will need to be inside the Project being exported.

1. To do so, locate the Access Pattern in the correct folder. For older upgrades this may be in the System folder.
2. Right-click, select **Mange | More > Move To Project![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1734378687585.png)**
3. Pick the desired Project from the drop down list, then pick a folder to place the Access Pattern in.

---

For further information on Integrations, visit the [Decisions Forum](https://community.decisions.com/categories/Integrations).