Symptom
How to compare direct connection vs On Prem when connecting Process Intelligence to Data source
Resolution
To compare both options, here is a consolidated comparison of both approaches:
On-Premise Connector is required if the SQL Server is not externally accessible (e.g. on-prem or in a private network), and optional if it is externally accessible.
Pros
- Works in restricted environments
- Access to on-prem extractor logs
Cons
- Requires setup and ongoing maintenance
- Requires firewall/proxy configuration and possible local IT involvement
- Must be kept running, otherwise extractions will fail
Direct Connector is suitable when the SQL Server is accessible from SAP Signavio over the internet.
Pros
- No infrastructure or maintenance required
- Faster and simpler to set up
Cons
- Requires external accessibility
- Limited logging (primarily available via the UI)
To summarize above, if the system is not externally accessible, the on-prem extractor is required. If it is accessible, the choice depends on whether we prefer simplicity (direct connector) or ownership (on-prem extractor).
Keywords
KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Problem
SAP Knowledge Base Article - Public