CINXE.COM

<!DOCTYPE html><html lang="en"><head><meta charSet="utf-8"/><meta name="viewport" content="width=device-width, initial-scale=1"/><link rel="preload" as="image" href="/assets/blog/2023/self-service-thumb.png"/><link rel="preload" as="image" href="/assets/blog/2023/self-service-1.png"/><link rel="preload" as="image" href="/assets/blog/2023/self-service-2.png"/><link rel="stylesheet" href="/_next/static/css/2aafeea248cede9a.css" data-precedence="next"/><link rel="stylesheet" href="/_next/static/css/fddcadcb43c27471.css" data-precedence="next"/><link rel="stylesheet" href="/_next/static/css/df58b362c76677f9.css" data-precedence="next"/><link rel="preload" as="script" fetchPriority="low" href="/_next/static/chunks/webpack-d0682dbbb946c48b.js"/><script src="/_next/static/chunks/fd9d1056-16ea8fe38a7128bb.js" async=""></script><script src="/_next/static/chunks/7023-f4d731cab88fb54c.js" async=""></script><script src="/_next/static/chunks/main-app-881f01dbe13267cd.js" async=""></script><script src="/_next/static/chunks/8173-114e2eeaae9e6aa9.js" async=""></script><script src="/_next/static/chunks/5813-46de9cb53c5263b9.js" async=""></script><script src="/_next/static/chunks/231-264d60bf1d424be4.js" async=""></script><script src="/_next/static/chunks/8471-e989399c86506ac9.js" async=""></script><script src="/_next/static/chunks/7482-7b5e507e010202f6.js" async=""></script><script src="/_next/static/chunks/4642-6a1ecf50e071d787.js" async=""></script><script src="/_next/static/chunks/260-7a31c570f80ecb45.js" async=""></script><script src="/_next/static/chunks/app/layout-79717b45130e28f3.js" async=""></script><script src="/_next/static/chunks/2482-1a2bdbb7910b89d3.js" async=""></script><script src="/_next/static/chunks/1051-5dd35963d58226c4.js" async=""></script><script src="/_next/static/chunks/1450-dc842fcb97d2f785.js" async=""></script><script src="/_next/static/chunks/app/page-0a098a0fe7def471.js" async=""></script><script src="/_next/static/chunks/2630-3c42b776210aaa43.js" async=""></script><script src="/_next/static/chunks/app/blog/template-152ffeacefd01572.js" async=""></script><link rel="preload" href="https://www.googletagmanager.com/gtag/js?id=G-S8YRCL4JQW" as="script"/><title>Self-service data. Voilà! - Morph Blog</title><meta name="description" content="Use Morph to compile, analyze, visualize, and share data your stored in MySQL and PostgreSQL — all in real-time, and without coding or SQL."/><meta property="og:title" content="Self-service data. Voilà!"/><meta property="og:description" content="Use Morph to compile, analyze, visualize, and share data your stored in MySQL and PostgreSQL — all in real-time, and without coding or SQL."/><meta property="og:url" content="https://www.morph-data.io/blog/2023/self-service-data-voila"/><meta property="og:site_name" content="Morph"/><meta property="og:image" content="https://www.morph-data.io/assets/blog/2023/self-service-thumb.png"/><meta property="og:type" content="website"/><meta name="twitter:card" content="summary_large_image"/><meta name="twitter:title" content="Self-service data. Voilà!"/><meta name="twitter:description" content="Use Morph to compile, analyze, visualize, and share data your stored in MySQL and PostgreSQL — all in real-time, and without coding or SQL."/><meta name="twitter:image" content="https://www.morph-data.io/assets/blog/2023/self-service-thumb.png"/><link rel="icon" href="/favicon.ico" type="image/x-icon" sizes="48x48"/><meta name="next-size-adjust"/><script src="/_next/static/chunks/polyfills-78c92fac7aa8fdd8.js" noModule=""></script></head><body class="__className_d65c78 z-0 relative"><script>!function(){try{var d=document.documentElement,c=d.classList;c.remove('light','dark');var e=localStorage.getItem('theme');if('system'===e||(!e&&true)){var t='(prefers-color-scheme: dark)',m=window.matchMedia(t);if(m.media!==t||m.matches){d.style.colorScheme = 'dark';c.add('dark')}else{d.style.colorScheme = 'light';c.add('light')}}else if(e){c.add(e|| '')}if(e==='light'||e==='dark')d.style.colorScheme=e}catch(e){}}()</script><div data-is-root-theme="true" data-accent-color="gray" data-gray-color="slate" data-has-background="true" data-panel-background="translucent" data-radius="medium" data-scaling="100%" class="radix-themes"><header class="sticky top-0 z-50 py-2 bg-white/60 dark:bg-black/60 backdrop-blur"><div class="hidden lg:flex justify-between items-center container mx-auto w-full py-1 gap-2"><a href="/"><img alt="Morph" loading="lazy" width="173" height="32" decoding="async" data-nimg="1" class="inline-block dark:hidden cursor-pointer" style="color:transparent" src="/assets/morph_logo.svg"/><img alt="Morph" loading="lazy" width="173" height="32" decoding="async" data-nimg="1" class="dark:inline-block hidden cursor-pointer" style="color:transparent" src="/assets/morph_logo_white.svg"/></a><div class="flex-1"></div><div class="flex items-center cursor-pointer text-black dark:text-white bg-transparent hover:bg-black/[0.1] dark:hover:bg-white/[0.1] transition-all font-normal px-4 py-2 rounded-md" type="button" id="radix-:Rqqba:" aria-haspopup="menu" aria-expanded="false" data-state="closed">Features<svg xmlns="http://www.w3.org/2000/svg" width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="lucide lucide-chevron-down"><path d="m6 9 6 6 6-6"></path></svg></div><a class="mr-4" href="/blogs"><button data-accent-color="" class="rt-reset rt-BaseButton rt-r-size-3 rt-variant-solid rt-Button cursor-pointer text-black dark:text-white bg-transparent hover:bg-black/[0.1] dark:hover:bg-white/[0.1] transition-all font-normal">Blog</button></a><a href="https://docs.morph-data.io/docs/en" target="_blank"><button data-accent-color="" class="rt-reset rt-BaseButton rt-r-size-3 rt-variant-solid rt-Button cursor-pointer text-black dark:text-white bg-transparent hover:bg-black/[0.1] dark:hover:bg-white/[0.1] transition-all font-normal">Docs</button></a><a class="mr-4" href="/pricing"><button data-accent-color="" class="rt-reset rt-BaseButton rt-r-size-3 rt-variant-solid rt-Button cursor-pointer text-black dark:text-white bg-transparent hover:bg-black/[0.1] dark:hover:bg-white/[0.1] transition-all font-normal">Pricing</button></a><a href="https://app.morph-data.io/"><button data-accent-color="orange" class="rt-reset rt-BaseButton rt-r-size-3 rt-variant-solid rt-Button">Start for free</button></a><a href="/form/contact" target="_blank"><button data-accent-color="orange" class="rt-reset rt-BaseButton rt-r-size-3 rt-variant-outline rt-Button font-normal cursor-pointer">Talk to Sales</button></a><button data-accent-color="" type="button" id="radix-:R2aqba:" aria-haspopup="menu" aria-expanded="false" data-state="closed" class="rt-reset rt-BaseButton rt-r-size-4 rt-variant-ghost rt-IconButton text-black dark:text-white hover:bg-black/[0.1] transition-all font-normal cursor-pointer mx-1"><svg xmlns="http://www.w3.org/2000/svg" width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="lucide lucide-globe"><circle cx="12" cy="12" r="10"></circle><path d="M12 2a14.5 14.5 0 0 0 0 20 14.5 14.5 0 0 0 0-20"></path><path d="M2 12h20"></path></svg></button></div><div class="flex lg:hidden items-center w-full py-1 px-3"><div class="flex lg:hidden items-center items-center w-full"><a href="/"><img alt="Morph" loading="lazy" width="173" height="32" decoding="async" data-nimg="1" class="inline-block dark:hidden cursor-pointer" style="color:transparent" src="/assets/morph_logo.svg"/><img alt="Morph" loading="lazy" width="173" height="32" decoding="async" data-nimg="1" class="dark:inline-block hidden cursor-pointer" style="color:transparent" src="/assets/morph_logo_white.svg"/></a><div class="flex-1"></div><button data-accent-color="" type="button" id="radix-:Rsqba:" aria-haspopup="menu" aria-expanded="false" data-state="closed" class="rt-reset rt-BaseButton rt-r-size-3 rt-variant-ghost rt-IconButton ml-3 text-black dark:text-white hover:bg-black/[0.1] transition-all font-normal cursor-pointer"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="lucide lucide-menu"><line x1="4" x2="20" y1="12" y2="12"></line><line x1="4" x2="20" y1="6" y2="6"></line><line x1="4" x2="20" y1="18" y2="18"></line></svg></button></div></div><hr class="absolute w-full bottom-0 transition-opacity duration-300 ease-in-out opacity-0"/></header><main class=""><div class="p-4 lg:p-0 container mx-auto"><section class="p-6 lg:p-10 rounded-xl flex flex-col gap-6 items-center mb-10 "><article class="prose dark:prose-invert max-w-[960px] mb-[40px]"><h1>Self-service data. Voilà!</h1> <p><img src="/assets/blog/2023/self-service-thumb.png" alt="hero image"/></p> <p>In their daily activities, marketing and sales teams rely on various sources of data, among which relational databases play a central role.</p> <ul> <li>What is a relational database?</li> <li>Why should marketing and sales teams even care about data stored in relational databases?</li> </ul> <p>Learn how business teams can leverage data stored in relational databases to retrieve, aggregate, and visualize data in real-time. ‍</p> <h2>Relational database — why should I care?</h2> <p>‍</p> <h3>What is a relational database ?</h3> <p>A relational database (RDB) is a type of database. It is a structured collection of data organized in tables. ‍</p> <h3>Importance of relational databases in marketing and sales</h3> <p>Relational databases store crucial marketing and sales data, ranging from customer information, transaction details, product data and much more.</p> <p>To maintain a competitive edge, marketing and sales teams need to be able to quickly analyze and interpret data to adapt to market dynamics, refine strategies, and seize opportunities.</p> <p>To analyze data, well, you need data. Which data should I use, and where and how can I get it? Excellent questions madame, monsieur! ‍</p> <h3>How marketing and sales teams access data today?</h3> <p>Until now, there have been several methods for business teams to leverage data stored in relational databases (RDB):</p> <ul> <li>Requesting engineers to extract data: This involves requesting engineers to extract files such as CSV whenever needed. Aggregation and visualization are typically performed using Excel or spreadsheets.</li> <li>Use a database client: A database client is a software application or tool used to execute queries on a database, managing and manipulating data. Since databases lack a Graphical User Interface (GUI), database clients provide an interface for users to view the data in tabular form, facilitating operations such as searching, updating, inserting, and deleting.</li> <li>Building data pipelines: This involves transferring RDB data to a data warehouse (DWH) and using business intelligence (BI) tools for aggregation and visualization.</li> </ul> <p><img src="/assets/blog/2023/self-service-1.png" alt="Voila"/></p> <h2>Why data is difficult to access?</h2> <p>All of these methods have inherent issues which prevent business teams to easily access and use the data stored in relational databases:</p> <ol> <li><strong>Engineer dependency:</strong> Reliance on engineers for data extraction introduces delays and impedes real-time tracking.</li> <li><strong>SQL complexity:</strong> SQL (Structured Query Language) is a programming language used to communicate to store, retrieve, manage, and manipulate data within a database. For non-developers or specialists, the requirement to use SQL to interact with a RDB is a significant hurdle.</li> <li><strong>Pipeline maintenance burden:</strong> Building and maintaining data pipelines demand <a href="https://www.morphdb.io/post/analyzing-snowflake-data-without-sql-using-ai-features">significant effort</a> and ongoing engineering support.</li> <li><strong>Snapshot limitations:</strong> Extracted data are snapshots of the data at a given point in time, preventing any analysis on real-time information.</li> <li><strong>Risk of unintentional edits to the original data:</strong> The use of tools like Excel for aggregation poses a risk of unintentional edits to original data. ‍</li> </ol> <h2>Making data more accessible</h2> <p>With Morph, business teams can access, analyze and share data stored in RDB, all with just a few clicks and prompt written in everyday language:</p> <ul> <li><strong>Data aggregation in everyday language:</strong> No need for coding or SQL. Query your data in everyday language. In the background Morph does the heavy-lifting to automatically generate and execute the corresponding SQL.</li> <li><strong>Real-time data</strong>: By directly referencing RDB data and periodically importing it, real-time aggregation becomes feasible.</li> <li><strong>No impact on the original data:</strong> In addition to user and table-specific permission management, you can freely aggregate and visualize data without affecting the original data by preparing tables for aggregation.</li> <li><strong>Flexible aggregation and visualization without building a data pipeline:</strong> With the Canvas feature, you can freely aggregate and visualize data stored in RDB in the form of tables and graphs. Share your results with other team members via embeds on links. No need to build a data pipeline. For more details on the Canvas feature: welcome to <a href="https://www.morphdb.io/post/welcome-to-morph-1-0">Morph 1.0</a>. ‍</li> </ul> <h2>How to connect Morph and your relational database</h2> <p>We will now look at the actual connection between Morph and RDB.</p> <p>The connection is completed by simply entering the required information on-screen.</p> <p>This connection does not synchronize with the database imported into, so if you edit a value in Morph, the data in that database will not be affected.</p> <p>Once data integration is complete, start aggregating and visualizing data in everyday language.</p> <p><img src="/assets/blog/2023/self-service-2.png" alt="Voila"/></p> <h3>Retrieve, aggregate, and visualize data in real-time with Morph</h3> <p>Once data integration is complete, you can start aggregating and visualizing your data using everyday language, no coding or SQL needed.</p> <p>Witness how business teams can perform data aggregation in Morph, empowering their data-driven decision-making in new way: <a href="https://www.morphdb.io/post/elevating-salesforce-with-morph-for-data-driven-sales-teams">elevating salesforce with Morph for data driven sales teams</a>. ‍</p> <h2>Final thoughts</h2> <p>Precious insights for revenue growth are out-of-sight, since data stored in relational databases is out of reach for business teams.</p> <p>By integrating their relational databases into Morph, business teams can gain an unprecedented accessibility to the data which matters to them. Not only that poorly or unexploited data comes within reach, teams can analyze, visualize and collaborate on data with clicks and in everyday language — no need for coding or SQL skills.</p> <p>Morph data integration capabilities extend beyond relational databases by connecting with SaaS data sources like Salesforce, Stripe, and data warehouses like Snowflake.</p> <p>Embrace a new era of integrated data analysis, expand your organization's analytical capabilities and exploit untapped revenue possibilities.</p> <p>Sign up for free!</p></article></section><section class="p-6 lg:p-10 rounded-xl flex flex-col gap-6 items-center mb-10 "></section></div></main><footer class="bg-black text-white py-4 min-h-80"><div class="rt-Container rt-r-size-4 p-8"><div class="rt-ContainerInner"><div class="grid grid-cols-1 lg:grid-cols-3 w-full gap-8"><div class="flex flex-col gap-4"><img alt="Morph" loading="lazy" width="173" height="32" decoding="async" data-nimg="1" style="color:transparent" src="/assets/morph_logo_white.svg"/><a class="text-sm text-[var(--slate-9)] hover:text-white hover:underline my-1" href="/terms-of-service">Terms of Service</a><a class="text-sm text-[var(--slate-9)] hover:text-white hover:underline my-1" href="/privacy-policy">Privacy Policy</a></div><div class="flex flex-col gap-4"><a class="text-[var(--slate-9)] hover:text-white hover:underline" target="" href="/blogs">Blog</a><a class="text-[var(--slate-9)] hover:text-white hover:underline" target="_blank" href="https://docs.morph-data.io/docs/en">Docs</a><a class="text-[var(--slate-9)] hover:text-white hover:underline" target="" href="/pricing">Pricing</a></div><div class="flex flex-col gap-4"><div class="rt-Flex w-full py-1"><a rel="noopener noreferrer" target="_blank" href="https://twitter.com/morphdbHQ"><img alt="Morph" loading="lazy" width="25" height="25" decoding="async" data-nimg="1" class="inline-block cursor-pointer mr-3" style="color:transparent" srcSet="/_next/image?url=%2Fassets%2Fx-white-logo.png&w=32&q=75 1x, /_next/image?url=%2Fassets%2Fx-white-logo.png&w=64&q=75 2x" src="/_next/image?url=%2Fassets%2Fx-white-logo.png&w=64&q=75"/></a><a rel="noopener noreferrer" target="_blank" href="https://discord.gg/8ZcSbDrN6e"><img alt="Morph" loading="lazy" width="25" height="25" decoding="async" data-nimg="1" class="inline-block cursor-pointer mr-4" style="color:transparent" srcSet="/_next/image?url=%2Fassets%2Fdiscord-white-icon.png&w=32&q=75 1x, /_next/image?url=%2Fassets%2Fdiscord-white-icon.png&w=64&q=75 2x" src="/_next/image?url=%2Fassets%2Fdiscord-white-icon.png&w=64&q=75"/></a><a rel="noopener noreferrer" target="_blank" href="https://www.linkedin.com/company/morphdb/about/"><img alt="Morph" loading="lazy" width="25" height="25" decoding="async" data-nimg="1" class="inline-block cursor-pointer" style="color:transparent" srcSet="/_next/image?url=%2Fassets%2Flinkedin-app-white-icon.png&w=32&q=75 1x, /_next/image?url=%2Fassets%2Flinkedin-app-white-icon.png&w=64&q=75 2x" src="/_next/image?url=%2Fassets%2Flinkedin-app-white-icon.png&w=64&q=75"/></a></div><div class="flex-1"></div><p class="text-[var(--slate-9)] text-sm">© 2024 Morph. All rights reserved.</p></div></div></div></div></footer></div><script src="/_next/static/chunks/webpack-d0682dbbb946c48b.js" async=""></script><script>(self.__next_f=self.__next_f||[]).push([0]);self.__next_f.push([2,null])</script><script>self.__next_f.push([1,"1:HL[\"/_next/static/media/a34f9d1faa5f3315-s.p.woff2\",\"font\",{\"crossOrigin\":\"\",\"type\":\"font/woff2\"}]\n2:HL[\"/_next/static/css/2aafeea248cede9a.css\",\"style\"]\n3:HL[\"/_next/static/css/fddcadcb43c27471.css\",\"style\"]\n"])</script><script>self.__next_f.push([1,"4:I[5751,[],\"\"]\n6:I[9275,[],\"\"]\n7:I[1343,[],\"\"]\n9:I[8701,[\"8173\",\"static/chunks/8173-114e2eeaae9e6aa9.js\",\"5813\",\"static/chunks/5813-46de9cb53c5263b9.js\",\"231\",\"static/chunks/231-264d60bf1d424be4.js\",\"8471\",\"static/chunks/8471-e989399c86506ac9.js\",\"7482\",\"static/chunks/7482-7b5e507e010202f6.js\",\"4642\",\"static/chunks/4642-6a1ecf50e071d787.js\",\"260\",\"static/chunks/260-7a31c570f80ecb45.js\",\"3185\",\"static/chunks/app/layout-79717b45130e28f3.js\"],\"AmplitudeContextProvider\"]\na:\"$Sreact.suspense\"\nb:I[241,[\"8173\",\"static/chunks/8173-114e2eeaae9e6aa9.js\",\"5813\",\"static/chunks/5813-46de9cb53c5263b9.js\",\"231\",\"static/chunks/231-264d60bf1d424be4.js\",\"8471\",\"static/chunks/8471-e989399c86506ac9.js\",\"7482\",\"static/chunks/7482-7b5e507e010202f6.js\",\"4642\",\"static/chunks/4642-6a1ecf50e071d787.js\",\"260\",\"static/chunks/260-7a31c570f80ecb45.js\",\"3185\",\"static/chunks/app/layout-79717b45130e28f3.js\"],\"GlobalEventTracking\"]\nc:I[9512,[\"8173\",\"static/chunks/8173-114e2eeaae9e6aa9.js\",\"5813\",\"static/chunks/5813-46de9cb53c5263b9.js\",\"231\",\"static/chunks/231-264d60bf1d424be4.js\",\"8471\",\"static/chunks/8471-e989399c86506ac9.js\",\"7482\",\"static/chunks/7482-7b5e507e010202f6.js\",\"4642\",\"static/chunks/4642-6a1ecf50e071d787.js\",\"260\",\"static/chunks/260-7a31c570f80ecb45.js\",\"3185\",\"static/chunks/app/layout-79717b45130e28f3.js\"],\"ThemeProvider\"]\nd:I[9340,[\"8173\",\"static/chunks/8173-114e2eeaae9e6aa9.js\",\"5813\",\"static/chunks/5813-46de9cb53c5263b9.js\",\"2482\",\"static/chunks/2482-1a2bdbb7910b89d3.js\",\"4642\",\"static/chunks/4642-6a1ecf50e071d787.js\",\"1051\",\"static/chunks/1051-5dd35963d58226c4.js\",\"1450\",\"static/chunks/1450-dc842fcb97d2f785.js\",\"1931\",\"static/chunks/app/page-0a098a0fe7def471.js\"],\"Theme\"]\ne:I[658,[\"8173\",\"static/chunks/8173-114e2eeaae9e6aa9.js\",\"5813\",\"static/chunks/5813-46de9cb53c5263b9.js\",\"231\",\"static/chunks/231-264d60bf1d424be4.js\",\"8471\",\"static/chunks/8471-e989399c86506ac9.js\",\"7482\",\"static/chunks/7482-7b5e507e010202f6.js\",\"4642\",\"static/chunks/4642-6a1ecf50e071d787.js\",\"260\",\"static/chunks/260-7a31c570f80ecb45.js\",\"3185\",\"static/chunk"])</script><script>self.__next_f.push([1,"s/app/layout-79717b45130e28f3.js\"],\"RootHeader2\"]\nf:I[8173,[\"8173\",\"static/chunks/8173-114e2eeaae9e6aa9.js\",\"5813\",\"static/chunks/5813-46de9cb53c5263b9.js\",\"2482\",\"static/chunks/2482-1a2bdbb7910b89d3.js\",\"4642\",\"static/chunks/4642-6a1ecf50e071d787.js\",\"1051\",\"static/chunks/1051-5dd35963d58226c4.js\",\"1450\",\"static/chunks/1450-dc842fcb97d2f785.js\",\"1931\",\"static/chunks/app/page-0a098a0fe7def471.js\"],\"Image\"]\n10:I[231,[\"8173\",\"static/chunks/8173-114e2eeaae9e6aa9.js\",\"5813\",\"static/chunks/5813-46de9cb53c5263b9.js\",\"231\",\"static/chunks/231-264d60bf1d424be4.js\",\"8471\",\"static/chunks/8471-e989399c86506ac9.js\",\"7482\",\"static/chunks/7482-7b5e507e010202f6.js\",\"4642\",\"static/chunks/4642-6a1ecf50e071d787.js\",\"260\",\"static/chunks/260-7a31c570f80ecb45.js\",\"3185\",\"static/chunks/app/layout-79717b45130e28f3.js\"],\"\"]\n11:I[1164,[\"8173\",\"static/chunks/8173-114e2eeaae9e6aa9.js\",\"5813\",\"static/chunks/5813-46de9cb53c5263b9.js\",\"231\",\"static/chunks/231-264d60bf1d424be4.js\",\"8471\",\"static/chunks/8471-e989399c86506ac9.js\",\"7482\",\"static/chunks/7482-7b5e507e010202f6.js\",\"4642\",\"static/chunks/4642-6a1ecf50e071d787.js\",\"260\",\"static/chunks/260-7a31c570f80ecb45.js\",\"3185\",\"static/chunks/app/layout-79717b45130e28f3.js\"],\"Analytics\"]\n12:I[4404,[\"8173\",\"static/chunks/8173-114e2eeaae9e6aa9.js\",\"5813\",\"static/chunks/5813-46de9cb53c5263b9.js\",\"231\",\"static/chunks/231-264d60bf1d424be4.js\",\"8471\",\"static/chunks/8471-e989399c86506ac9.js\",\"7482\",\"static/chunks/7482-7b5e507e010202f6.js\",\"4642\",\"static/chunks/4642-6a1ecf50e071d787.js\",\"260\",\"static/chunks/260-7a31c570f80ecb45.js\",\"3185\",\"static/chunks/app/layout-79717b45130e28f3.js\"],\"GoogleAnalytics\"]\n14:I[6130,[],\"\"]\n15:[]\n"])</script><script>self.__next_f.push([1,"0:[[[\"$\",\"link\",\"0\",{\"rel\":\"stylesheet\",\"href\":\"/_next/static/css/2aafeea248cede9a.css\",\"precedence\":\"next\",\"crossOrigin\":\"$undefined\"}],[\"$\",\"link\",\"1\",{\"rel\":\"stylesheet\",\"href\":\"/_next/static/css/fddcadcb43c27471.css\",\"precedence\":\"next\",\"crossOrigin\":\"$undefined\"}]],[\"$\",\"$L4\",null,{\"buildId\":\"e-6y4Ay_A3y2A3CgN_DEV\",\"assetPrefix\":\"\",\"initialCanonicalUrl\":\"/blog/2023/self-service-data-voila\",\"initialTree\":[\"\",{\"children\":[\"blog\",{\"children\":[\"2023\",{\"children\":[\"self-service-data-voila\",{\"children\":[\"__PAGE__\",{}]}]}]}]},\"$undefined\",\"$undefined\",true],\"initialSeedData\":[\"\",{\"children\":[\"blog\",{\"children\":[\"2023\",{\"children\":[\"self-service-data-voila\",{\"children\":[\"__PAGE__\",{},[[\"$L5\",[[\"$\",\"h1\",null,{\"children\":\"Self-service data. Voilà!\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":[\"$\",\"img\",null,{\"src\":\"/assets/blog/2023/self-service-thumb.png\",\"alt\":\"hero image\"}]}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"In their daily activities, marketing and sales teams rely on various sources of data, among which relational databases play a central role.\"}],\"\\n\",[\"$\",\"ul\",null,{\"children\":[\"\\n\",[\"$\",\"li\",null,{\"children\":\"What is a relational database?\"}],\"\\n\",[\"$\",\"li\",null,{\"children\":\"Why should marketing and sales teams even care about data stored in relational databases?\"}],\"\\n\"]}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"Learn how business teams can leverage data stored in relational databases to retrieve, aggregate, and visualize data in real-time.\\n‍\"}],\"\\n\",[\"$\",\"h2\",null,{\"children\":\"Relational database — why should I care?\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"‍\"}],\"\\n\",[\"$\",\"h3\",null,{\"children\":\"What is a relational database ?\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"A relational database (RDB) is a type of database. It is a structured collection of data organized in tables.\\n‍\"}],\"\\n\",[\"$\",\"h3\",null,{\"children\":\"Importance of relational databases in marketing and sales\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"Relational databases store crucial marketing and sales data, ranging from customer information, transaction details, product data and much more.\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"To maintain a competitive edge, marketing and sales teams need to be able to quickly analyze and interpret data to adapt to market dynamics, refine strategies, and seize opportunities.\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"To analyze data, well, you need data. Which data should I use, and where and how can I get it? Excellent questions madame, monsieur!\\n‍\"}],\"\\n\",[\"$\",\"h3\",null,{\"children\":\"How marketing and sales teams access data today?\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"Until now, there have been several methods for business teams to leverage data stored in relational databases (RDB):\"}],\"\\n\",[\"$\",\"ul\",null,{\"children\":[\"\\n\",[\"$\",\"li\",null,{\"children\":\"Requesting engineers to extract data: This involves requesting engineers to extract files such as CSV whenever needed. Aggregation and visualization are typically performed using Excel or spreadsheets.\"}],\"\\n\",[\"$\",\"li\",null,{\"children\":\"Use a database client: A database client is a software application or tool used to execute queries on a database, managing and manipulating data. Since databases lack a Graphical User Interface (GUI), database clients provide an interface for users to view the data in tabular form, facilitating operations such as searching, updating, inserting, and deleting.\"}],\"\\n\",[\"$\",\"li\",null,{\"children\":\"Building data pipelines: This involves transferring RDB data to a data warehouse (DWH) and using business intelligence (BI) tools for aggregation and visualization.\"}],\"\\n\"]}],\"\\n\",[\"$\",\"p\",null,{\"children\":[\"$\",\"img\",null,{\"src\":\"/assets/blog/2023/self-service-1.png\",\"alt\":\"Voila\"}]}],\"\\n\",[\"$\",\"h2\",null,{\"children\":\"Why data is difficult to access?\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"All of these methods have inherent issues which prevent business teams to easily access and use the data stored in relational databases:\"}],\"\\n\",[\"$\",\"ol\",null,{\"children\":[\"\\n\",[\"$\",\"li\",null,{\"children\":[[\"$\",\"strong\",null,{\"children\":\"Engineer dependency:\"}],\" Reliance on engineers for data extraction introduces delays and impedes real-time tracking.\"]}],\"\\n\",[\"$\",\"li\",null,{\"children\":[[\"$\",\"strong\",null,{\"children\":\"SQL complexity:\"}],\" SQL (Structured Query Language) is a programming language used to communicate to store, retrieve, manage, and manipulate data within a database. For non-developers or specialists, the requirement to use SQL to interact with a RDB is a significant hurdle.\"]}],\"\\n\",[\"$\",\"li\",null,{\"children\":[[\"$\",\"strong\",null,{\"children\":\"Pipeline maintenance burden:\"}],\" Building and maintaining data pipelines demand \",[\"$\",\"a\",null,{\"href\":\"https://www.morphdb.io/post/analyzing-snowflake-data-without-sql-using-ai-features\",\"children\":\"significant effort\"}],\" and ongoing engineering support.\"]}],\"\\n\",[\"$\",\"li\",null,{\"children\":[[\"$\",\"strong\",null,{\"children\":\"Snapshot limitations:\"}],\" Extracted data are snapshots of the data at a given point in time, preventing any analysis on real-time information.\"]}],\"\\n\",[\"$\",\"li\",null,{\"children\":[[\"$\",\"strong\",null,{\"children\":\"Risk of unintentional edits to the original data:\"}],\" The use of tools like Excel for aggregation poses a risk of unintentional edits to original data.\\n‍\"]}],\"\\n\"]}],\"\\n\",[\"$\",\"h2\",null,{\"children\":\"Making data more accessible\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"With Morph, business teams can access, analyze and share data stored in RDB, all with just a few clicks and prompt written in everyday language:\"}],\"\\n\",[\"$\",\"ul\",null,{\"children\":[\"\\n\",[\"$\",\"li\",null,{\"children\":[[\"$\",\"strong\",null,{\"children\":\"Data aggregation in everyday language:\"}],\" No need for coding or SQL. Query your data in everyday language. In the background Morph does the heavy-lifting to automatically generate and execute the corresponding SQL.\"]}],\"\\n\",[\"$\",\"li\",null,{\"children\":[[\"$\",\"strong\",null,{\"children\":\"Real-time data\"}],\": By directly referencing RDB data and periodically importing it, real-time aggregation becomes feasible.\"]}],\"\\n\",[\"$\",\"li\",null,{\"children\":[[\"$\",\"strong\",null,{\"children\":\"No impact on the original data:\"}],\" In addition to user and table-specific permission management, you can freely aggregate and visualize data without affecting the original data by preparing tables for aggregation.\"]}],\"\\n\",[\"$\",\"li\",null,{\"children\":[[\"$\",\"strong\",null,{\"children\":\"Flexible aggregation and visualization without building a data pipeline:\"}],\" With the Canvas feature, you can freely aggregate and visualize data stored in RDB in the form of tables and graphs. Share your results with other team members via embeds on links. No need to build a data pipeline. For more details on the Canvas feature: welcome to \",[\"$\",\"a\",null,{\"href\":\"https://www.morphdb.io/post/welcome-to-morph-1-0\",\"children\":\"Morph 1.0\"}],\".\\n‍\"]}],\"\\n\"]}],\"\\n\",[\"$\",\"h2\",null,{\"children\":\"How to connect Morph and your relational database\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"We will now look at the actual connection between Morph and RDB.\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"The connection is completed by simply entering the required information on-screen.\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"This connection does not synchronize with the database imported into, so if you edit a value in Morph, the data in that database will not be affected.\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"Once data integration is complete, start aggregating and visualizing data in everyday language.\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":[\"$\",\"img\",null,{\"src\":\"/assets/blog/2023/self-service-2.png\",\"alt\":\"Voila\"}]}],\"\\n\",[\"$\",\"h3\",null,{\"children\":\"Retrieve, aggregate, and visualize data in real-time with Morph\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"Once data integration is complete, you can start aggregating and visualizing your data using everyday language, no coding or SQL needed.\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":[\"Witness how business teams can perform data aggregation in Morph, empowering their data-driven decision-making in new way: \",[\"$\",\"a\",null,{\"href\":\"https://www.morphdb.io/post/elevating-salesforce-with-morph-for-data-driven-sales-teams\",\"children\":\"elevating salesforce with Morph for data driven sales teams\"}],\".\\n‍\"]}],\"\\n\",[\"$\",\"h2\",null,{\"children\":\"Final thoughts\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"Precious insights for revenue growth are out-of-sight, since data stored in relational databases is out of reach for business teams.\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"By integrating their relational databases into Morph, business teams can gain an unprecedented accessibility to the data which matters to them. Not only that poorly or unexploited data comes within reach, teams can analyze, visualize and collaborate on data with clicks and in everyday language — no need for coding or SQL skills.\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"Morph data integration capabilities extend beyond relational databases by connecting with SaaS data sources like Salesforce, Stripe, and data warehouses like Snowflake.\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"Embrace a new era of integrated data analysis, expand your organization's analytical capabilities and exploit untapped revenue possibilities.\"}],\"\\n\",[\"$\",\"p\",null,{\"children\":\"Sign up for free!\"}]]],null],null]},[\"$\",\"$L6\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\",\"blog\",\"children\",\"2023\",\"children\",\"self-service-data-voila\",\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":[\"$\",\"$L7\",null,{}],\"templateStyles\":\"$undefined\",\"templateScripts\":\"$undefined\",\"notFound\":\"$undefined\",\"notFoundStyles\":\"$undefined\",\"styles\":null}],null]},[\"$\",\"$L6\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\",\"blog\",\"children\",\"2023\",\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":[\"$\",\"$L7\",null,{}],\"templateStyles\":\"$undefined\",\"templateScripts\":\"$undefined\",\"notFound\":\"$undefined\",\"notFoundStyles\":\"$undefined\",\"styles\":null}],null]},[\"$L8\",null],null]},[[\"$\",\"html\",null,{\"lang\":\"en\",\"children\":[\"$\",\"body\",null,{\"className\":\"__className_d65c78 z-0 relative\",\"children\":[[\"$\",\"$L9\",null,{\"children\":[[\"$\",\"$a\",null,{\"children\":[\"$\",\"$Lb\",null,{}]}],[\"$\",\"$Lc\",null,{\"attribute\":\"class\",\"children\":[\"$\",\"$Ld\",null,{\"accentColor\":\"gray\",\"grayColor\":\"slate\",\"children\":[[\"$\",\"$Le\",null,{}],[\"$\",\"$L6\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":[\"$\",\"$L7\",null,{}],\"templateStyles\":\"$undefined\",\"templateScripts\":\"$undefined\",\"notFound\":[[\"$\",\"title\",null,{\"children\":\"404: This page could not be found.\"}],[\"$\",\"div\",null,{\"style\":{\"fontFamily\":\"system-ui,\\\"Segoe UI\\\",Roboto,Helvetica,Arial,sans-serif,\\\"Apple Color Emoji\\\",\\\"Segoe UI Emoji\\\"\",\"height\":\"100vh\",\"textAlign\":\"center\",\"display\":\"flex\",\"flexDirection\":\"column\",\"alignItems\":\"center\",\"justifyContent\":\"center\"},\"children\":[\"$\",\"div\",null,{\"children\":[[\"$\",\"style\",null,{\"dangerouslySetInnerHTML\":{\"__html\":\"body{color:#000;background:#fff;margin:0}.next-error-h1{border-right:1px solid rgba(0,0,0,.3)}@media (prefers-color-scheme:dark){body{color:#fff;background:#000}.next-error-h1{border-right:1px solid rgba(255,255,255,.3)}}\"}}],[\"$\",\"h1\",null,{\"className\":\"next-error-h1\",\"style\":{\"display\":\"inline-block\",\"margin\":\"0 20px 0 0\",\"padding\":\"0 23px 0 0\",\"fontSize\":24,\"fontWeight\":500,\"verticalAlign\":\"top\",\"lineHeight\":\"49px\"},\"children\":\"404\"}],[\"$\",\"div\",null,{\"style\":{\"display\":\"inline-block\"},\"children\":[\"$\",\"h2\",null,{\"style\":{\"fontSize\":14,\"fontWeight\":400,\"lineHeight\":\"49px\",\"margin\":0},\"children\":\"This page could not be found.\"}]}]]}]}]],\"notFoundStyles\":[],\"styles\":null}],[\"$\",\"footer\",null,{\"className\":\"bg-black text-white py-4 min-h-80\",\"children\":[\"$\",\"div\",null,{\"style\":\"$undefined\",\"className\":\"rt-Container rt-r-size-4 p-8\",\"children\":[\"$\",\"div\",null,{\"className\":\"rt-ContainerInner\",\"style\":\"$undefined\",\"children\":[\"$\",\"div\",null,{\"className\":\"grid grid-cols-1 lg:grid-cols-3 w-full gap-8\",\"children\":[[\"$\",\"div\",null,{\"className\":\"flex flex-col gap-4\",\"children\":[[\"$\",\"$Lf\",null,{\"src\":\"/assets/morph_logo_white.svg\",\"height\":32,\"width\":173,\"alt\":\"Morph\"}],[\"$\",\"$L10\",null,{\"href\":\"/terms-of-service\",\"className\":\"text-sm text-[var(--slate-9)] hover:text-white hover:underline my-1\",\"children\":\"Terms of Service\"}],[\"$\",\"$L10\",null,{\"href\":\"/privacy-policy\",\"className\":\"text-sm text-[var(--slate-9)] hover:text-white hover:underline my-1\",\"children\":\"Privacy Policy\"}]]}],[\"$\",\"div\",null,{\"className\":\"flex flex-col gap-4\",\"children\":[[\"$\",\"$L10\",null,{\"href\":\"/blogs\",\"className\":\"text-[var(--slate-9)] hover:text-white hover:underline\",\"target\":\"\",\"children\":\"Blog\"}],[\"$\",\"$L10\",null,{\"href\":\"https://docs.morph-data.io/docs/en\",\"className\":\"text-[var(--slate-9)] hover:text-white hover:underline\",\"target\":\"_blank\",\"children\":\"Docs\"}],[\"$\",\"$L10\",null,{\"href\":\"/pricing\",\"className\":\"text-[var(--slate-9)] hover:text-white hover:underline\",\"target\":\"\",\"children\":\"Pricing\"}]]}],[\"$\",\"div\",null,{\"className\":\"flex flex-col gap-4\",\"children\":[[\"$\",\"div\",null,{\"children\":[[\"$\",\"$L10\",null,{\"href\":\"https://twitter.com/morphdbHQ\",\"rel\":\"noopener noreferrer\",\"target\":\"_blank\",\"children\":[\"$\",\"$Lf\",null,{\"src\":\"/assets/x-white-logo.png\",\"height\":25,\"width\":25,\"alt\":\"Morph\",\"className\":\"inline-block cursor-pointer mr-3\"}]}],[\"$\",\"$L10\",null,{\"href\":\"https://discord.gg/8ZcSbDrN6e\",\"rel\":\"noopener noreferrer\",\"target\":\"_blank\",\"children\":[\"$\",\"$Lf\",null,{\"src\":\"/assets/discord-white-icon.png\",\"height\":25,\"width\":25,\"alt\":\"Morph\",\"className\":\"inline-block cursor-pointer mr-4\"}]}],[\"$\",\"$L10\",null,{\"href\":\"https://www.linkedin.com/company/morphdb/about/\",\"rel\":\"noopener noreferrer\",\"target\":\"_blank\",\"children\":[\"$\",\"$Lf\",null,{\"src\":\"/assets/linkedin-app-white-icon.png\",\"height\":25,\"width\":25,\"alt\":\"Morph\",\"className\":\"inline-block cursor-pointer\"}]}]],\"style\":\"$undefined\",\"className\":\"rt-Flex w-full py-1\"}],[\"$\",\"div\",null,{\"className\":\"flex-1\"}],[\"$\",\"p\",null,{\"className\":\"text-[var(--slate-9)] text-sm\",\"children\":\"© 2024 Morph. All rights reserved.\"}]]}]]}]}]}]}]]}]}]]}],[\"$\",\"$L11\",null,{}],[\"$\",\"$L12\",null,{\"gaId\":\"G-S8YRCL4JQW\"}]]}]}],null],null],\"couldBeIntercepted\":false,\"initialHead\":[false,\"$L13\"],\"globalErrorComponent\":\"$14\",\"missingSlots\":\"$W15\"}]]\n"])</script><script>self.__next_f.push([1,"8:[\"$\",\"$L6\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\",\"blog\",\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":\"$L16\",\"templateStyles\":[[\"$\",\"link\",\"0\",{\"rel\":\"stylesheet\",\"href\":\"/_next/static/css/df58b362c76677f9.css\",\"precedence\":\"next\",\"crossOrigin\":\"$undefined\"}]],\"templateScripts\":[],\"notFound\":\"$undefined\",\"notFoundStyles\":\"$undefined\",\"styles\":null}]\n"])</script><script>self.__next_f.push([1,"17:I[7631,[\"8173\",\"static/chunks/8173-114e2eeaae9e6aa9.js\",\"5813\",\"static/chunks/5813-46de9cb53c5263b9.js\",\"231\",\"static/chunks/231-264d60bf1d424be4.js\",\"2630\",\"static/chunks/2630-3c42b776210aaa43.js\",\"4980\",\"static/chunks/app/blog/template-152ffeacefd01572.js\"],\"RelatedArticlesEn\"]\n16:[\"$\",\"main\",null,{\"className\":\"\",\"children\":[\"$\",\"div\",null,{\"className\":\"p-4 lg:p-0 container mx-auto\",\"children\":[[\"$\",\"section\",null,{\"className\":\"p-6 lg:p-10 rounded-xl flex flex-col gap-6 items-center mb-10 \",\"children\":[\"$\",\"article\",null,{\"className\":\"prose dark:prose-invert max-w-[960px] mb-[40px]\",\"children\":[\"$\",\"$L7\",null,{}]}]}],[\"$\",\"section\",null,{\"className\":\"p-6 lg:p-10 rounded-xl flex flex-col gap-6 items-center mb-10 \",\"children\":[\"$\",\"$L17\",null,{\"slug\":\"2023/self-service-data-voila\"}]}]]}]}]\n"])</script><script>self.__next_f.push([1,"13:[[\"$\",\"meta\",\"0\",{\"name\":\"viewport\",\"content\":\"width=device-width, initial-scale=1\"}],[\"$\",\"meta\",\"1\",{\"charSet\":\"utf-8\"}],[\"$\",\"title\",\"2\",{\"children\":\"Self-service data. Voilà! - Morph Blog\"}],[\"$\",\"meta\",\"3\",{\"name\":\"description\",\"content\":\"Use Morph to compile, analyze, visualize, and share data your stored in MySQL and PostgreSQL — all in real-time, and without coding or SQL.\"}],[\"$\",\"meta\",\"4\",{\"property\":\"og:title\",\"content\":\"Self-service data. Voilà!\"}],[\"$\",\"meta\",\"5\",{\"property\":\"og:description\",\"content\":\"Use Morph to compile, analyze, visualize, and share data your stored in MySQL and PostgreSQL — all in real-time, and without coding or SQL.\"}],[\"$\",\"meta\",\"6\",{\"property\":\"og:url\",\"content\":\"https://www.morph-data.io/blog/2023/self-service-data-voila\"}],[\"$\",\"meta\",\"7\",{\"property\":\"og:site_name\",\"content\":\"Morph\"}],[\"$\",\"meta\",\"8\",{\"property\":\"og:image\",\"content\":\"https://www.morph-data.io/assets/blog/2023/self-service-thumb.png\"}],[\"$\",\"meta\",\"9\",{\"property\":\"og:type\",\"content\":\"website\"}],[\"$\",\"meta\",\"10\",{\"name\":\"twitter:card\",\"content\":\"summary_large_image\"}],[\"$\",\"meta\",\"11\",{\"name\":\"twitter:title\",\"content\":\"Self-service data. Voilà!\"}],[\"$\",\"meta\",\"12\",{\"name\":\"twitter:description\",\"content\":\"Use Morph to compile, analyze, visualize, and share data your stored in MySQL and PostgreSQL — all in real-time, and without coding or SQL.\"}],[\"$\",\"meta\",\"13\",{\"name\":\"twitter:image\",\"content\":\"https://www.morph-data.io/assets/blog/2023/self-service-thumb.png\"}],[\"$\",\"link\",\"14\",{\"rel\":\"icon\",\"href\":\"/favicon.ico\",\"type\":\"image/x-icon\",\"sizes\":\"48x48\"}],[\"$\",\"meta\",\"15\",{\"name\":\"next-size-adjust\"}]]\n5:null\n"])</script></body></html>