MySQL

MySQL is a widely used open-source relational database management system (RDBMS). It stores and manages data in structured tables with rows and columns, supports the SQL language for querying and manipulating data, and is a common backend for web and enterprise applications. The Edge Gateway can connect to a MySQL database to read and write data as part of a Data Flow.

Connector type: Edge data connector — configured on the Edge Gateway to connect to a database (no physical device driver required).

Configuration

• Server: The host name of the SQL server.
• Port: The port the SQL server is running on. Typically 3306.
• Database: The database to connect to.
• User: The user to connect to the server as.
• Password: The password for the connecting user.
• Options: A JSON object for extra connection options.

Functions

Query

Executes SQL against a database.

• Query: The SQL to run against the database. The string can be parameterized with ?.
• Parameters: The parameter values to be merged into the SQL to execute (an array of values).

See Also

• Microsoft SQL
• Oracle SQL
• IBM DB2 SQL
• Edge Connections: Complete Industrial Integration Reference