{"id":945,"date":"2023-05-30T19:19:51","date_gmt":"2023-05-30T19:19:51","guid":{"rendered":"http:\/\/fredborg.org\/?p=945"},"modified":"2023-05-30T19:19:52","modified_gmt":"2023-05-30T19:19:52","slug":"connect-to-onprem-resources-from-business-central-cloud","status":"publish","type":"post","link":"https:\/\/fredborg.org\/?p=945","title":{"rendered":"Connect to OnPrem Resources from Business Central Cloud"},"content":{"rendered":"\n<p>While more and more of our software moves to the cloud, many of us feel like we might have to make the choice between going 100% cloud or staying on-prem, but that is not the case, we might still have some resources on some On-Premises servers, that we would like to be able to connect to from our Business Central this could be either a file share or a SQL database, so how do we connect to these resources? Well, we cannot connect directly from Business Central, however, we can use On-premises data gateways.  <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What are <strong>On-premises data gateways?<\/strong><\/h2>\n\n\n\n<p>On-premises data gateways are services that you install on your local servers which will then allow you to access different resources from external systems, in our case we will use an On-premises data gateway to enable us to connect to our On-Premise resources using a logic app, which we then can connect to our Business Central, so the design is as follows.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"736\" height=\"370\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-1.png\" alt=\"\" class=\"wp-image-947\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-1.png 736w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-1-300x151.png 300w\" sizes=\"auto, (max-width: 736px) 100vw, 736px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Setup data gateway<\/h2>\n\n\n\n<p>The first thing that we need is to download and install the on-premises data gateway <a rel=\"noreferrer noopener\" href=\"https:\/\/learn.microsoft.com\/en-us\/data-integration\/gateway\/service-gateway-install\" target=\"_blank\">here<\/a> you will need to login to your gateway using an Azure account, and choose to <strong>Register a new gateway on this computer <\/strong> <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"626\" height=\"597\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-2.png\" alt=\"\" class=\"wp-image-949\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-2.png 626w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-2-300x286.png 300w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><\/figure>\n\n\n\n<p>Give it a name and a recovery key:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"623\" height=\"568\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-3.png\" alt=\"\" class=\"wp-image-950\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-3.png 623w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-3-300x274.png 300w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/figure>\n\n\n\n<p>Once it is installed head over to your Azure portal choose On-Premises data gateway:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"409\" height=\"204\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-4.png\" alt=\"\" class=\"wp-image-951\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-4.png 409w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-4-300x150.png 300w\" sizes=\"auto, (max-width: 409px) 100vw, 409px\" \/><\/figure>\n\n\n\n<p>Fill in the information and you should be able to see your gateway under installation Name:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"513\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-5.png\" alt=\"\" class=\"wp-image-952\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-5.png 730w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-5-300x211.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/figure>\n\n\n\n<p>And your gateway is now set up and connected, next, let us try to integrate some data from our local server to Business Central.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Local SQL to Business Central <\/h2>\n\n\n\n<p>On my Local PC, I have an SQL server with a database called OnPrem with a single table called Item:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"477\" height=\"260\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-6.png\" alt=\"\" class=\"wp-image-954\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-6.png 477w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-6-300x164.png 300w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><\/figure>\n\n\n\n<p>I have also set up my SQL server to run mixed mode so that I can connect to it using SQL credentials (this is optional) so to connect to my SQL database I have created a Logic App, with a HttpTrigger that takes a payload with an ItemNo:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"372\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-7.png\" alt=\"\" class=\"wp-image-955\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-7.png 610w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-7-300x183.png 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/figure>\n\n\n\n<p>This will then trigger an SQL Server Get rows (V2)<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"272\" height=\"420\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-8.png\" alt=\"\" class=\"wp-image-956\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-8.png 272w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-8-194x300.png 194w\" sizes=\"auto, (max-width: 272px) 100vw, 272px\" \/><\/figure>\n\n\n\n<p>Next setup your connection and choose your Gateway:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"607\" height=\"482\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-9.png\" alt=\"\" class=\"wp-image-957\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-9.png 607w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-9-300x238.png 300w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/figure>\n\n\n\n<p>After creating your connection choose your table and create a Filter Query (this is an Odata query and not SQL query)<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"618\" height=\"289\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-10.png\" alt=\"\" class=\"wp-image-958\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-10.png 618w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-10-300x140.png 300w\" sizes=\"auto, (max-width: 618px) 100vw, 618px\" \/><\/figure>\n\n\n\n<p>Lastly, add a response where you will respond with a list of items:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"617\" height=\"217\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-11.png\" alt=\"\" class=\"wp-image-959\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-11.png 617w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-11-300x106.png 300w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/figure>\n\n\n\n<p>If I call this from Postman with a post against my endpoint and a payload like the following:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\n{\n    &quot;ItemNo&quot;: &quot;1896-S&quot;\n}\n<\/pre><\/div>\n\n\n<p>I get the following result:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\n{\n    &quot;@odata.context&quot;: &quot;https:\/\/logic-apis-northeurope.azure-apim.net\/apim\/sql\/8ed8c3cc17d749a39334393ba48384a6\/$metadata#datasets(&#039;default%2Cdefault&#039;)\/tables(&#039;%5Bdbo%5D.%5BItem%5D&#039;)\/items&quot;,\n    &quot;value&quot;: &#x5B;\n        {\n            &quot;@odata.etag&quot;: &quot;&quot;,\n            &quot;ItemInternalId&quot;: &quot;a72fed74-a957-4a3d-b68d-59dc1477d951&quot;,\n            &quot;ItemNo&quot;: &quot;1896-S              &quot;,\n            &quot;External_x0020_No_x002e_&quot;: &quot;TABLE               &quot;\n        }\n    ]\n}\n<\/pre><\/div>\n\n\n<p>Now let us try to call this Logic app from Business Central; I have extended the Item List with an action, and the code looks as follows:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\npageextension 50100 ItemListExt extends &quot;Item List&quot;\n{\n    actions\n    {\n        addlast(Functions)\n        {\n            action(CallOnPrem)\n            {\n                Caption = &#039;Call On Prem&#039;;\n                Image = Web;\n                ApplicationArea = all;\n                trigger OnAction()\n                var\n                    Content: HttpContent;\n                    Response: HttpResponseMessage;\n                    Client: HttpClient;\n                    header: HttpHeaders;\n                    Jobject: jsonobject;\n                    Jtoken: JsonToken;\n                    Jarray: JsonArray;\n                    body: text;\n                    url: Label &#039;{{URL}}&#039;;\n                    I: Integer;\n                begin\n                    Jobject.Add(&#039;ItemNo&#039;, Rec.&quot;No.&quot;);\n                    Jobject.WriteTo(body);\n                    Content.WriteFrom(body);\n                    Content.GetHeaders(header);\n                    header.Remove(&#039;Content-Type&#039;);\n                    header.Add(&#039;Content-Type&#039;, &#039;application\/json&#039;);\n                    client.Post(url, Content, response);\n                    response.Content().ReadAs(body);\n                    Jobject.ReadFrom(body);\n                    Jobject.Get(&#039;value&#039;, Jtoken);\n                    Jarray := Jtoken.AsArray();\n                    for I := 0 to Jarray.Count() - 1 do begin\n                        Jarray.Get(I, Jtoken);\n                        Jobject := Jtoken.AsObject();\n                        Jobject.Get(&#039;External_x0020_No_x002e_&#039;, Jtoken);\n                        Message(Jtoken.AsValue().AsText());\n                    end;\n                end;\n            }\n        }\n\n        addlast(Promoted)\n        {\n            actionref(OnPremRef; CallOnPrem)\n            { }\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Local File Share to Logic App<\/h2>\n\n\n\n<p>Next, let us try to connect our file share to the cloud, it is done in much the same way as with our SQL database, only this time instead of creating a HTTP trigger we will use the, when a file is created trigger.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"744\" height=\"349\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-12.png\" alt=\"\" class=\"wp-image-964\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-12.png 744w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-12-300x141.png 300w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/figure>\n\n\n\n<p>Set up your connection using a root path, and a valid Windows user.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"921\" height=\"634\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-13.png\" alt=\"\" class=\"wp-image-965\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-13.png 921w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-13-300x207.png 300w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-13-768x529.png 768w\" sizes=\"auto, (max-width: 921px) 100vw, 921px\" \/><\/figure>\n\n\n\n<p>Next, use the get Get content and set up the path.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"945\" height=\"731\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-14.png\" alt=\"\" class=\"wp-image-966\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-14.png 945w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-14-300x232.png 300w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-14-768x594.png 768w\" sizes=\"auto, (max-width: 945px) 100vw, 945px\" \/><\/figure>\n\n\n\n<p>And finally use the HTTP to call a REST endpoint with the content of your file.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"796\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-15.png\" alt=\"\" class=\"wp-image-967\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-15.png 941w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-15-300x254.png 300w, https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/image-15-768x650.png 768w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>And that is it for this post, what we have seen in this post is that even though you move some of your software to the cloud and some of your software is still running on a local server, then using On-premises data gateways you can connect your environments, so instead of thinking either or then you can start thinking why not both, and let each system play to their strengths and instead of only seeing limitations then start looking for opportunities, until next time stay safe.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While more and more of our software moves to the cloud, many of us feel like we might have to&#8230; <a class=\"read-more\" href=\"https:\/\/fredborg.org\/?p=945\" rel=\"nofollow\"> Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":969,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,5],"tags":[],"class_list":["post-945","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure","category-business-central","shapla-grid-item"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Connect to OnPrem Resources from Business Central Cloud - Fredborg<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fredborg.org\/?p=945\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connect to OnPrem Resources from Business Central Cloud - Fredborg\" \/>\n<meta property=\"og:description\" content=\"While more and more of our software moves to the cloud, many of us feel like we might have to... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fredborg.org\/?p=945\" \/>\n<meta property=\"og:site_name\" content=\"Fredborg\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-30T19:19:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-30T19:19:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/header-1024x576.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"576\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dfredborg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dfredborg\" \/>\n<meta name=\"twitter:site\" content=\"@dfredborg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dfredborg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fredborg.org\/?p=945#article\",\"isPartOf\":{\"@id\":\"https:\/\/fredborg.org\/?p=945\"},\"author\":{\"name\":\"dfredborg\",\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"headline\":\"Connect to OnPrem Resources from Business Central Cloud\",\"datePublished\":\"2023-05-30T19:19:51+00:00\",\"dateModified\":\"2023-05-30T19:19:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fredborg.org\/?p=945\"},\"wordCount\":624,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"image\":{\"@id\":\"https:\/\/fredborg.org\/?p=945#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/header.png\",\"articleSection\":[\"Azure\",\"Business Central\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fredborg.org\/?p=945#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fredborg.org\/?p=945\",\"url\":\"https:\/\/fredborg.org\/?p=945\",\"name\":\"Connect to OnPrem Resources from Business Central Cloud - Fredborg\",\"isPartOf\":{\"@id\":\"https:\/\/fredborg.org\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fredborg.org\/?p=945#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fredborg.org\/?p=945#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/header.png\",\"datePublished\":\"2023-05-30T19:19:51+00:00\",\"dateModified\":\"2023-05-30T19:19:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fredborg.org\/?p=945#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fredborg.org\/?p=945\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fredborg.org\/?p=945#primaryimage\",\"url\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/header.png\",\"contentUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/header.png\",\"width\":2560,\"height\":1440},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fredborg.org\/?p=945#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/fredborg.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connect to OnPrem Resources from Business Central Cloud\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fredborg.org\/#website\",\"url\":\"https:\/\/fredborg.org\/\",\"name\":\"Fredborg\",\"description\":\"Business Central and Azure\",\"publisher\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fredborg.org\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\",\"name\":\"dfredborg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png\",\"contentUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png\",\"width\":256,\"height\":256,\"caption\":\"dfredborg\"},\"logo\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:fredborg.org\",\"https:\/\/www.linkedin.com\/in\/dfredborg\/\",\"https:\/\/x.com\/dfredborg\",\"https:\/\/www.youtube.com\/channel\/UCUNZglLDMjBlOK_T9JtI8UA\"],\"url\":\"https:\/\/fredborg.org\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connect to OnPrem Resources from Business Central Cloud - Fredborg","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fredborg.org\/?p=945","og_locale":"en_US","og_type":"article","og_title":"Connect to OnPrem Resources from Business Central Cloud - Fredborg","og_description":"While more and more of our software moves to the cloud, many of us feel like we might have to... Read more","og_url":"https:\/\/fredborg.org\/?p=945","og_site_name":"Fredborg","article_published_time":"2023-05-30T19:19:51+00:00","article_modified_time":"2023-05-30T19:19:52+00:00","og_image":[{"width":1024,"height":576,"url":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/header-1024x576.png","type":"image\/png"}],"author":"dfredborg","twitter_card":"summary_large_image","twitter_creator":"@dfredborg","twitter_site":"@dfredborg","twitter_misc":{"Written by":"dfredborg","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fredborg.org\/?p=945#article","isPartOf":{"@id":"https:\/\/fredborg.org\/?p=945"},"author":{"name":"dfredborg","@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"headline":"Connect to OnPrem Resources from Business Central Cloud","datePublished":"2023-05-30T19:19:51+00:00","dateModified":"2023-05-30T19:19:52+00:00","mainEntityOfPage":{"@id":"https:\/\/fredborg.org\/?p=945"},"wordCount":624,"commentCount":0,"publisher":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"image":{"@id":"https:\/\/fredborg.org\/?p=945#primaryimage"},"thumbnailUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/header.png","articleSection":["Azure","Business Central"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fredborg.org\/?p=945#respond"]}]},{"@type":"WebPage","@id":"https:\/\/fredborg.org\/?p=945","url":"https:\/\/fredborg.org\/?p=945","name":"Connect to OnPrem Resources from Business Central Cloud - Fredborg","isPartOf":{"@id":"https:\/\/fredborg.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fredborg.org\/?p=945#primaryimage"},"image":{"@id":"https:\/\/fredborg.org\/?p=945#primaryimage"},"thumbnailUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/header.png","datePublished":"2023-05-30T19:19:51+00:00","dateModified":"2023-05-30T19:19:52+00:00","breadcrumb":{"@id":"https:\/\/fredborg.org\/?p=945#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fredborg.org\/?p=945"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fredborg.org\/?p=945#primaryimage","url":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/header.png","contentUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/05\/header.png","width":2560,"height":1440},{"@type":"BreadcrumbList","@id":"https:\/\/fredborg.org\/?p=945#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/fredborg.org\/"},{"@type":"ListItem","position":2,"name":"Connect to OnPrem Resources from Business Central Cloud"}]},{"@type":"WebSite","@id":"https:\/\/fredborg.org\/#website","url":"https:\/\/fredborg.org\/","name":"Fredborg","description":"Business Central and Azure","publisher":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fredborg.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d","name":"dfredborg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fredborg.org\/#\/schema\/person\/image\/","url":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png","contentUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png","width":256,"height":256,"caption":"dfredborg"},"logo":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/image\/"},"sameAs":["https:fredborg.org","https:\/\/www.linkedin.com\/in\/dfredborg\/","https:\/\/x.com\/dfredborg","https:\/\/www.youtube.com\/channel\/UCUNZglLDMjBlOK_T9JtI8UA"],"url":"https:\/\/fredborg.org\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=945"}],"version-history":[{"count":9,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/945\/revisions"}],"predecessor-version":[{"id":970,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/945\/revisions\/970"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/media\/969"}],"wp:attachment":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}