MariaDB modules

In an Adobe 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 Adobe Workfront Fusion.

For information about modules, see Modules in Adobe Workfront Fusion.

Access requirements

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

Adobe Workfront plan*

Pro or higher

Adobe Workfront license*

Plan, Work

Adobe Workfront Fusion license**

Workfront Fusion for Work Automation and Integration

Product Your organization must purchase Adobe Workfront Fusion as well as Adobe 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 Adobe Workfront Fusion licenses, see Adobe 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:

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

On this page