{"id":4361,"date":"2026-05-29T21:44:53","date_gmt":"2026-05-29T21:44:53","guid":{"rendered":"https:\/\/aaxonix.com\/resources\/?post_type=glossary&#038;p=4361"},"modified":"2026-05-29T21:44:53","modified_gmt":"2026-05-29T21:44:53","slug":"live-connect-zoho-analytics","status":"publish","type":"glossary","link":"https:\/\/aaxonix.com\/resources\/glossary\/live-connect-zoho-analytics\/","title":{"rendered":"Live Connect"},"content":{"rendered":"<style>\n.gt-body{font-family:'Poppins',sans-serif;color:#111;line-height:1.75}\n.gt-def{border-left:4px solid #E8650A;padding:16px 20px;background:#fff8f4;border-radius:0 8px 8px 0;margin:0 0 32px;font-size:1.05rem}\n.gt-section{margin:0 0 36px}.gt-section h2{font-family:'Fraunces',serif;color:#0A1628;font-size:1.5rem;margin:0 0 12px}\n.gt-example-box{background:#f0f4ff;border-radius:10px;padding:20px 24px;margin:0 0 32px}.gt-example-box strong{color:#2563EB}\n.gt-related-pills{display:flex;flex-wrap:wrap;gap:10px;margin:0 0 32px}\n.gt-related-pill{background:#f7f4ef;border:1px solid #ddd8cf;border-radius:20px;padding:6px 16px;font-size:.875rem;color:#0A1628;text-decoration:none}\n.gt-faq-item{border:1px solid #ddd8cf;border-radius:10px;padding:16px 20px;margin:0 0 12px}\n.gt-type-badge{display:inline-block;background:#0A1628;color:#fff;font-size:.75rem;padding:3px 10px;border-radius:20px;margin:0 0 24px;font-family:'DM Mono',monospace}\n<\/style>\n<div class=\"gt-body\">\n<span class=\"gt-type-badge\">Technical Term<\/span><\/p>\n<div class=\"gt-def\">Live Connect requires a direct network path from Zoho Analytics to the source database. For on-premise databases, Zoho provides a Zoho Analytics On-Premise Gateway to bridge the connection securely without opening inbound firewall ports.<\/div>\n<div class=\"gt-section\">\n<h2>How Live Connect Works in Zoho Analytics<\/h2>\n<p>Live Connect in Zoho Analytics is a connection mode that queries data directly from the source database or data warehouse in real time without importing or storing data in Zoho Analytics, enabling always-current reporting on live production data.<\/p>\n<\/div>\n<div class=\"gt-section\">\n<h2>When to Use Live Connect<\/h2>\n<p>Use Live Connect when your reporting requirements go beyond what built-in defaults provide. This feature is most valuable for organisations that have moved past basic data viewing and need precise control over how their data is organised, queried, or presented. Teams working with multiple data sources, varied user groups, or complex business logic will find this capability central to their Zoho Analytics setup.<\/p>\n<\/div>\n<div class=\"gt-section\">\n<h2>Key Considerations for Live Connect<\/h2>\n<p>Before configuring Live Connect, ensure that the underlying data tables are clean and consistently structured. Irregular naming conventions, mixed data types in a single column, or missing values can produce unexpected results. For shared environments, coordinate with your Workspace Administrator before making changes that affect reports used by other team members. Testing on a duplicate report before applying changes to production dashboards is a sound practice.<\/p>\n<\/div>\n<div class=\"gt-example-box\"><strong>India Example:<\/strong> A hospital in India uses Live Connect to Zoho Analytics against their patient management database. Every report shows live bed occupancy, OT schedules, and pharmacy stock levels, making it suitable for real-time operations monitoring where stale data would be misleading.<\/div>\n<div class=\"gt-related-pills\">\n<a href=\"https:\/\/aaxonix.com\/resources\/glossary\/scheduled-sync-zoho-analytics\/\" class=\"gt-related-pill sp-content-link\">Scheduled Sync<\/a><br \/>\n<a href=\"https:\/\/aaxonix.com\/resources\/glossary\/connector-zoho-analytics\/\" class=\"gt-related-pill sp-content-link\">Connector (Analytics)<\/a><br \/>\n<a href=\"https:\/\/aaxonix.com\/resources\/glossary\/database-connector-zoho-analytics\/\" class=\"gt-related-pill sp-content-link\">Database Connector<\/a>\n<\/div>\n<div class=\"gt-faq-item\"><strong>What is Live Connect in Zoho Analytics?<\/strong><\/p>\n<p>Live Connect allows Zoho Analytics to query your source database (MySQL, SQL Server, PostgreSQL, Amazon Redshift, etc.) directly in real time. Instead of importing and storing data in Zoho Analytics, each report query is executed against the live source, ensuring data is always current.<\/p>\n<\/div>\n<div class=\"gt-faq-item\"><strong>When should I use Live Connect instead of scheduled import in Zoho Analytics?<\/strong><\/p>\n<p>Use Live Connect when data currency is critical and even a one-hour lag is unacceptable, when your dataset is too large to import and store in Zoho Analytics, or when your organisation&#8217;s data governance policy requires data to remain in its original system. Live Connect has higher query latency than imported data.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Live Connect in Zoho Analytics is a connection mode that queries data directly from the source database or data warehouse in real time without importing or<\/p>\n","protected":false},"template":"","meta":{"seo_title":"Live Connect | Zoho Analytics Glossary","seo_description":"Live Connect in Zoho Analytics is a connection mode that queries data directly from the source database or data warehouse in real time without importing or","seo_keyword":"live connect zoho analytics","seo_faqs":"[{\"q\": \"What is Live Connect in Zoho Analytics?\", \"a\": \"Live Connect allows Zoho Analytics to query your source database (MySQL, SQL Server, PostgreSQL, Amazon Redshift, etc.) directly in real time. Instead of importing and storing data in Zoho Analytics, each report query is executed against the live source, ensuring data is always current.\"}, {\"q\": \"When should I use Live Connect instead of scheduled import in Zoho Analytics?\", \"a\": \"Use Live Connect when data currency is critical and even a one-hour lag is unacceptable, when your dataset is too large to import and store in Zoho Analytics, or when your organisation's data governance policy requires data to remain in its original system. Live Connect has higher query latency than imported data.\"}]","term_type":"Technical","glossary_related":"","glossary_links":""},"glossary_category":[1248],"class_list":["post-4361","glossary","type-glossary","status-publish","hentry","glossary_category-zoho-analytics"],"_links":{"self":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary\/4361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary"}],"about":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/types\/glossary"}],"wp:attachment":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/media?parent=4361"}],"wp:term":[{"taxonomy":"glossary_category","embeddable":true,"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary_category?post=4361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}