{"id":46478,"date":"2014-02-11T17:48:32","date_gmt":"2014-02-11T14:48:32","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=46478"},"modified":"2019-09-03T12:58:11","modified_gmt":"2019-09-03T09:58:11","slug":"how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/","title":{"rendered":"How to Use MS SQL Server with Cloud Foundry v2 (New Service Broker Available)"},"content":{"rendered":"<p>We\u2019ve just released the <a href=\"https:\/\/github.com\/Altoros\/DotNetCloudFoundryServices\" target=\"_blank\" rel=\"noopener noreferrer\">.NET Cloud Foundry Service<\/a>, a Microsoft .NET-based service broker that provides a possibility to use MS SQL Server with Cloud Foundry v2. The broker allows for easy developing and deploying Cloud Foundry services using the Microsoft technology stack. For example, you can quickly add support for the databases of choice, since you only need to implement a single interface. At the moment, the broker is distributed with one default service implementation (MS SQL Server). Below follows a step-by-step tutorial on implementing the service.<\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-transparent 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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#Installing_the_NET_Cloud_Foundry_Service_Broker\" >Installing the .NET Cloud Foundry Service Broker<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#Registering_the_NET_Service_Broker_in_Cloud_Foundry\" >Registering the .NET Service Broker in Cloud Foundry<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#Making_your_plan_public\" >Making your plan public<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#Getting_your_service_up_and_running\" >Getting your service up and running<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#Deploying_and_running_an_app_with_the_new_services\" >Deploying and running an app with the new services<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#Removing_service_bindings_from_your_app\" >Removing service bindings from your app<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#Want_details_Watch_the_video\" >Want details? Watch the video!<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Installing_the_NET_Cloud_Foundry_Service_Broker\"><\/span>Installing the .NET Cloud Foundry Service Broker<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Before you start, make sure that you have the Cloud Foundry Command Line Interface. Installation instructions are available in the <a href=\"https:\/\/docs.cloudfoundry.org\/cf-cli\/install-go-cli.html\" rel=\"noopener noreferrer\" target=\"_blank\">official docs<\/a>. Alternatively, you can use the GCF client, which is a more up-to-date version of the CF tool. Then follow the steps below.<\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\">Install the <code style=\"color: #222222; background-color: #e6e6e6; padding: 1px 2px;\">BrockerServiceSetup.exe<\/code> package on your target machine.<\/li>\n<li style=\"margin-bottom: 6px;\">Configure the network environment to make the service accessible from Cloud Foundry.<\/p>\n<li style=\"margin-bottom: 6px;\">Update the application configuration file with proper settings (add the connection string to Microsoft SQL Server, its public address, etc.) The default configuration file is located here.<\/li>\n<li>Restart the service using the service console to apply all configuration changes.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Registering_the_NET_Service_Broker_in_Cloud_Foundry\"><\/span>Registering the .NET Service Broker in Cloud Foundry<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Indicate the target cloud and select your organization and space.<\/p>\n<pre style=\"padding-left: 20px;\">cf target [your cloud foundry api url]<\/pre>\n<p>Authenticate with the target Cloud Foundry login. Here you have to use an admin account with corresponding access rights. Then, view the existing service brokers.<\/p>\n<p><pre style=\"padding-left: 20px;\">cf service-brokers<\/pre>\n<p>Register the .NET Cloud Foundry Service Broker in Cloud Foundry.<\/p>\n<pre style=\"padding-left: 20px;\">cf add-service-broker TestDotNetServiceBroker --username s --password p --url [your BrokerWindowsService url]<\/pre>\n<p>Registering a broker causes the cloud controller to fetch and validate catalog information from this broker and save the catalog to the cloud controller database.<\/p>\n<p>View existing service brokers.<\/p>\n<pre style=\"padding-left: 20px;\">cf service-brokers<\/pre>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Making_your_plan_public\"><\/span>Making your plan public<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Before using the service, you have to register at least one service plan as public. So, get the service plan GUID.<\/p>\n<pre style=\"padding-left: 20px;\">cf services --marketplace \u2013trace <\/pre>\n<p>Make the service plan public by running the following command with the service plan GUID.<\/p>\n<pre style=\"padding-left: 20px;\"> cf curl PUT \/v2\/service_plans\/[plan_guid_obtained_on_previous_step] -b '{\"public\":'true'}'<\/pre>\n<p>To check that you plan has been successfully set to public, run this command again and see the \u201cpublic\u201d field.<\/p>\n<pre style=\"padding-left: 20px;\">cf services --marketplace \u2013trace<\/pre>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Getting_your_service_up_and_running\"><\/span>Getting your service up and running<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Create a new service instance, choose the required service type, and set the service name and plan.<\/p>\n<pre style=\"padding-left: 20px;\">cf create-service <\/pre>\n<p>Display the information about current service instances in the current space.<\/p>\n<pre style=\"padding-left: 20px;\">cf services<\/pre>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Deploying_and_running_an_app_with_the_new_services\"><\/span>Deploying and running an app with the new services<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Change the current directory to the directory with the app you would like to deploy (the manifest file must be available). Then, deploy the new application with <code style=\"color: #222222; background-color: #e6e6e6; padding: 1px 2px;\">cf push<\/code>.<\/p>\n<p>Bind the service to the application (select the deployed app and service while the command is running).<\/p>\n<pre style=\"padding-left: 20px;\">cf bind-service<\/pre>\n<p>Restart the application.<\/p>\n<pre style=\"padding-left: 20px;\">cf restart [deployed app]<\/pre>\n<p>Now the application is ready to use the new service.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Removing_service_bindings_from_your_app\"><\/span>Removing service bindings from your app<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Remove the service binding from the application (select the deployed application and service while the command is running).<\/p>\n<pre style=\"padding-left: 20px;\">cf unbind-service<\/pre>\n<p>Delete the service (select the deployed application and service while the command is running).<\/p>\n<pre style=\"padding-left: 20px;\">cf delete-service<\/pre>\n<p>We are also planning to implement sharded deployment and reshape the cluster. Follow <a href=\"https:\/\/twitter.com\/Altoros\" target=\"_blank\" rel=\"noopener noreferrer\">@altoros<\/a> to get updated.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Want_details_Watch_the_video\"><\/span>Want details? Watch the video!<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><center><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/uLI7caB8_tk\" height=\"315\" width=\"560\" allowfullscreen=\"\" frameborder=\"0\"><\/iframe><\/center><\/p>\n<hr \/>\n<p><center><small>This post was written by <b>Sergey Marudenko<\/b> and edited by <a href=\"https:\/\/www.altoros.com\/blog\/author\/alex\/\">Alex Khizhnyak<\/a>.<\/small><\/center><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We\u2019ve just released the .NET Cloud Foundry Service, a Microsoft .NET-based service broker that provides a possibility to use MS SQL Server with Cloud Foundry v2. The broker allows for easy developing and deploying Cloud Foundry services using the Microsoft technology stack. For example, you can quickly add support for [&#8230;]<\/p>\n","protected":false},"author":5,"featured_media":46487,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":"","_links_to":"","_links_to_target":""},"categories":[7],"tags":[206],"class_list":["post-46478","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news-and-opinion","tag-oss-cloud-foundry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Use MS SQL Server with Cloud Foundry v2 (New Service Broker Available) | Altoros<\/title>\n<meta name=\"description\" content=\"Learn how to install the broker, register it in Cloud Foundry, make your plan public, remove service bindings from your app, etc.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use MS SQL Server with Cloud Foundry v2 (New Service Broker Available) | Altoros\" \/>\n<meta property=\"og:description\" content=\"We\u2019ve just released the .NET Cloud Foundry Service, a Microsoft .NET-based service broker that provides a possibility to use MS SQL Server with Cloud Foundry v2. The broker allows for easy developing and deploying Cloud Foundry services using the Microsoft technology stack. For example, you can quickly add support for [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2014-02-11T14:48:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-03T09:58:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2014\/02\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1401\" \/>\n\t<meta property=\"og:image:height\" content=\"658\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alex Khizhniak\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alex Khizhniak\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/\",\"name\":\"How to Use MS SQL Server with Cloud Foundry v2 (New Service Broker Available) | Altoros\",\"isPartOf\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2014\/02\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available.png\",\"datePublished\":\"2014-02-11T14:48:32+00:00\",\"dateModified\":\"2019-09-03T09:58:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#primaryimage\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2014\/02\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available.png\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2014\/02\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available.png\",\"width\":1401,\"height\":658},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.altoros.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Use MS SQL Server with Cloud Foundry v2 (New Service Broker Available)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\",\"url\":\"https:\/\/www.altoros.com\/blog\/\",\"name\":\"Altoros\",\"description\":\"Insight\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.altoros.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420\",\"name\":\"Alex Khizhniak\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2017\/06\/druzya-edit1-150x150.jpg\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2017\/06\/druzya-edit1-150x150.jpg\",\"caption\":\"Alex Khizhniak\"},\"description\":\"Alex Khizhniak is Director of Technical Content Strategy at Altoros and a cofounder of a local Java User Group. Managing distributed teams since 2004, he has gained experience as a journalist, an editor-in-chief, a technical writer, a technology evangelist, a project manager, and a product owner. Alex is obsessed with AI\/ML, data science, data integration, ETL\/DWH, data quality, databases (SQL\/NoSQL), big data, IoT, and BI. The articles and industry reports he created or helped to publish reached out to 3,000,000+ tech-savvy readers. Some of the pieces were covered on TechRepublic, ebizQ, NetworkWorld, CIO.com, etc. Find him on Twitter at @alxkh.\",\"sameAs\":[\"https:\/\/x.com\/https:\/\/twitter.com\/alxkh\"],\"url\":\"https:\/\/www.altoros.com\/blog\/author\/alex\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Use MS SQL Server with Cloud Foundry v2 (New Service Broker Available) | Altoros","description":"Learn how to install the broker, register it in Cloud Foundry, make your plan public, remove service bindings from your app, etc.","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:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/","og_locale":"en_US","og_type":"article","og_title":"How to Use MS SQL Server with Cloud Foundry v2 (New Service Broker Available) | Altoros","og_description":"We\u2019ve just released the .NET Cloud Foundry Service, a Microsoft .NET-based service broker that provides a possibility to use MS SQL Server with Cloud Foundry v2. The broker allows for easy developing and deploying Cloud Foundry services using the Microsoft technology stack. For example, you can quickly add support for [...]","og_url":"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/","og_site_name":"Altoros","article_published_time":"2014-02-11T14:48:32+00:00","article_modified_time":"2019-09-03T09:58:11+00:00","og_image":[{"width":1401,"height":658,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2014\/02\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available.png","type":"image\/png"}],"author":"Alex Khizhniak","twitter_misc":{"Written by":"Alex Khizhniak","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/","url":"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/","name":"How to Use MS SQL Server with Cloud Foundry v2 (New Service Broker Available) | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2014\/02\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available.png","datePublished":"2014-02-11T14:48:32+00:00","dateModified":"2019-09-03T09:58:11+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2014\/02\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2014\/02\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available.png","width":1401,"height":658},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/how-to-use-ms-sql-server-with-cloud-foundry-v2-new-service-broker-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Use MS SQL Server with Cloud Foundry v2 (New Service Broker Available)"}]},{"@type":"WebSite","@id":"https:\/\/www.altoros.com\/blog\/#website","url":"https:\/\/www.altoros.com\/blog\/","name":"Altoros","description":"Insight","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.altoros.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420","name":"Alex Khizhniak","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2017\/06\/druzya-edit1-150x150.jpg","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2017\/06\/druzya-edit1-150x150.jpg","caption":"Alex Khizhniak"},"description":"Alex Khizhniak is Director of Technical Content Strategy at Altoros and a cofounder of a local Java User Group. Managing distributed teams since 2004, he has gained experience as a journalist, an editor-in-chief, a technical writer, a technology evangelist, a project manager, and a product owner. Alex is obsessed with AI\/ML, data science, data integration, ETL\/DWH, data quality, databases (SQL\/NoSQL), big data, IoT, and BI. The articles and industry reports he created or helped to publish reached out to 3,000,000+ tech-savvy readers. Some of the pieces were covered on TechRepublic, ebizQ, NetworkWorld, CIO.com, etc. Find him on Twitter at @alxkh.","sameAs":["https:\/\/x.com\/https:\/\/twitter.com\/alxkh"],"url":"https:\/\/www.altoros.com\/blog\/author\/alex\/"}]}},"_links":{"self":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/46478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/comments?post=46478"}],"version-history":[{"count":13,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/46478\/revisions"}],"predecessor-version":[{"id":46492,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/46478\/revisions\/46492"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/46487"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=46478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=46478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=46478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}