ÃÛ¶¹ÊÓƵ

DocumentationWorkfrontÃÛ¶¹ÊÓƵ Workfront Fusion

MariaDB modules

Last update: Fri Apr 18 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

In an ÃÛ¶¹ÊÓƵ Workfront Fusion scenario, you can automate workflows that use MariaDB, as well as connect it to multiple third-party applications and services.

For instructions on creating a scenario, see the articles under Create scenarios: article index.

For information about modules, see the articles under Modules: article index.

Access requirements

Expand to view access requirements for the functionality in this article.

You must have the following access to use the functionality in this article:

table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
ÃÛ¶¹ÊÓƵ Workfront package Any
ÃÛ¶¹ÊÓƵ Workfront license

New: Standard

Or

Current: Work or higher
ÃÛ¶¹ÊÓƵ Workfront Fusion license**

Current: No Workfront Fusion license requirement

Or

Legacy: Workfront Fusion for Work Automation and Integration
Product

New:

  • Select or Prime Workfront package: Your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion.
  • Ultimate Workfront package: Workfront Fusion is included.

Or

Current: Your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion.

For more detail about the information in this table, see Access requirements in documentation.

For information on ÃÛ¶¹ÊÓƵ Workfront Fusion licenses, see ÃÛ¶¹ÊÓƵ Workfront Fusion licenses.

Prerequisites

To use MariaDB modules, you must have a MariaDB account.

Connect MariaDB to Workfront Fusion

You can create a connection to your MariaDB account directly from inside a MariaDB module.

  1. In any MariaDB module, click Add next to the Connection field.

  2. Configure the following fields:

    table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 layout-auto html-authored no-header
    Connection name Enter a name for the new connection.
    Environment Select whether this connection is for a production or non-production environment.
    Type Select whether you are connecting to a service account or a personal account.
    Host

    Enter the IP address or host name of your database instance. This host must be accessible from outside your network.

    Example: mariadb.hwoh2j5h.us-east-1.rds.amazon.com
    Port The default port is 3306. If you are using a non-standard port, set this number to your port.
    Database Enter the name of the database you want to interact with.
    User Enter your username.
    Password Enter your password.

  3. Click Continue to create the connection and go back to the module.

MariaDB Modules and their fields

When you configure MariaDB modules, Workfront Fusion displays the fields listed below. Along with these, additional MariaDB fields might display, depending on factors such as your access level in the app or service. A bolded title in a module indicates a required field.

If you see the map button above a field or function, you can use it to set variables and functions for that field. For more information, see Map information from one module to another.

Map toggle

Execute a query (advanced)

This action module retrieves information from your database, based on a query you supply.

Connection
For instructions about connecting your MariaDB account to Workfront Fusion, see Connect MariaDB to Workfront Fusion in this article.
Query

Enter the SQL query that you want the module to use to retrieve data.

Important: Variables used in the query are not sanitized. Make sure you sanitize variables properly to prevent SQL injection.

Select rows from a table (advanced)

This module reads record from your database.

Connection
For instructions about connecting your MariaDB account to Workfront Fusion, see Connect MariaDB to Workfront Fusion in this article.
Table
Select the table that contains the records you want to read.
Filter

Set up the filter by which you want to select rows

  • Select the field that you want to search by

  • Select the operator that you want to use for your search

  • Enter or map the value that you want to search for.

Sort
For each level that you want your results sorted by, click Add item, then select the field that you want to sort the results by and whether you want to sort ascending or descending
Limit
Enter or map the maximum number of records you want the module to return during each scenario execution cycle.
recommendation-more-help
7e1891ad-4d59-4355-88ab-a2e62ed7d1a3