Sends data to any ODBC-capable database such as MySQL, Microsoft Access, and Oracle databases.
0 |
Connection String |
Connection String |
The connection string to the database. |
1 |
Table Name |
Table Name |
The name of the table to update. |
2- >n |
USER |
USER |
ADDITIONAL CUSTOM ARGUMENTS |
None.
SUCCESS |
The data was successfully saved to the database. |
FAILURE |
The database or table could not be accessed. |
Unless you know how to format the connection string, the easiest thing to do is to change the entry method to Browse and then click the down-arrow button in the Value field. This opens the Windows ODBC data source picker, which guides you through selecting the proper database.
Unless you know how to format the table name string, the easiest thing to do is to change the entry method to Browse
(once the connection string has been specified) so that you can enter the value using a graphical user interface.
To add, remove, or edit any number of arguments, use the buttons listed under the comment area of the MP editor. When adding arguments, the Description should match the column name, and the data type should be compatible with the data type in the database (values will be converted to the proper type, if possible). To enter the values using a graphical interface, use the Add Using Column Picker button, but be aware that a valid connection string must be specified first before using this option.