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.
18.104.22.168 Initial Release, version matched with other SQL* Nodes
22.214.171.124 Added support for authenticating via SSH tunnel
Type: Connection Input
The Connection Property
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.
The name of the database to connect to.
The username to be used for the connection.
The SQL password to be used for the connection.
The name or IP address of the SSH server.
The port through which to connect to the SSH Server.
The port on which the MySQL Database is running.
The username with which to authenticate to the SSH Server.
The password with which to authenticate to the SSH Server. Provider either this or the SSH Key File.
The path to the Private Key File with which to authenticate to the SSH Server. Provider either this or the SSH Password. If using this, the node must be run on a drop point.
SSH KeyFile Pass Phrase
The pass phrase (if any) with which the SSH Key File has been locked.
Type: Multiline Text Input
The SQL Query text.
Type: Xml Output
The dataset returned by executing the query in
Type: Int32 Output
Returns the number of rows returned by executing the SQL query.
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.
Use this Connector to execute queries against a specific MySQL server instance.
See https://flowgear.me/s/5ekBfTu for an example.