{"id":21926,"date":"2025-03-25T14:58:56","date_gmt":"2025-03-25T07:58:56","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=21926"},"modified":"2025-03-25T14:59:20","modified_gmt":"2025-03-25T07:59:20","slug":"get-salesforce-insights-in-bigquery-for-unified-analytics-powered-by-datastream","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/get-salesforce-insights-in-bigquery-for-unified-analytics-powered-by-datastream\/","title":{"rendered":"Get Salesforce insights in BigQuery for unified analytics powered by Datastream"},"content":{"rendered":"<section class=\"wpb-content-wrapper\"><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<p><span style=\"font-weight: 400;\">Many businesses today use Software as a Service (SaaS) applications, choosing them for their accessibility, scalability, and reduced infrastructure costs. These cloud-based tools provide immediate access to powerful functionality, allowing companies to streamline operations and focus on core business activities.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><a href=\"https:\/\/gcloudvn.com\/en\/?attachment_id=21903\" rel=\"attachment wp-att-21903\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21903\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/03\/Thang-72024-2025-03-24T144542.628.jpg\" alt=\"\" width=\"600\" height=\"375\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/03\/Thang-72024-2025-03-24T144542.628.jpg 600w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/03\/Thang-72024-2025-03-24T144542.628-18x12.jpg 18w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a>However, as companies grow and their data needs expand, they often find their SaaS data scattered across multiple applications. This is a significant barrier, because when valuable information is siloed, it is difficult to create a comprehensive view of business performance and make informed, data-driven decisions. Furthermore, the SaaS vendor landscape is fragmented\u2014each vendor has its own APIs, authentication methods, and data formats. This creates a complex integration challenge characterized by significant development effort, high maintenance costs, and potential security vulnerabilities.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/get-salesforce-insights-in-bigquery-for-unified-analytics-powered-by-datastream\/#Tich_hop_du_lieu_de_thiet_lap_che_do_xem_thong_nhat\" >Integrating data to establish a unified view\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/get-salesforce-insights-in-bigquery-for-unified-analytics-powered-by-datastream\/#Loi_ich_chinh_cua_Datastream\" >Key benefits of Datastream<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/get-salesforce-insights-in-bigquery-for-unified-analytics-powered-by-datastream\/#Ho_tro_cho_Salesforce_Data_Cloud_hoan_thien_dich_vu_Datastream_cung_cap_mot_so_kha_nang_sau\" >Support for Salesforce Data Cloud rounds out the Datastream offering, which provides a number of capabilities:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/get-salesforce-insights-in-bigquery-for-unified-analytics-powered-by-datastream\/#Bat_dau_voi_Salesforce_source_trong_Datastream\" >Get started with Salesforce source in Datastream\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/get-salesforce-insights-in-bigquery-for-unified-analytics-powered-by-datastream\/#Ket_luan\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tich_hop_du_lieu_de_thiet_lap_che_do_xem_thong_nhat\"><\/span><b>Integrating data to establish a unified view\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.salesforce.com\/data\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Salesforce Data Cloud<\/span><\/a><span style=\"font-weight: 400;\"> (SFDC), a leading customer relationship management (CRM) solution, is a commonly used SaaS application that provides a comprehensive view of customer interactions, sales activities, and marketing campaigns, allowing businesses to identify trends and predict future behavior. But as enterprises accelerate their cloud modernization initiatives, organizations struggle to efficiently, reliably, and securely extract data from Salesforce.\u00a0<\/span><\/p>\n<p><b>Yet, achieving a truly unified view <\/b><span style=\"font-weight: 400;\">of that data is imperative. Consolidating SaaS data with operational data is not merely beneficial, but essential, providing the holistic perspective needed for decisive action, operational efficiency, and profound customer understanding. Consequently, the desire to leverage Salesforce data within Google Cloud for advanced analytics and generative AI is strong. However, realizing this potential is hindered by the significant complexity of the required integrations.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To help, we recently expanded <\/span><a href=\"https:\/\/cloud.google.com\/datastream\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Datastream<\/span><\/a><span style=\"font-weight: 400;\"> our fully managed change data capture (CDC) service, to support Salesforce as a source. Now in preview, this simplifies connecting to Salesforce, automatically capturing changes and delivering them to <\/span><a href=\"https:\/\/cloud.google.com\/bigquery\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">BigQuery<\/span><\/a><span style=\"font-weight: 400;\"> , <\/span><a href=\"https:\/\/cloud.google.com\/storage\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Cloud Storage<\/span><\/a><span style=\"font-weight: 400;\"> and other Google Cloud destinations. We currently support real-time data replication from operational databases such as <\/span><a href=\"https:\/\/cloud.google.com\/datastream\/docs\/sources-postgresql\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Postgres<\/span><\/a><span style=\"font-weight: 400;\"> , <\/span><a href=\"https:\/\/cloud.google.com\/datastream\/docs\/sources-mysql\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">MySQL<\/span><\/a><span style=\"font-weight: 400;\"> , <\/span><a href=\"https:\/\/cloud.google.com\/datastream\/docs\/sources-sqlserver\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">SQL Server<\/span><\/a><span style=\"font-weight: 400;\"> and <\/span><a href=\"https:\/\/cloud.google.com\/datastream\/docs\/sources-oracle\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Oracle<\/span><\/a><span style=\"font-weight: 400;\"> By extending this support to Salesforce, customers can now easily merge their Salesforce data with other data sources to gain valuable insights.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Loi_ich_chinh_cua_Datastream\"><\/span><b>Key benefits of Datastream<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Ho_tro_cho_Salesforce_Data_Cloud_hoan_thien_dich_vu_Datastream_cung_cap_mot_so_kha_nang_sau\"><\/span><b>Support for Salesforce Data Cloud rounds out the Datastream offering, which provides a number of capabilities:<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Better decisions and actionable intelligence: <\/b><span style=\"font-weight: 400;\">With Datastream's low-latency replication, you can provide your business with up-to-the-minute insights from your Salesforce data.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Scalability and Reliability: <\/b><span style=\"font-weight: 400;\">Datastream scales to handle large volumes of data, providing reliable replication.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Fully managed: <\/b><span style=\"font-weight: 400;\">No need to manage infrastructure or worry about maintenance, freeing your team to focus on core tasks.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Multiple authentication methods: <\/b><span style=\"font-weight: 400;\">Salesforce connectivity in Datastream supports both OAuth authentication and username and password authentication.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Support for backfill and CDC: <\/b><span style=\"font-weight: 400;\">Datastream supports both backfill and CDC (change data capture) from Salesforce source.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Bat_dau_voi_Salesforce_source_trong_Datastream\"><\/span><b>Get started with Salesforce source in Datastream\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">IntegrationIntegrating <\/span><a href=\"https:\/\/cloud.google.com\/datastream?hl=en\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Datastream<\/span><\/a><span style=\"font-weight: 400;\"> with Salesforce lets your business use Salesforce CRM to gain a comprehensive view of your data. By replicating data to <\/span><a href=\"https:\/\/gcloudvn.com\/en\/google-cloud-platform\/\"><span style=\"font-weight: 400;\">Google Cloud<\/span><\/a><span style=\"font-weight: 400;\"> for analysis, businesses can unlock deeper insights, improve accuracy, and streamline data pipelines. Learn more in the documentation.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In short, Google Datastream is a powerful tool that helps businesses integrate data from Salesforce into BigQuery seamlessly and efficiently, automate data migration, stream data in real time, optimize costs, enhance analytics, and help businesses easily exploit data from Salesforce for a variety of analytical purposes, from better understanding customer behavior to optimizing marketing and sales campaigns.<\/p>\n<p>&nbsp;<\/p>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"templatera_shortcode\"><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"vc_message_box vc_message_box-standard vc_message_box-rounded vc_color-blue\" ><div class=\"vc_message_box-icon\"><i class=\"vc-mono vc-mono-technorati\"><\/i><\/div><p><a href=\"https:\/\/gcloudvn.com\/en\/main-logo-1\/\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-664\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2021\/06\/main-logo-1.png\" alt=\"\" width=\"221\" height=\"72\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2021\/06\/main-logo-1.png 214w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2021\/06\/main-logo-1-18x6.png 18w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2021\/06\/main-logo-1-183x60.png 183w\" sizes=\"auto, (max-width: 221px) 100vw, 221px\" \/><\/a>As a senior partner of Google in Vietnam, Gimasys has more than 10+ years of experience, consulting on implementing digital transformation for 2000+ domestic corporations. Some typical customers Jetstar, Dien Quan Media, Heineken, Jollibee, Vietnam Airline, HSC, SSI...<\/p>\n<p>Gimasys is currently a strategic partner of many major technology companies in the world such as Salesforce, Oracle Netsuite, Tableau, Mulesoft.<\/p>\n<p>Contact Gimasys - Google Cloud Premier Partner for advice on strategic solutions suitable to the specific needs of your business:<\/p>\n<ul>\n<li>Email: gcp@gimasys.com<\/li>\n<li>Hotline: 0974 417 099<\/li>\n<\/ul>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n<\/section>","protected":false},"excerpt":{"rendered":"Nhi\u1ec1u doanh nghi\u1ec7p hi\u1ec7n nay s\u1eed d\u1ee5ng c\u00e1c \u1ee9ng d\u1ee5ng Ph\u1ea7n m\u1ec1m d\u01b0\u1edbi d\u1ea1ng d\u1ecbch v\u1ee5 (SaaS), l\u1ef1a ch\u1ecdn ch\u00fang v\u00ec kh\u1ea3 n\u0103ng truy c\u1eadp, kh\u1ea3 n\u0103ng m\u1edf r\u1ed9ng v\u00e0 gi\u1ea3m chi ph\u00ed c\u01a1 s\u1edf h\u1ea1 t\u1ea7ng. C\u00e1c c\u00f4ng c\u1ee5&hellip;","protected":false},"author":2,"featured_media":21902,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,135],"tags":[],"class_list":["post-21926","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","category-google-cloud-platform","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/21926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=21926"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/21926\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/21902"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=21926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=21926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=21926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}