SQL: ODBC Task
Product information "SQL: ODBC Task"
This Universal Extension provides the capability to integrate with ODBC compliant database, by running single or multiple SQL commands and retrieving the resulting data. While it is designed to work with any ODBC-compliant database, it is thoroughly tested against MySQL, MSSQL Server PostgreSQL, and Oracle databases. This integration allows the user to run an SQL Task on the Agent, as opposed to the native UAC SQL Task, which runs on the Controller.
Key Features:
- Flexibility in database connection definition supporting DSN, FILE DNS and Connection String.
- Rich metadata information.
- Capability to store SQL results in files (CSV or JSON format).
| Version: | 1.0.0 |
|---|---|
| Vendor: | Microsoft |
| Type: | Free |
| Compatibility : | UC/UA 7.1 and above |
| Support: | Stonebranch Certified |
Please visit this link to find key features, prerequisites, installation instructions, configuration instructions, and examples of how to use this integration.