🚀 Enhancement Request: Real-Time API Virtual Layer (Zero Data Copy)
🔍 Problem
Current API connectors (Salesforce, ServiceNow, Jira) require data ingestion into schemas, leading to:
- Stale dashboards (refresh delays)
- Duplicate data across systems
- Ongoing load/configuration overhead
💡 Proposed Solution
Introduce a Virtual API Layer that enables:
- ✅ Real-time access via APIs (no ingestion)
- ✅ Query-time data retrieval (virtual tables/views)
- ✅ Optional caching for performance
🎯 Business Value
- Real-time insights → no stale dashboards or AI outputs
- Zero data duplication → reduced storage & governance effort
- Faster time to value → no pipelines or load management
- Simpler architecture → less ETL, fewer moving parts
🧩 Use Cases
- Salesforce → live pipeline & deal insights
- ServiceNow → real-time incident/SLA visibility
- Jira → up-to-date sprint & backlog analytics
- Other APIs
⚖️ Why It Matters
Incorta already delivers near-real-time data updates, but this takes it further to true zero-copy, real-time access—aligned with modern data and AI architectures.