MariaDB modules

Last update: Tue Dec 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

Topics:
Workfront Fusion

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.

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

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**

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 Adobe Workfront Plan, your organization must purchase Adobe Workfront Fusion as well as Adobe 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 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.

In any MariaDB module, click Add next to the Connection field.
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.
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