Filter
Free
Microsoft SQL: Schedule SSRS
This integration can complete various administrative tasks, including publishing reports and moving reports from one server to another server. It's based on the SQL Server Reporting Services 'rs.exe' command-line utility, which can perform many scripted operations related to SQL Server Reporting Services (SSRS). The rs.exe utility requires an input file to tell rs.exe what to do.The list of actual tasks that can be performed includes among others:
Deploying / Publishing reports
Moving reports
Exporting reports to a file
Adjust security
Cancel a running job
Configure SSRS system properties
New
Free
Microsoft SQL: SSIS Package Execution
SQL Server Integration Services (SSIS) is a platform for building data integrations and data transformation solutions.This Universal Extension task interactively allows users to list and select the SSIS Folder, Project, Environment Reference, and SSIS Package while creating the job. Furthermore, it can trigger the SSIS package execution in the Microsoft SQL server, monitor the SSIS Package execution, and fetch SSIS logs to Universal Controller when the SSIS package execution has been completed.Key Features:This Universal Extension provides the following key features:Dynamic Choice Fields to select the SSIS Folder/Project/Package/Environment Reference ID.Launch SSIS Package execution.
Monitor SSIS Package execution.Fetch SSIS Package execution logs.SSIS Execution ID and Execution status captured for every execution in the Task Instance.Connection to MS SQL Server is done via the Python PYMSSQL module.Supports Windows and Linux Universal Agents in order to connect to the MSSQL server.What's in V1.0.4This new release involves a minor bug fix.
Free
Video
SQL: Execute Scripts and Functions
This integration allows users to execute SQL scripts and functions against a MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and SAP HANA database. It uses an agentless connection via ODBC towards SQL Server, MySQL, and PostgreSQL, and the Oracle basic instant client to connect to an Oracle database.
Key Features:
Supports execution of SQL scripts for Oracle, MySQL, PostgreSQL, Microsoft SQL Server, and SAP HANA:
For SQL Server, MySQL, and PostgreSQL: all connections are agentless via ODBC.For SQL Server: Windows Authentication and SQL Server Authentication is supported.
For SAP HANA: database connections are performed agentless using the SAP HANA client for Python.
For Oracle: the execution of SQL scripts and Oracle PLSQL blocks are supported. Oracle connections are performed agentless using the Oracle basic instant client.
Supports Universal Agent for both Linux/Unix and Windows.
Select different log-levels, e.g., info and debug.
Decide if the SQL-output is provided in the standard out or not.
All passwords are encrypted using Stonebranch Universal Controller credentials.