Provides integration with a Microsoft SQL Database.
0.0.0.31 - Added connection test.
0.0.0.36 - Adjust templates.
0.0.0.39 - Fix attributes.
| Parameter |
Type |
Description |
Authentication Mode |
Dropdown |
Options: UserCredential, IntegratedSecurity, CertificateCredential |
Server |
String |
The SQL server address. |
Database |
String |
The SQL database to connect to. |
User ID |
String |
The User identifier used to connect to the SQL server. |
Password |
Masked |
The Password for the User Id. |
Trust Server Certificate |
Boolean |
Whether to trust the server certificate without validating it. |
Tenant ID |
String |
The Azure Tenant ID of the Service Principal for certificate authentication. |
Client ID |
String |
The Azure Client ID of the Service Principal for certificate authentication. |
Access Token |
Masked |
The Access token issued by Azure Active Directory using your certificate. |
Connection String Fragments |
Multiline String |
Additional connection string fragments to be added to the Connection. Each fragment should be on a separate line in 'keyword=value' format. |
Executes a query against a Microsoft SQL Server database and returns the results.
| Parameter |
Type |
Notes |
Connection |
Connection |
The connection profile for the Microsoft Sql Database. |
Query |
String |
The SQL query to execute. |
| Return |
Type |
Notes |
Items |
Array |
Output from Query. |
Upserts data to a Microsoft SQL Server database table.
| Parameter |
Type |
Notes |
Connection |
Connection |
The connection profile for the Microsoft Sql Database. |
Schema |
String |
The SQL schema for the table. |
TableName |
String |
The name of the table to upsert. |
KeyFields |
String |
The primary keys used to identity which records to update. |
Items |
Array |
The items to upsert. |
IdentityInsert |
Boolean |
True if the table has identity columns, false if not. Default is false. |
BatchSize |
Integer |
Number of rows to upsert per batch. Default is 100. |
| Return |
Type |
Notes |
RowsAffected |
Integer |
The amount of rows that were affected by the Upsert statement. |
- Certification authentication not implemented yet.
- Listen method not implemented yet.