Choosing the Right COZYROC Event‑Driven SSIS Option: Cloud Webhooks, Hybrid Runtimes, or SSIS NoW
COZYROC offers three closely related options for event‑driven SSIS: COZYROC Cloud with managed runtime and inbound webhooks, COZYROC Cloud with on‑premises runtime and inbound webhooks, and SSIS NoW as a fully on‑premises, self‑hosted framework. All three let external events (like webhooks) trigger SSIS packages and pass data into them, but they differ in where execution happens, who operates the infrastructure, how SSIS+ is provided, and how much control and complexity you take on.
All three approaches are about event‑driven SSIS: an external event (like a webhook call) triggers an SSIS package instead of relying only on schedules. They all let you pass event data (body, headers, query string) into package parameters or variables, so the package can react to the incoming event. In every case you can also take advantage of COZYROC SSIS+ components within your packages, assuming SSIS+ is licensed or included for the runtime where those packages execute.
Conceptually, this is “SSIS as a service” with webhooks built‑in.
What it is: A cloud platform where you upload SSIS packages, configure inbound webhooks in a browser, and let COZYROC host the SSIS runtime for you.
Where it runs: Packages execute on COZYROC‑managed SSIS servers (managed runtime).
SSIS+ availability: COZYROC SSIS+ is pre‑installed and included in the managed runtime, so you can use SSIS+ components there without separate installation.
What you manage: Package logic, webhook configuration, and schedules; COZYROC handles servers, scaling, patching, and runtime setup.
Best fit:
You want the simplest path to event‑driven SSIS (no servers to spin up).
Your integrations are mostly cloud‑centric (SaaS → cloud DBs, etc.).
You want to monitor and manage everything from a web UI.
Conceptually, this is “cloud orchestration + on‑prem execution.”
What it is: You still configure webhooks and jobs in COZYROC Cloud, but package execution happens on your own SSIS servers via an installed agent.
Where it runs: Execution is on your infrastructure; Cloud just coordinates triggers, parameters, and monitoring.
SSIS+ availability: On the on‑prem runtime, COZYROC SSIS+ is not included by default; if you want to use SSIS+ components there, you install and license SSIS+ on your own servers.
What you manage: Your SSIS servers and SSIS+ installation; COZYROC Cloud provides the orchestration, UI, and webhook endpoints.
Best fit:
You need direct access to on‑prem data or systems (firewalled databases, legacy apps).
You like the Cloud UI and webhook model, but must keep execution under your control.
You want a hybrid model (cloud triggers + on‑prem data paths).
Conceptually, this is “build your own event‑driven SSIS platform” on‑premises.
What it is: A framework you install that adds event‑based execution to classic SSIS using a Web Bridge (for webhooks and other event sources), queues, and Runners that execute packages.
Where it runs: Everything is on your infrastructure—web endpoints, queuing, and SSIS execution.
SSIS+ availability: SSIS NoW is included as a capability with COZYROC SSIS+ Ultimate; you still deploy SSIS+ on the servers where Runners execute packages.
What you manage: All components: SQL Server (with Service Broker), Web Bridge, Runners, configuration files, and security.
Best fit:
You want full control on‑prem and cannot rely on any cloud service.
You need more advanced or varied event sources (webhooks, Salesforce Streaming, Kafka, DB triggers, custom bridges).
You’re comfortable owning the infrastructure and configuration and want a highly customizable event‑driven architecture.
| Question | Cloud Managed + Webhooks | Cloud On‑Prem Runtime + Webhooks | SSIS NoW |
|---|---|---|---|
| Prefer zero server management? | Strong yes (everything hosted). | Partial (Cloud hosts control plane only). | No (you host everything). |
| Need to keep execution strictly on‑prem? | Only via on‑prem runtime, not managed. | Yes, by design. | Yes, with maximum control. |
| SSIS+ components included on the runtime? | Yes, SSIS+ is built into the managed runtime. | No, you install and license SSIS+ on your servers if you want to use it. | SSIS NoW itself comes with SSIS+ Ultimate; you deploy SSIS+ on the Runner servers you control. |
| Want fastest time‑to‑value? | Best option (minutes). | Quick, after agent install. | Longer setup (infrastructure + config). |
| Need rich, hybrid cloud+on‑prem orchestration UI? | Yes, built‑in. | Yes, same UI. | No, you build/bolt on your own. |
| Need advanced event sources beyond webhooks? | Mostly webhooks. | Mostly webhooks. | Webhooks + Salesforce Streaming + Kafka + custom. |
| Need strict, customizable auth and security patterns on endpoints? | Standard cloud security model. | Standard cloud + your network controls. | Highly customizable auth (API key, Identity, OAuth2-like, custom handlers). |
In short: choose Cloud managed when you want the easiest, fully hosted webhook‑to‑SSIS experience with SSIS+ already available in the runtime; choose Cloud on‑prem runtime when you like that model but need execution on your own SSIS+‑enabled servers; and choose SSIS NoW when you need a fully on‑prem, highly controllable event‑driven SSIS platform built on your own infrastructure.