ÃÛ¶¹ÊÓƵ

DocumentationWorkfrontWorkfront Guide

MariaDB modules

Last update: Thu Nov 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

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

If you need instructions on creating a scenario, see Create a scenario in ÃÛ¶¹ÊÓƵ Workfront Fusion.

For information about modules, see Modules in ÃÛ¶¹ÊÓƵ Workfront Fusion.

Access requirements

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

ÃÛ¶¹ÊÓƵ Workfront plan*
Pro or higher
ÃÛ¶¹ÊÓƵ Workfront license*
Plan, Work
ÃÛ¶¹ÊÓƵ Workfront Fusion license**

Current license requirement: No Workfront Fusion license requirement.

Or

Legacy license requirement: Workfront Fusion for Work Automation and Integration

Product

Current product requirement: If you have the Select or Prime ÃÛ¶¹ÊÓƵ Workfront plan, your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion as well as ÃÛ¶¹ÊÓƵ Workfront to use functionality described in this article. Workfront Fusion is included in the Ultimate Workfront plan.

Or

Legacy product requirement: Your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion as well as ÃÛ¶¹ÊÓƵ Workfront to use functionality described in this article.

To find out what plan, license type, or access you have, contact your Workfront administrator.

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 layout-auto html-authored no-header
    Connection name Enter a name for the new connection.
    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 Name Enter the name of the database you want to interact with.
    Username 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 in ÃÛ¶¹ÊÓƵ Workfront Fusion.

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
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43