Your orders, bookings and stock are already in a MySQL or MariaDB database. Bizomate reads and writes your tables from any workflow — values always sent as parameters, tables and columns chosen from your database's own lists — sends the results where they are needed, and starts a workflow when a new row appears. Every run leaves a record of what it ran and what came back.
| Label | Value |
|---|---|
| Plans | ◇ Paid plans — on Free you can build and test; publishing needs a paid plan |
| Connect | Server, database, user and password, encrypted with TLS |
| Starts runs | Every 5 or 15 minutes, as you choose |
| Kind | Connected app · Database |
Choose the table and a column that only grows, such as the id or a created time. Rows already in the table never start a run; up to 100 new rows start runs in one check, oldest first.
Name each value @like_this and give it under Parameters; values are never glued into the query. 1,000 rows by default, up to 10,000.
1,000 rows by default, up to 10,000, in the order you choose.
Its parameters are read from the procedure; one left empty is sent as NULL.
Yes. MariaDB uses the same MySQL connection and the same steps, and the connection test names the server as MariaDB. Some MariaDB servers have no TLS set up; for those, choose If the server offers it under Encryption.
MySQL is a premium connection. On any plan, Free included, you can add it and build and test workflows that use it; publishing one of those workflows needs a paid plan.
It watches a column that only grows — the id, or a created time — and each check takes the rows past the highest value seen. Rows already in the table when you publish never start a run, and a check that finds nothing starts no run.
No. In Run a query, each value is named @like_this and sent as a parameter, never glued into the query text. The other steps choose tables and columns from your database's own lists.
The connect article lists every address Bizomate connects from; allow all of them on the server's port. The MySQL user must also be allowed to sign in from outside the server, not only from localhost. A server on a private network or behind a VPN cannot be reached.
Each new row, posted to Slack and added to a sheet.
