Executes SQL Queries against a MySQL database and returns the results as an XML Document. Can be run In-Cloud and requires no additional drivers.
Revision History
3.0.0.6 Initial Release, version matched with other SQL* Nodes
Properties
Connection
Type: Connection Input
The Connection Property
Server
Type: String
The name or IP address of the server hosting the Microsoft SQL Server instance. Specify a DropPoint if you need to access a SQL instance that is not Internet-exposed.
Database
Type: String
The name of the database to connect to.
Username
Type: String
The username to be used for the connection.
Password
Type: Password
The SQL password to be used for the connection.
Query
Type: Multiline Text Input
The SQL Query text.
ResultXml
Type: Xml Output
The dataset returned by executing the query in Query .
RowsAffected
Type: Int32 Output
Returns the number of rows returned by executing the SQL query.
Custom Inputs
Add Custom Input Properties to this Node to provide additional SQL Parameters that will be set at runtime. This technique should always be used to execute queries that require input data in order to avoid SQL injection attacks.
Remarks
Use this Connector to execute queries against a specific MySQL server instance.
Examples
See https://flowgear.me/s/5ekBfTu for an example.