--- title: Easier Data Marts with DreamFactory Data Mesh description: Data Mesh by DreamFactory offers developers a fast and sane solution for combining data in multiple databases. Build a data mart in minutes, not months. image: https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/Understanding-SOAP-Security-1.png --- [![DreamFactory logo](https://cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/68d51994d3678214b54acb60_dreamfactory-navbar-logo.svg)](https://www.dreamfactory.com/) Products & Services [AI Data Gateway](https://www.dreamfactory.com/ai-data-gateway/overview) [Overview Why DreamFactory exists](https://www.dreamfactory.com/ai-data-gateway/overview) [Data Gov, Comp, Security Policy enforcement at the API layer](https://www.dreamfactory.com/ai-data-gateway/ai-data-governance) [Standard API Layer One contract for every backend](https://www.dreamfactory.com/ai-data-gateway/standard-api-layer) [API Gateway Functionality Routing, auth, rate limits, observability](https://www.dreamfactory.com/ai-data-gateway/api-gateway-functionality) [Deployment & Integration Self-hosted, cloud, hybrid](https://www.dreamfactory.com/ai-data-gateway/on-premise-deployment-and-integration) [Developer Productivity Auto-generated, never hand-coded](https://www.dreamfactory.com/ai-data-gateway/ai-development-accelerated) [AI App Architectures Patterns for RAG, agents, MCP](https://www.dreamfactory.com/ai-data-gateway/enterprise-ai-architectures) AI Data Models [AIOpenAI](https://www.dreamfactory.com/use-cases/openai) [GGoogle Gemini](https://www.dreamfactory.com/use-cases/google-gemini) [CAnthropic Claude](https://www.dreamfactory.com/use-cases/anthropic-claude-landing) [LMeta Llama](https://www.dreamfactory.com/use-cases/meta-llama) [MMistral AI](https://www.dreamfactory.com/use-cases/mistral) [CoCohere](https://www.dreamfactory.com/use-cases/cohere) Services and support [Quickstart Service Packages Expert-led Quickstarts to production](https://www.dreamfactory.com/services-and-support/quickstart-services-packages) API Management [Generate & Manage REST APIs From any database, in seconds](https://www.dreamfactory.com/api-management/generate-rest-apis) [Features Security, scripting, self-hosted & more](https://www.dreamfactory.com/api-management/features) [API Generation The complete guide to auto-generated APIs](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) [API Management Concepts, tools, and best practises](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools?_gl=1*jl0njh*_gcl_au*MjQzMjgwMTc3LjE3ODIzMjI3MzY) Use Cases AI Use Cases [AI Data Access Secure, governed reads for your LLMs](https://www.dreamfactory.com/use-cases/ai-data-access) [MCP Server Drop-in Model Context Protocol](https://www.dreamfactory.com/use-cases/mcp-server) [Legacy Modernization Wrap mainframes with REST](https://www.dreamfactory.com/use-cases/legacy-modernization) [Data Governance Audit every call, enforce every policy](https://www.dreamfactory.com/use-cases/data-governance) [Customer Case Studies](https://www.dreamfactory.com/case-studies) [Energy Modernization](https://www.dreamfactory.com/case-studies/energy-snowflake-modernization) [Government Modernization](https://www.dreamfactory.com/case-studies/government-mainframe-oracle-modernization) [Government Business Intelligence](https://www.dreamfactory.com/case-studies/government-sql-server-bi-analyst-queries) [Manufacturing Modernization](https://www.dreamfactory.com/case-studies/steel-manufacturing-sap-erp-modernization) [Financial Services Investor Portal](https://www.dreamfactory.com/case-studies/financial-services-sql-server-investor-portal) [Non-Profit Partner Data Sharing](https://www.dreamfactory.com/case-studies/non-profit-sql-server-partner-data-sharing) [Professional Services Exec Dashboards](https://www.dreamfactory.com/case-studies/professional-services-erp-dashboards) [Education HR and External Data Sharing](https://www.dreamfactory.com/case-studies/education-student-hr-sql-server-mysql-external-data-sharing) Industries Industries #### [Healthcare HIPAA-grade APIs across EHR, claims, and labs.](https://www.dreamfactory.com/use-cases/healthcare) #### [Financial Services Portfolios, partners, and portals on one layer.](https://www.dreamfactory.com/use-cases/financial-services) #### [Government Modernize mainframes without re-platforming.](https://www.dreamfactory.com/use-cases/government) #### [Manufacturing SAP, MES, and shop-floor data, governed.](https://www.dreamfactory.com/use-cases/manufacturing) #### [Spotlight How enterprises run on DreamFactory From healthcare to energy to finance — governance baked into every endpoint. Browse case studies →](https://www.dreamfactory.com/case-studies) Connectors SQL Database [SQL SQL Server](https://www.dreamfactory.com/connectors/sql-server) [OR Oracle](https://www.dreamfactory.com/connectors/oracle) [PG PostgreSQL](https://www.dreamfactory.com/connectors/postgresql) [My MySQL](https://www.dreamfactory.com/connectors/mysql) NoSQL & Docs [Dy DynamoDB](https://www.dreamfactory.com/connectors/dynamodb) [Do DocumentDB](https://www.dreamfactory.com/connectors/azure-documentdb) [Mo MongoDB](https://www.dreamfactory.com/connectors/mongodb) [Cb CouchDB](https://www.dreamfactory.com/connectors/couch-db) Cloud Warehouses [S3 S3](https://www.dreamfactory.com/connectors/amazon-s3) [Ab Azureblob](https://www.dreamfactory.com/connectors/azure-blob) [FS FTP/SFTP](https://www.dreamfactory.com/connectors/ftp-sftp) [LS Local Storage](https://www.dreamfactory.com/connectors/local-storage) C & SaaS [Sf Salesforce](https://www.dreamfactory.com/connectors/salesforce) [API REST / SOAP](https://www.dreamfactory.com/connectors/soap-to-rest) [See all 30+ connectors](https://www.dreamfactory.com/connectors) [Blog](https://blog.dreamfactory.com/) [FREE 30 Minute Demo](https://www.dreamfactory.com/demo) [![DreamFactory logo](https://cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/68d51994d3678214b54acb60_dreamfactory-navbar-logo.svg)](https://www.dreamfactory.com/) ![hamburger](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/menu-hamburger.svg) ![close](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/close-menu.svg) Back to main menu Products & Services Use Cases Industries Connectors [Blog](https://blog.dreamfactory.com/) [FREE 30 Minute Demo](https://www.dreamfactory.com/demo) [AI Data Gateway](https://www.dreamfactory.com/ai-data-gateway/overview) [Overview Why DreamFactory exists](https://www.dreamfactory.com/ai-data-gateway/overview) [Data Gov, Comp, Security Policy enforcement at the API layer](https://www.dreamfactory.com/ai-data-gateway/ai-data-governance) [Standard API Layer One contract for every backend](https://www.dreamfactory.com/ai-data-gateway/standard-api-layer) [API Gateway Functionality Routing, auth, rate limits, observability](https://www.dreamfactory.com/ai-data-gateway/api-gateway-functionality) [Deployment & Integration Self-hosted, cloud, hybrid](https://www.dreamfactory.com/ai-data-gateway/on-premise-deployment-and-integration) [Developer Productivity Auto-generated, never hand-coded](https://www.dreamfactory.com/ai-data-gateway/ai-development-accelerated) [AI App Architectures Patterns for RAG, agents, MCP](https://www.dreamfactory.com/ai-data-gateway/enterprise-ai-architectures) AI Data Models [AIOpenAI](https://www.dreamfactory.com/use-cases/openai) [GGoogle Gemini](https://www.dreamfactory.com/use-cases/google-gemini) [CAnthropic Claude](https://www.dreamfactory.com/use-cases/anthropic-claude-landing) [LMeta Llama](https://www.dreamfactory.com/use-cases/meta-llama) [MMistral AI](https://www.dreamfactory.com/use-cases/mistral) [CoCohere](https://www.dreamfactory.com/use-cases/cohere) Services and support [Quickstart Service Packages Expert-led Quickstarts to production](https://www.dreamfactory.com/services-and-support/quickstart-services-packages) AI Data Models [Generate & Manage REST APIs From any database, in seconds](https://www.dreamfactory.com/api-management/generate-rest-apis) [Features Security, scripting, self-hosted & more](https://www.dreamfactory.com/api-management/features) [API Generation The complete guide to auto-generated APIs](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) [API Management Concepts, tools, and best practises](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools?_gl=1*jl0njh*_gcl_au*MjQzMjgwMTc3LjE3ODIzMjI3MzY) AI Use Cases [AI Data Access Secure, governed reads for your LLMs](https://www.dreamfactory.com/use-cases/ai-data-access) [MCP Server Drop-in Model Context Protocol](https://www.dreamfactory.com/use-cases/mcp-server) [Legacy Modernization Wrap mainframes with REST](https://www.dreamfactory.com/use-cases/legacy-modernization) [Data Governance Audit every call, enforce every policy](https://www.dreamfactory.com/use-cases/data-governance) [Customer Case Studies](https://www.dreamfactory.com/case-studies) [Energy Modernization](https://www.dreamfactory.com/case-studies/energy-snowflake-modernization) [Government Modernization](https://www.dreamfactory.com/case-studies/government-mainframe-oracle-modernization) [Government Business Intelligence](https://www.dreamfactory.com/case-studies/government-sql-server-bi-analyst-queries) [Manufacturing Modernization](https://www.dreamfactory.com/case-studies/steel-manufacturing-sap-erp-modernization) [Financial Services Investor Portal](https://www.dreamfactory.com/case-studies/financial-services-sql-server-investor-portal) [Non-Profit Partner Data Sharing](https://www.dreamfactory.com/case-studies/non-profit-sql-server-partner-data-sharing) [Professional Services Exec Dashboards](https://www.dreamfactory.com/case-studies/professional-services-erp-dashboards) [Education HR and External Data Sharing](https://www.dreamfactory.com/case-studies/education-student-hr-sql-server-mysql-external-data-sharing) Industries #### [Healthcare HIPAA-grade APIs across EHR, claims, and labs.](https://www.dreamfactory.com/use-cases/healthcare) #### [Financial Services Portfolios, partners, and portals on one layer.](https://www.dreamfactory.com/use-cases/financial-services) #### [Government Modernize mainframes without re-platforming.](https://www.dreamfactory.com/use-cases/government) #### [Manufacturing SAP, MES, and shop-floor data, governed.](https://www.dreamfactory.com/use-cases/manufacturing) SQL Database [SQL SQL Server](https://www.dreamfactory.com/connectors/sql-server) [OR Oracle](https://www.dreamfactory.com/connectors/oracle) [PG PostgreSQL](https://www.dreamfactory.com/connectors/postgresql) [My MySQL](https://www.dreamfactory.com/connectors/mysql) NoSQL & Docs [Dy DynamoDB](https://www.dreamfactory.com/connectors/dynamodb) [Do DocumentDB](https://www.dreamfactory.com/connectors/azure-documentdb) [Mo MongoDB](https://www.dreamfactory.com/connectors/mongodb) [Cb CouchDB](https://www.dreamfactory.com/connectors/couch-db) Cloud Warehouses [S3 S3](https://www.dreamfactory.com/connectors/amazon-s3) [Ab Azureblob](https://www.dreamfactory.com/connectors/azure-blob) [FS FTP/SFTP](https://www.dreamfactory.com/connectors/ftp-sftp) [LS Local Storage](https://www.dreamfactory.com/connectors/local-storage) C & SaaS [Sf Salesforce](https://www.dreamfactory.com/connectors/salesforce) [API REST / SOAP](https://www.dreamfactory.com/connectors/soap-to-rest) [See all 30+ connectors](https://www.dreamfactory.com/connectors) [![back arrow](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/orange-arrow.svg) Blog](https://blog.dreamfactory.com/) # Easier Data Marts with DreamFactory Data Mesh by Jason Gilmore ![calendar icon](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/calendar-icon.svg) January 14, 2026 Table of contents RECOMMENDED ARTICLES - [A Complete Guide to API Generation](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) - [10 Best API Management Tools](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools) - [Creating a Microsoft SQL Server API in Less Than 5 minutes with DreamFactory](https://blog.dreamfactory.com/creating-a-microsoft-sql-server-api-in-less-than-5-minutes-with-dreamfactory) - [Hasura vs. DreamFactory: A Comprehensive Comparison](https://blog.dreamfactory.com/hasura-vs-dreamfactory) - [Build A Snowflake REST API in Less Than 5 Minutes](https://blog.dreamfactory.com/generate-a-snowflake-rest-api-in-less-than-5-minutes) Today's IT teams are struggling to make sense of organizational data that has been compiled piecemeal and often stored within disparate storage solutions. Often this information needs to be aggregated and presented in a unified format, yet pulling data from multiple data sources and displaying it in a coherent way can be onerous and error-prone. The challenge is compounded when the data resides in different databases, and possibly within different clouds. To remedy this, companies often embark upon costly and time consuming [data lake](https://en.wikipedia.org/wiki/Data_lake), [data mart](https://en.wikipedia.org/wiki/Data_mart), and [data warehouse](https://en.wikipedia.org/wiki/Data_warehouse) projects. In many cases though, the IT team is simply looking for an effective solution to combine data within a single unified interface! In this tutorial I'll introduce you to a powerful and very popular feature of the DreamFactory platform called *Data Mesh*. Using Data Mesh you can create virtual relationships between two databases much in the same way you can create foreign key relationships between two database tables. We'll walk through an example in which a [MySQL](https://www.dreamfactory.com/hub/integrations/mysql/) database running on Amazon RDS is meshed with an [IBM DB2](https://www.dreamfactory.com/hub/integrations/ibm-db2/) database running on IBM Cloud, merging the data together so it can be retrieved via a single API endpoint. Here's the key things to know about DreamFactory's data marts: [![Server-Stack](https://no-cache.hubspot.com/cta/default/44870387/interactive-179228959126.png)](https://blog.dreamfactory.com/hs/cta/wi/redirect?encryptedPayload=AVxigLJEgdrl5EXz6GQRhJS5qKXgI3HWKKzfrTH6l%2FoGakZxXVBgED68FMQzZAUoL5ceFImFHEhgi%2FSUtDfLmkf3JcZhjQRDlPZ076Xgpypy4NGkX6h2jaRiVvD4IugGRHpLg1q%2Be%2FriB%2FkKorskHDPKs3oKkqn0%2F0zF41V9GfgVNiYKIEKvLA%3D%3D&webInteractiveContentId=179228959126&portalId=44870387) ![Data Mesh](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/datamesh-1.png?width=758&height=400&name=datamesh-1.png) ## What is Data Mesh? Data Mesh, introduced by [Zhamak Dehghani](https://martinfowler.com/articles/data-mesh-principles.html), is a decentralized approach to data architecture that advocates for a self-serve, domain-oriented model. It aims to address the challenges associated with centralized data platforms and traditional monolithic data architectures. By distributing data ownership and management to individual domain teams, Data Mesh embraces the principles of autonomy, alignment, and product thinking. ### Key Principles of Data Mesh ### Benefits of Data Mesh Data Mesh offers improved data quality and reliability by empowering domain teams to take ownership of their data products. This decentralized approach enhances accountability and reduces the burden on centralized data teams. Data Mesh can promote enhanced data democratization, enabling domain teams to access and analyze data independently. This empowers teams to make faster and more informed decisions, fostering a data-driven culture across the organization. Data Mesh architecture can also ensure scalability and flexibility, accommodating the diverse needs of different domains. Data Mesh also reduces bottlenecks and dependencies by distributing responsibilities and fostering autonomy among domain teams. This improves agility and minimizes reliance on a single point of failure, leading to more efficient data processes. ## What are Data Marts? Data marts are subsets of data warehouses that are designed to serve the analytical needs of specific departments, teams, or business functions within an organization. They are tailored to provide relevant and easily accessible data for decision-making and analysis within a specific domain. ### Benefits of Data Marts The primary purpose of data marts is to provide optimized and streamlined access to data for specific user groups. Some key benefits of data marts include: ## Want to Watch a Video on this Topic Instead? A video-based version of this tutorial is available at [https://academy.dreamfactory.com](https://academy.dreamfactory.com/). Or just click on the video below!     ## Configuring the MySQL and IBM DB2 APIs For the purposes of this tutorial I'll assume you're already familiar with DreamFactory fundamentals, including how to generate database-backed REST APIs. If you'd like to follow along in your own environment, you'll need to configure two database APIs within your DreamFactory instance. ## Configuring Data Mesh After generating your APIs, enter DreamFactory's `Schema` component and select the API and table that will serve as the relationship parent. In the following screenshot I've chosen the `MySQL` API and the `employees` table: ![Schema](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/schema.png?width=554&height=235&name=schema.png) Once selected, you can scroll down to the table's "Relationships" section. This section warrants a bit of explanation. When DreamFactory generates a database API, it analyzes all tables, stored procedures, views, table columns and datatypes, and foreign key relationships. This section contains a list of join aliases that you can use to easily join tables via the API: ![Relationships](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/relationships.png?width=800&height=242&name=relationships.png) However you're not limited to these aliases; by clicking the `Add Virtual Relationship` button you can create new relationships where they didn't previously exist, including relationships between two databases. Click on the `Add Virtual Relationship` button and you'll be presented with an interface for defining the relationship between two databases. See the following screenshot: ![Defining the Datamesh](https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/define-datamesh.png) In this screenshot, I've defined the fields as follows: After defining these fields, save the changes and you're ready to begin using the new relationship! ### Querying the Relationship Now that the relationship has been defined, let's execute a query and view the combined results. We'll begin by showing what a query to the `employees` table looks like prior to configuring Data Mesh: ![MySQL results](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/mysql.png?width=389&height=404&name=mysql.png) After querying Data Mesh, the results look like this: ![MySQL and DB2 combined results](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/mysql-db2.png?width=490&height=664&name=mysql-db2.png)   [![API](https://no-cache.hubspot.com/cta/default/44870387/interactive-178934315268.png)](https://blog.dreamfactory.com/hs/cta/wi/redirect?encryptedPayload=AVxigLLcqxttC8VzkPhQKskok9%2Fq3AOB%2BNADhtbXW3g8ZAKU7ZQFrFsZrOB3Tc8onkg%2FZdTc7GNbDD4yVuaF9pmNOVdRROCs4rPSzoatFrlhcdwtrn91pYdzRURPY0PqPd4F%2BS6L%2B4CfoVtvOsxe1Vs%2BBD2Y3pxYP83ukYFMw5wObRr%2F4JvG%2BQ%3D%3D&webInteractiveContentId=178934315268&portalId=44870387) ## Conclusion DreamFactory's Data Mesh feature offers an incredibly straightforward, point-and-click solution for creating sophisticated and transparent unified queries. You're certainly not limited to meshing two databases together; try meshing two, three, or more databases together and marvel over the time and aggravation savings! ## FAQs on DreamFactory's Data Mesh for Unified Data Management ### What is Data Mesh? **Data Mesh** is a decentralized data [architecture](https://blog.dreamfactory.com/common-types-of-software-architecture/) approach that treats data as a product, emphasizing domain-specific ownership and management. This method helps overcome challenges associated with traditional centralized data platforms, promoting autonomy, alignment, and product thinking. ### How Does Data Mesh Benefit IT Teams? Data Mesh offers: ### What are the Key Principles of Data Mesh? The core principles include: ### What are Data Marts? Data Marts are subsets of [data warehouses,](https://blog.dreamfactory.com/databases-vs-data-warehouses-what-are-the-differences/) tailored to specific departments or business functions. They provide relevant and accessible data for domain-specific decision-making. ### Benefits of Data Marts? Key advantages include: ### How Does DreamFactory's Data Mesh Enhance ERP Functionality? DreamFactory’s Data Mesh allows for: Related Reading: https://blog.dreamfactory.com/from-data-lake-to-data-mesh-how-data-mesh-benefits-businesses-2/ TAGS: [Data Mesh](https://blog.dreamfactory.com/tag/data-mesh) ![Jason Gilmore](https://blog.dreamfactory.com/hs-fs/hubfs/e92b7c5571ae1bf1ac6e6326767f35c0.jpeg?width=100&height=100&name=e92b7c5571ae1bf1ac6e6326767f35c0.jpeg) Jason Gilmore Jason is the author of almost a dozen books on web development, including most recently Easy Laravel 5, and Beginning PHP and MySQL, 4th Edition. He's the co-founder of the CodeMash Conference, one of the largest software conferences in the Midwestern United States. Jason serves as a technical advisor to the boards of several technology startups. His free time is spent playing with his kids and reading. Stay Connected with The Connector Newsletter! Subscribe to stay up-to-date with DreamFactory's latest product updates, API best practices, and tech humor in your inbox. [![Dreamfactory Logo](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/Megamenu-logo.svg)](https://www.dreamfactory.com/) [Call Sales +1 (415) 993-5877](tel:+14159935877) Open – Mon–Fri 9–5 PT [FREE 30 Minute Demo](https://www.dreamfactory.com/demo) #### Follow us - [GitHub](https://github.com/dreamfactorysoftware/dreamfactory) - [Facebook](https://www.facebook.com/dfsoftwareinc/) - [X (Twitter)](https://twitter.com/dfsoftwareinc) - [LinkedIn](https://www.linkedin.com/company/dreamfactory-software) - [YouTube](https://www.youtube.com/c/dreamfactorysoftware) ### Features [Features](https://www.dreamfactory.com/features) [Self hosted](https://www.dreamfactory.com/features#self) [API Generation](https://www.dreamfactory.com/features#api) [Security](https://www.dreamfactory.com/features#secure) [Customization](https://www.dreamfactory.com/features#custom) [Pricing](https://www.dreamfactory.com/pricing) ### Installers [Linux](https://www.dreamfactory.com/features#installer) [Docker](https://www.dreamfactory.com/features#installer) [Kubernetes](https://www.dreamfactory.com/features#installer) ### API Resources [Documentation](https://docs.dreamfactory.com/) [Case Studies](https://www.dreamfactory.com/stories) [White Papers](https://www.dreamfactory.com/resources/whitepapers) [Academy](https://www.dreamfactory.com/academy) [API Calculator](https://calculator.dreamfactory.com) [Open Source](https://github.com/dreamfactorysoftware) ### Company [Blog](https://blog.dreamfactory.com/) [Hub](https://www.dreamfactory.com/hub) [About us](https://www.dreamfactory.com/about) [Partners](https://www.dreamfactory.com/partners) [Support](https://www.dreamfactory.com/support) [Connectors](https://www.dreamfactory.com/connectors) [Contact Us](https://www.dreamfactory.com/demo) © 2025 DreamFactory. All rights reserved. [Terms of Use](https://www.dreamfactory.com/terms-of-use) [Privacy Policy](https://www.dreamfactory.com/privacy-policy) [LLMs](https://www.dreamfactory.com/llms.txt) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Jason Gilmore", "url" : "https://blog.dreamfactory.com/author/jason-gilmore" }, "dateModified" : "2024-11-11T19:45:50.828Z", "datePublished" : "2026-01-15T00:00:00.000Z", "headline" : "Easier Data Marts with DreamFactory Data Mesh", "image" : [ "https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/Understanding-SOAP-Security-1.png" ], "mainEntityOfPage" : { "@id" : "https://blog.dreamfactory.com/easier-data-marts-with-dreamfactory-data-mesh", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.dreamfactory.com/hubfs/DreamFactory%20-%20Orange%20-%20Transparent-1.png" } } } ``` ```json { "@context" : "https://schema.org", "@type" : "FAQPage", "mainEntity" : [ { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Data Mesh is a decentralized data architecture approach that treats data as a product, emphasizing domain-specific ownership and management. This method helps overcome challenges associated with traditional centralized data platforms, promoting autonomy, alignment, and product thinking." }, "name" : "What is Data Mesh?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Data Mesh offers: Improved Data Quality by empowering domain teams to own their data products, Enhanced Data Democratization allowing teams to access and analyze data independently, Scalability and Flexibility to accommodate diverse domain needs, and Reduced Bottlenecks by distributing responsibilities, enhancing efficiency." }, "name" : "How Does Data Mesh Benefit IT Teams?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "The core principles of Data Mesh include Domain-Oriented Ownership where teams are responsible for their data products, Self-Serve Data Infrastructure equipping teams with tools for managing data products, Federated Computational Governance distributing governance responsibilities, and Product Thinking encouraging viewing data as a product." }, "name" : "What are the Key Principles of Data Mesh?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Data Marts are subsets of data warehouses, tailored to specific departments or business functions. They provide relevant and accessible data for domain-specific decision-making." }, "name" : "What are Data Marts?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Key advantages of Data Marts include Improved Performance optimized for specific analytical requirements, Business-Focused Insights delivering data relevant to specific departments, Enhanced Data Governance for better control over data quality and compliance, and Agile Analytics that are flexible to adapt to changing business needs." }, "name" : "What are the Benefits of Data Marts?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "DreamFactory’s Data Mesh enhances ERP functionality by allowing for Custom Reports and Integrations without altering ERP functionality, ensuring Security for secure data access across various sources, and providing Flexibility with an API-based interface for agile data querying and migration." }, "name" : "How Does DreamFactory's Data Mesh Enhance ERP Functionality?" } ] } ```