Overview

Intuiface does natively integrate with MySQL databases but does have the ability to communicate with virtually any REST-based Web API. As a result, if the MySQL database can be wrapped in a REST-based web service, Intuiface can read from and write to that database.

Before proceeding, be sure to review Interface Asset general concepts.

NOTE: You must use Composer Premier or Enterprise to incorporate custom-built interface assets (IAs). Composer Free and Essential can open, run and edit experiences containing custom-built interface assets but cannot save those edits unless the custom interface assets are removed. The ability to add custom IAs and save changes to those experiences is a feature exclusive to Premier and Enterprise license levels.

What you need

• A REST-based web service wrapper for your MySQL database

There are several different existing solutions for exposing MySQL databases via REST-based web services. Here are three examples:

1. MySQL HTTP Plugin
2. Dream Factory [for "how-to" details you can read the following Blog Article]
3. GitHub

• An Intuiface REST Interface Asset

Interface Assets using the REST protocol can be created in Intuiface without coding using API Explorer. With API Explorer, you can easily create an integration with the REST-based web service you've applied to your MySQL database.

For a step-by-step description of how to create your own REST-based Interface Asset using API Explorer, please go through this Intuiface Academy course.

Linking your database with Intuiface

Implement a web service back-end on the top of your MySQL database that will be available for remote devices. For example, the latest versions of MySQL (5.7+) include an HTTP plugin that exposes database entries as REST Web Services. However, any of the options listed above - or others not listed - will do. Once the web service is implemented, a simple REST Interface Asset created using API Explorer will connect running experiences to your database.