You can use a MySQL client for creating and managing Maropost’s relational tables. In order to use a MySQL client for accessing Maropost’s relational tables, you are required to do a quick initial setup. The details required for the setup can be found on the Relational Tables page on the Settings.
Setting Up Relational Table Access
Follow the steps to set up the relational tables access:
Click your user name on the top-right corner of the application, and then from the drop-down menu, select Settings.
On the Settings page, click Relational Tables.
On the Relational Tables page, you can find the details needed to set up the access.
Restrictions When Using a MySQL Client
Remember the following restrictions when using a MySQL Client:
The relational tables using MySQL Client are not visible within the application. Therefore, you must create the tables and their relational links in the application if you intend to use the tables for segmentation or personalization.
When you add, update, or delete data in the relational tables using MySQL Client, the 'Table Field Updated' Journey trigger doesn't detect this event. Therefore, if you intend to use this trigger on a specific table, then you must use the application interface to add, update, and delete the data in that table.