{"id":4684,"date":"2025-10-13T10:00:37","date_gmt":"2025-10-13T09:00:37","guid":{"rendered":"https:\/\/data4success.de\/?p=4684"},"modified":"2025-11-27T08:06:59","modified_gmt":"2025-11-27T07:06:59","slug":"mirrored-database-in-microsoft-fabric","status":"publish","type":"post","link":"https:\/\/data4success.de\/en\/mirrored-database-in-microsoft-fabric\/","title":{"rendered":"Mirrored Database in Microsoft Fabric"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"4684\" class=\"elementor elementor-4684\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-40aba21 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"40aba21\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f8d018b\" data-id=\"f8d018b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f42530d elementor-widget elementor-widget-text-editor\" data-id=\"f42530d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p data-start=\"384\" data-end=\"748\">Who with <strong data-start=\"392\" data-end=\"418\">Microsoft Dynamics NAV<\/strong>, <strong data-start=\"420\" data-end=\"432\">Navision<\/strong> or <strong data-start=\"438\" data-end=\"458\">Business Central<\/strong> knows the problem: Reports are often based on <strong data-start=\"513\" data-end=\"531\">Excel exports<\/strong> or nightly data loads. This means delays and a high level of manual effort. For controllers and decision-makers in SMEs in particular, this means that important analyses are not up to date.<\/p><p data-start=\"750\" data-end=\"851\">With the <strong data-start=\"758\" data-end=\"816\">new \"Mirrored Database\" function in Microsoft Fabric<\/strong> this is a thing of the past.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-347fa43 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"347fa43\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6a38b2e\" data-id=\"6a38b2e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-229c6ce elementor-widget elementor-widget-text-editor\" data-id=\"229c6ce\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 data-start=\"853\" data-end=\"890\">What is the \"Mirrored Database\"?<\/h3><p data-start=\"891\" data-end=\"1208\">The mirrored database is a function in <strong data-start=\"934\" data-end=\"954\">Microsoft Fabric<\/strong>with which relational databases - e.g. a <strong data-start=\"1001\" data-end=\"1024\">Azure SQL database<\/strong> - <strong data-start=\"1027\" data-end=\"1049\">almost in real time<\/strong> can be mirrored. Changes to the source data are automatically applied and are immediately available in <strong data-start=\"1149\" data-end=\"1191\">Fabric lakehouses or data warehouses<\/strong> available.<\/p><p data-start=\"1210\" data-end=\"1291\">This eliminates the need for complex ETL processes or manual exports.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-69b45dd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"69b45dd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b683887\" data-id=\"b683887\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d9f764d elementor-widget elementor-widget-text-editor\" data-id=\"d9f764d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 data-start=\"1293\" data-end=\"1354\">Advantages especially for NAV, Navision and Business Central<\/h3><p data-start=\"1355\" data-end=\"1583\">ERP systems such as NAV or Business Central in particular generate enormous amounts of data: Orders, invoices, stock movements, production orders. With the mirrored database, companies can use this data immediately for analyses:<\/p><ul data-start=\"1585\" data-end=\"2075\"><li data-start=\"1585\" data-end=\"1686\"><p data-start=\"1587\" data-end=\"1686\"><strong data-start=\"1587\" data-end=\"1611\">Real-time transparency<\/strong>A new booking in the ERP is visible in Fabric a few seconds later.<\/p><\/li><li data-start=\"1687\" data-end=\"1796\"><p data-start=\"1689\" data-end=\"1796\"><strong data-start=\"1689\" data-end=\"1712\">Less complexity<\/strong>Instead of own data loading routes, synchronization is handled by Fabric.<\/p><\/li><li data-start=\"1797\" data-end=\"1950\"><p data-start=\"1799\" data-end=\"1950\"><strong data-start=\"1799\" data-end=\"1817\">Scalability<\/strong>Even large volumes of data can be processed efficiently - a real advantage with long transaction data from NAV\/Business Central.<\/p><\/li><li data-start=\"1951\" data-end=\"2075\"><p data-start=\"1953\" data-end=\"2075\"><strong data-start=\"1953\" data-end=\"1976\">Central database<\/strong>: Departments access the same, up-to-date data - without different Excel versions.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9bf6edc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9bf6edc\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-347c587\" data-id=\"347c587\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c556bd0 elementor-widget elementor-widget-text-editor\" data-id=\"c556bd0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 data-start=\"2077\" data-end=\"2115\">How does the facility work?<\/h3><ol data-start=\"2116\" data-end=\"2497\"><li data-start=\"2116\" data-end=\"2215\"><p data-start=\"2119\" data-end=\"2215\"><strong data-start=\"2119\" data-end=\"2152\">Connect Azure SQL database<\/strong> - the Mirrored Database supports a direct connection.<\/p><\/li><li data-start=\"2216\" data-end=\"2282\"><p data-start=\"2219\" data-end=\"2282\"><strong data-start=\"2219\" data-end=\"2241\">Select tables<\/strong> - e.g. customers, articles, postings.<\/p><\/li><li data-start=\"2283\" data-end=\"2374\"><p data-start=\"2286\" data-end=\"2374\"><strong data-start=\"2286\" data-end=\"2318\">Automatic synchronization<\/strong> - Fabric reflects all changes almost in real time.<\/p><\/li><li data-start=\"2375\" data-end=\"2497\"><p data-start=\"2378\" data-end=\"2497\"><strong data-start=\"2378\" data-end=\"2395\">Build reports<\/strong> - the data is immediately available in Fabric for dashboards, AI analyses or self-service reporting.<\/p><\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-77f1875 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"77f1875\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-34bd0b0\" data-id=\"34bd0b0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bca9053 elementor-widget elementor-widget-text-editor\" data-id=\"bca9053\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p data-start=\"2510\" data-end=\"2705\">The mirrored database is a <strong data-start=\"2540\" data-end=\"2555\">Gamechanger<\/strong> for all companies that want to <strong data-start=\"2587\" data-end=\"2649\">ERP data from Dynamics NAV, Navision or Business Central<\/strong> want to use them efficiently and without delay.<\/p><p data-start=\"2707\" data-end=\"2916\">Instead of outdated Excel exports, a <strong data-start=\"2752\" data-end=\"2784\">Real-time reporting platform<\/strong>which relieves the burden on both controllers and management - and paves the way for data-driven decisions in SMEs.<\/p><p data-start=\"2707\" data-end=\"2916\"><strong>Do you have any questions or would you like to find out more about our methods?<\/strong> <a href=\"https:\/\/data4success.de\/en\/contact\/\">Get in touch with us<\/a> - We show you how you can use your data for sustainable success.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Wer mit Microsoft Dynamics NAV, Navision oder Business Central arbeitet, kennt das Problem: Reports basieren oft auf Excel-Exporten oder n\u00e4chtlichen Datenladungen. Das bedeutet Zeitverzug und hohen manuellen Aufwand. Gerade f\u00fcr Controller und Entscheider im Mittelstand f\u00fchrt das dazu, dass wichtige Analysen nicht auf dem aktuellsten Stand sind. Mit der neuen Funktion \u201eMirrored Database\u201c in Microsoft [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":4690,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4684","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/comments?post=4684"}],"version-history":[{"count":10,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4684\/revisions"}],"predecessor-version":[{"id":4780,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4684\/revisions\/4780"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media\/4690"}],"wp:attachment":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media?parent=4684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/categories?post=4684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/tags?post=4684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}