{"id":18740,"date":"2020-05-20T03:05:49","date_gmt":"2020-05-20T03:05:49","guid":{"rendered":"https:\/\/rbsitsoftwaresolution.com\/blog\/microsoft-launches-azure-synapse-link-to-help-enterprises-get-faster-insights-from-their-data.html"},"modified":"2020-05-20T03:05:49","modified_gmt":"2020-05-20T03:05:49","slug":"microsoft-launches-azure-synapse-link-to-help-enterprises-get-faster-insights-from-their-data","status":"publish","type":"post","link":"https:\/\/www.rbsitsoftwaresolution.in\/blog\/microsoft-launches-azure-synapse-link-to-help-enterprises-get-faster-insights-from-their-data.html","title":{"rendered":"Microsoft launches Azure Synapse Link to help enterprises get faster insights from their data"},"content":{"rendered":"

At its Build developer conference, Microsoft <\/a> today announced Azure Synapse Link, a new enterprise service that allows businesses to analyze their data faster and more efficiently, using an approach that\u2019s generally called \u201chybrid transaction\/analytical processing\u201d (HTAP). That\u2019s a mouthful; it essentially enables enterprises to use the same database system for analytical and transactional workloads on a single system. Traditionally, enterprises had to make some trade-offs between either building a single system for both that was often highly over-provisioned or maintain separate systems for transactional and analytics workloads.<\/p>\n

Last year, at its Ignite conference, Microsoft announced Azure Synapse Analytics<\/a>, an analytics service that combines analytics and data warehousing to create what the company calls \u201cthe next evolution of Azure SQL Data Warehouse.\u201d Synapse Analytics brings together data from Microsoft\u2019s services and those from its partners and makes it easier to analyze.<\/p>\n

\u201cOne of the key things, as we work with our customers on their digital transformation journey, there is an aspect of being data-driven, of being insights-driven as a culture, and a key part of that really is that once you decide there is some amount of information or insights that you need, how quickly are you able to get to that? For us, time to insight and a secondary element, which is the cost it takes, the effort it takes to build these pipelines and maintain them with an end-to-end analytics solution, was a key metric we have been observing for multiple years from our largest enterprise customers,\u201d said Rohan Kumar, Microsoft\u2019s corporate VP for Azure Data.<\/p>\n

Synapse Link takes the work Microsoft did on Synaps Analytics a step further by removing the barriers between Azure\u2019s operational databases and Synapse Analytics, so enterprises can immediately get value from the data in those databases without going through a data warehouse first.<\/p>\n

\u201cWhat we are announcing with Synapse Link is the next major step in the same vision that we had around reducing the time to insight,\u201d explained Kumar. \u201cAnd in this particular case, a long-standing barrier that exists today between operational databases and analytics systems is these complex ETL (extract, transform, load) pipelines that need to be set up just so you can do basic operational reporting or where, in a very transactionally consistent way, you need to move data from your operational system to the analytics system, because you don\u2019t want to impact the performance of the operational system in any way because that\u2019s typically dealing with, depending on the system, millions of transactions per second.\u201d<\/p>\n

ETL pipelines, Kumar argued, are typically expensive and hard to build and maintain, yet enterprises are now building new apps \u2014 and maybe even line of business mobile apps \u2014 where any action that consumers take and that is registered in the operational database is immediately available for predictive analytics, for example.<\/p>\n

From the user perspective, enabling this only takes a single click to link the two, while it removes the need for managing additional data pipelines or database resources. That, Kumar said, was always the main goal for Synapse Link. \u201cWith a single click, you should be able to enable real-time analytics on your operational data in ways that don\u2019t have any impact on your operational systems, so you\u2019re not using the compute part of your operational system to do the query, you actually have to transform the data into a columnar format, which is more adaptable for analytics, and that\u2019s really what we achieved with Synapse Link.\u201d<\/p>\n

Because traditional HTAP systems on-premises typically share their compute resources with the operational database, those systems never quite took off, Kumar argued. In the cloud, with Synapse Link, though, that impact doesn\u2019t exist because you\u2019re dealing with two separate systems. Now, once a transaction gets committed to the operational database, the Synapse Link system transforms the data into a columnar format that is more optimized for the analytics system \u2014 and it does so in real time.<\/p>\n

For now, Synapse Link is only available in conjunction with Microsoft\u2019s Cosmos DB database. As Kumar told me, that\u2019s because that\u2019s where the company saw the highest demand for this kind of service, but you can expect the company to add support for available in Azure SQL, Azure Database for PostgreSQL <\/a> and Azure Database for MySQL <\/a> in the future.<\/p>\n

\n

Microsoft\u2019s Azure Synapse Analytics bridges the gap between data lakes and warehouses<\/a><\/p>\n<\/blockquote>\n

\n

<\/a><\/p>\n

Article source: http:\/\/feedproxy.google.com\/~r\/techcrunchIt\/~3\/07EbP3iazMc\/<\/p>","protected":false},"excerpt":{"rendered":"

At its Build developer conference, Microsoft today announced Azure Synapse Link, a new enterprise service that allows businesses to analyze their data faster and more efficiently, using an approach that\u2019s <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[19],"tags":[25],"class_list":["post-18740","post","type-post","status-publish","format-standard","hentry","category-enterprise-software","tag-enterprise"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t