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
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.
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.