{"id":5826,"date":"2026-06-16T06:29:50","date_gmt":"2026-06-16T06:29:50","guid":{"rendered":"https:\/\/aaxonix.com\/resources\/?post_type=glossary&#038;p=5826"},"modified":"2026-06-16T06:29:50","modified_gmt":"2026-06-16T06:29:50","slug":"datastore-zoho-catalyst","status":"publish","type":"glossary","link":"https:\/\/aaxonix.com\/resources\/glossary\/datastore-zoho-catalyst\/","title":{"rendered":"Datastore"},"content":{"rendered":"<style>\n.gt-body{font-family:'Poppins',sans-serif;color:#111;line-height:1.7;max-width:860px;margin:0 auto;padding:0 0 48px}\n.gt-type-badge{display:inline-block;font-size:11px;font-weight:600;letter-spacing:1.5px;text-transform:uppercase;color:#E8650A;border:1px solid rgba(232,101,10,.25);border-radius:20px;padding:3px 12px;margin-bottom:16px}\n.gt-def{font-size:17px;line-height:1.75;color:#1a1a1a;padding:20px 24px;background:#F7F4EF;border-left:3px solid #E8650A;border-radius:0 8px 8px 0;margin-bottom:28px}\n.gt-section{margin-bottom:28px}.gt-section h2{font-size:18px;font-weight:700;color:#0A1628;margin-bottom:12px;padding-bottom:8px;border-bottom:1px solid #DDD8CF}\n.gt-section p{font-size:15px;color:#333;margin-bottom:10px}\n.gt-example-box{background:#0A1628;color:#fff;border-radius:10px;padding:24px 28px;margin:28px 0}\n.gt-example-box h3{font-size:14px;font-weight:600;color:#E8650A;text-transform:uppercase;letter-spacing:1px;margin-bottom:10px}\n.gt-example-box p{font-size:14px;line-height:1.7;color:rgba(255,255,255,.85);margin:0}\n.gt-related-pills{display:flex;flex-wrap:wrap;gap:8px;margin:28px 0}\n.sp-content-link{display:inline-block;font-size:13px;font-weight:500;color:#2563EB;border:1px solid rgba(37,99,235,.25);border-radius:20px;padding:5px 14px;text-decoration:none}\n.gt-faq-item{border:1px solid #DDD8CF;border-radius:10px;padding:18px 20px;margin-bottom:12px}\n.gt-faq-item h3{font-size:15px;font-weight:600;color:#0A1628;margin-bottom:8px}\n.gt-faq-item p{font-size:14px;color:#555;margin:0;line-height:1.65}\n<\/style>\n<div class=\"gt-body\">\n  <span class=\"gt-type-badge\">Feature<\/span><\/p>\n<div class=\"gt-def\">The Catalyst Datastore is a fully managed SQL database built into the Zoho Catalyst platform, allowing developers to define tables, insert and query rows using standard SQL, and access data from serverless functions via the Catalyst SDK without configuring a separate database server.<\/div>\n<div class=\"gt-section\">\n<h2>How Datastore Works in Zoho Catalyst<\/h2>\n<p>You create tables in the Catalyst console or via the CLI, defining columns with types such as INTEGER, VARCHAR, BOOLEAN, and TIMESTAMP. The Datastore is accessible from within Catalyst functions using the SDK&#8217;s datastore methods, or via the Catalyst REST API for external access. Each Catalyst project gets its own isolated Datastore instance. Row-level operations like insert, update, delete, and query are all supported, and you can write multi-table JOIN queries using standard SQL syntax.<\/p>\n<\/p><\/div>\n<div class=\"gt-section\">\n<h2>When to Use Datastore<\/h2>\n<p>Use the Datastore for structured application data that requires relational queries, such as customer records, order lines, or configuration tables. It is the right choice when your Catalyst function needs to read or write data that has clear relationships between entities. Indian SMBs building custom Zoho extensions that need to persist data beyond what Zoho CRM custom fields support often use the Catalyst Datastore as their primary application database.<\/p>\n<\/p><\/div>\n<div class=\"gt-section\">\n<h2>Key Considerations<\/h2>\n<p>The Datastore is optimised for application-level read and write operations rather than large analytical queries over millions of rows. For bulk data analysis, export data to Zoho Analytics instead. Each table in the Datastore has a system-generated ROWID column as the primary key. Free plan projects have storage limits, so check the current plan limits in the Catalyst console before designing a data-heavy application.<\/p>\n<\/p><\/div>\n<div class=\"gt-example-box\">\n<h3>India Example<\/h3>\n<p>A Mumbai-based distributor builds a Catalyst application to track dealer credit limits across 200 dealers in Maharashtra. They create a Datastore table with columns for dealer ID, credit limit in INR, outstanding balance, and last updated timestamp. A Catalyst function queries this table whenever a new order is placed in Zoho CRM, checks the available credit, and either approves or holds the order automatically.<\/p>\n<\/p><\/div>\n<div class=\"gt-related-pills\">\n    <a href=\"\/resources\/glossary\/serverless-function-zoho-catalyst\/\" class=\"sp-content-link\">Serverless Function<\/a><br \/>\n    <a href=\"\/resources\/glossary\/nosql-table-zoho-catalyst\/\" class=\"sp-content-link\">NoSQL Table<\/a><br \/>\n    <a href=\"\/resources\/glossary\/catalyst-sdk-zoho-catalyst\/\" class=\"sp-content-link\">Catalyst SDK<\/a><br \/>\n    <a href=\"\/resources\/glossary\/cache-zoho-catalyst\/\" class=\"sp-content-link\">Cache<\/a>\n  <\/div>\n<div class=\"gt-faq-item\">\n<h3>Is the Catalyst Datastore the same as a NoSQL Table?<\/h3>\n<p>No. The Catalyst Datastore is a relational SQL database that supports structured schemas and JOIN queries. The NoSQL Table in Catalyst is a separate key-value store designed for simple, fast lookups without a fixed schema. Choose the Datastore when your data has relationships and needs SQL querying; choose NoSQL Tables for simpler key-value storage with flexible attributes.<\/p>\n<\/p><\/div>\n<div class=\"gt-faq-item\">\n<h3>Can external applications query the Catalyst Datastore directly?<\/h3>\n<p>Yes. The Catalyst REST API exposes Datastore operations so external applications can insert, update, query, and delete rows using authenticated HTTP requests. This allows third-party tools or existing Node.js backends to use the Catalyst Datastore as a shared data layer alongside Catalyst functions.<\/p>\n<\/p><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>The Datastore in Zoho Catalyst is a managed relational database service that lets developers create tables, run SQL queries, and store structured application data without provisioning a database server.<\/p>\n","protected":false},"template":"","meta":{"seo_title":"Datastore | Zoho Catalyst Glossary","seo_description":"The Datastore in Zoho Catalyst is a managed relational database service that lets developers create tables, run SQL queries, and store structured application data.","seo_keyword":"datastore zoho catalyst","seo_faqs":"[{\"q\": \"Is the Catalyst Datastore the same as a NoSQL Table?\", \"a\": \"No. The Catalyst Datastore is a relational SQL database that supports structured schemas and JOIN queries. The NoSQL Table in Catalyst is a separate key-value store designed for simple, fast lookups without a fixed schema. Choose the Datastore when your data has relationships and needs SQL querying; choose NoSQL Tables for simpler key-value storage with flexible attributes.\"}, {\"q\": \"Can external applications query the Catalyst Datastore directly?\", \"a\": \"Yes. The Catalyst REST API exposes Datastore operations so external applications can insert, update, query, and delete rows using authenticated HTTP requests. This allows third-party tools or existing Node.js backends to use the Catalyst Datastore as a shared data layer alongside Catalyst functions.\"}]","term_type":"Feature","glossary_related":"","glossary_links":""},"glossary_category":[1294],"class_list":["post-5826","glossary","type-glossary","status-publish","hentry","glossary_category-zoho-catalyst"],"_links":{"self":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary\/5826","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=5826"}],"wp:term":[{"taxonomy":"glossary_category","embeddable":true,"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary_category?post=5826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}