{"id":16861,"date":"2022-01-13T16:51:03","date_gmt":"2022-01-13T15:51:03","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/"},"modified":"2025-10-24T09:38:40","modified_gmt":"2025-10-24T07:38:40","slug":"installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/","title":{"rendered":"Installing the ODBC drivers for Microsoft SQLServer for Linux"},"content":{"rendered":"<p>This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here <em>to be completed<\/em>. Refer to <a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\">SQLite<\/a> for installing the required ODBC Driver Manager.<br \/>\nThe test system is a debian v11 (bullseye).<br \/>\nAs root, follow the documentation <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/quickstart-install-connect-ubuntu?view=sql-server-ver15\">here <\/a> to get and install sqlserver express for Linux. Here are the needed steps:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n# wget -qO- https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo apt-key add -\n# add-apt-repository \"$(wget -qO- https:\/\/packages.microsoft.com\/config\/ubuntu\/20.04\/mssql-server-2019.list)\"\n# apt-get install -y mssql-server\n# \/opt\/mssql\/bin\/mssql-conf setup\n<\/pre>\n<p>A systemd service was set up and launched:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n# systemctl status mssql-server --no-pager\n\u25cf mssql-server.service - Microsoft SQL Server Database Engine\n     Loaded: loaded (\/lib\/systemd\/system\/mssql-server.service; enabled; vendor preset: enabled)\n     Active: active (running) since Fri 2021-08-27 15:22:14 CEST; 15s ago\n       Docs: https:\/\/docs.microsoft.com\/en-us\/sql\/linux\n   Main PID: 7795 (sqlservr)\n      Tasks: 120\n     Memory: 880.5M\n        CPU: 5.983s\n     CGroup: \/system.slice\/mssql-server.service\n             \u251c\u25007795 \/opt\/mssql\/bin\/sqlservr\n             \u2514\u25007817 \/opt\/mssql\/bin\/sqlservr\n<\/pre>\n<p>Get and install the ODBC drivers for sqlserver:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [5]\">\n# apt install tdsodbc\n# apt install curl\n# curl https:\/\/packages.microsoft.com\/config\/ubuntu\/20.04\/prod.list | sudo tee \/etc\/apt\/sources.list.d\/msprod.list\n# apt-get update \n# apt-get install mssql-tools unixodbc-dev\n<\/pre>\n<p>Check that the device has been added system-wide:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,5]\">\n# odbcinst -q -d\n...\n[ODBC Driver 17 for SQL Server]\n\n# odbcinst -q -d -n \"ODBC Driver 17 for SQL Server\"\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=\/opt\/microsoft\/msodbcsql17\/lib64\/libmsodbcsql-17.8.so.1.1\n<\/pre>\n<p>As debian, create the sampledb database using the native administration tool sqlcmd:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ sqlcmd -S localhost -U SA -P admin2021!\nCREATE DATABASE sampledb\ngo\n1&gt; SELECT Name from sys.Databases;\n2&gt; go\nName                                                                                                                            \n-----------\nmaster                                                                                                                          \ntempdb                                                                                                                          \nmodel                                                                                                                           \nmsdb                                                                                                                            \nsampledb                                                                                                                        \n\n(5 rows affected)\n<\/pre>\n<p>Populate the sampledb database; statements for table creation for slqserver are available <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/sqlserver.txt\">here<\/a> and the ones to populate the tables <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/sqlserver-data.txt\">here<\/a>.<br \/>\nClick and save the files to create_tables_mssql.sql respectively populate_tables_mssql.sql.<br \/>\nExecute the above SQL scripts still using the default command-line administration tool, sqlcmd:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n$ sqlcmd -S localhost -U SA -P admin2021! -i create_tables_mssql.sql\n$ sqlcmd -S localhost -U SA -P admin2021! -i populate_tables_mssql.sql\n<\/pre>\n<p>Let&#8217;s check the data:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\ncat - &lt;&lt;eot | sqlcmd -S localhost -U SA -P admin2021!\nUSE sampleDB\nSELECT\n        c.country_name,\n        c.country_id,\n        l.country_id,\n        l.street_address,\n        l.city\nFROM\n        countries c\nLEFT JOIN locations l ON l.country_id = c.country_id\nWHERE\n        c.country_id IN ('US', 'UK', 'CN');\neot\nChanged database context to 'sampledb'.\ncountry_name                             country_id country_id street_address                           city                 \n---------------------------------------- ---------- ---------- ---------------------------------------- ---------------------\nChina                                    CN         NULL       NULL                                     NULL                          \nUnited Kingdom                           UK         UK         8204 Arthur St                           London                        \nUnited Kingdom                           UK         UK         Magdalen Centre, The Oxford Science Park Oxford                        \nUnited States of America                 US         US         2014 Jabberwocky Rd                      Southlake                     \nUnited States of America                 US         US         2011 Interiors Blvd                      South San Francisco           \nUnited States of America                 US         US         2004 Charade Rd                          Seattle                       \n\n(6 rows affected)\nSQL&gt; \n<\/pre>\n<p>Configure an ODBC DSN by editing the user\u2019s DSN file:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ vi ~\/.odbc.ini\n...\n[mymssqlserverdb]\nDriver = ODBC Driver 17 for SQL Server\nServer = localhost\n#Port = 1433\nUser = SA\nPassword = admin2021!\nDatabase = sampledb\nLanguage = us_english\nNeedODBCTypesOnly = 1\n<\/pre>\n<p>Check the DSN:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,5]\">\n$ odbcinst -q -s\n...\n[mymssqlserverdb]\n\n$ odbcinst -q -s -n mymssqlserverdb\n[mymssqlserverdb]\nDriver=\/opt\/microsoft\/msodbcsql17\/lib64\/libmsodbcsql-17.8.so.1.1\nServer=localhost\nPort=\nDatabase=sampledb\nUser=SA\nPassword=admin2021!\nLanguage=us_english\nNeedODBCTypesOnly=1\n<\/pre>\n<p>Try a connection to the mssql db via ODBC using the ODBC Driver Manager test tool, isql:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,10]\">\n$ isql -v mymssqlserverdb SA admin2021!\n+---------------------------------------+\n| Connected!                            |\n|                                       |\n| sql-statement                         |\n| help [tablename]                      |\n| quit                                  |\n|                                       |\n+---------------------------------------+\nSQL&gt; SELECT c.country_name, c.country_id, l.country_id, l.street_address, l.city FROM countries c LEFT JOIN locations l ON l.country_id = c.country_id WHERE c.country_id IN ('US', 'UK', 'CN');\nOutput:\n+-----------------------------------------+-----------+-----------+-----------------------------------------+---------------+\n| country_name                            | country_id| country_id| street_address                          | city          |\n+-----------------------------------------+-----------+-----------+-----------------------------------------+---------------+\n| China                                   | CN        |           |                                         |               |\n| United Kingdom                          | UK        | UK        | 8204 Arthur St                          | London        |\n| United Kingdom                          | UK        | UK        | Magdalen Centre, The Oxford Science Park| Oxford        |\n| United States of America                | US        | US        | 2014 Jabberwocky Rd                     | Southlake     |\n| United States of America                | US        | US        | 2011 Interiors Blvd                     | South San Francisco           |\n| United States of America                | US        | US        | 2004 Charade Rd                         | Seattle       |\n+-----------------------------------------+-----------+-----------+-----------------------------------------+---------------+\nSQLRowCount returns 6\n6 rows fetched\n<\/pre>\n<p>Test the DSN with the python module pyodbc:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [3]\">\n$ python3\nimport pyodbc \ncnxn = pyodbc.connect(DSN='mymssqlserverdb;UID=SA;PWD=admin2021!')\ncursor = cnxn.cursor()\t\ncursor.execute(\"\"\"SELECT\n        c.country_name,\n        c.country_id,\n        l.country_id,\n        l.street_address,\n        l.city\nFROM\n        countries c\nLEFT JOIN locations l ON l.country_id = c.country_id\nWHERE\n        c.country_id IN ('US', 'UK', 'CN')\"\"\")\nrow = cursor.fetchone() \nwhile row:\n    print (row) \n    row = cursor.fetchone()\nOutput:\n('China', 'CN', None, None, None)\n('United Kingdom', 'UK', 'UK', '8204 Arthur St', 'London')\n('United Kingdom', 'UK', 'UK', 'Magdalen Centre, The Oxford Science Park', 'Oxford')\n('United States of America', 'US', 'US', '2014 Jabberwocky Rd', 'Southlake')\n('United States of America', 'US', 'US', '2011 Interiors Blvd', 'South San Francisco')\n('United States of America', 'US', 'US', '2004 Charade Rd', 'Seattle')\n<\/pre>\n<p>mssqlservr is now fully accessible from any ODBC application under the debian account.<br \/>\nInstructions for the other data sources can be accessed through the following links:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\">SQLite<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\">Firebird<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\">HSQLDB<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\">MariaDB<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-postgresql\">PostgreSQL<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\">Oracle<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mongodb\">MongoDB<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-cdata-odbc-drivers-for-excel\/\">Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,368],"tags":[],"type_dbi":[],"class_list":["post-16861","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-development-performance"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Installing the ODBC drivers for Microsoft SQLServer for Linux - dbi Blog<\/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:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing the ODBC drivers for Microsoft SQLServer for Linux\" \/>\n<meta property=\"og:description\" content=\"This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-13T15:51:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-24T07:38:40+00:00\" \/>\n<meta name=\"author\" content=\"Middleware Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Middleware Team\" \/>\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:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/\"},\"author\":{\"name\":\"Middleware Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"headline\":\"Installing the ODBC drivers for Microsoft SQLServer for Linux\",\"datePublished\":\"2022-01-13T15:51:03+00:00\",\"dateModified\":\"2025-10-24T07:38:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/\"},\"wordCount\":249,\"commentCount\":0,\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Development &amp; Performance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/\",\"name\":\"Installing the ODBC drivers for Microsoft SQLServer for Linux - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-01-13T15:51:03+00:00\",\"dateModified\":\"2025-10-24T07:38:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installing the ODBC drivers for Microsoft SQLServer for Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\",\"name\":\"Middleware Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"caption\":\"Middleware Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Installing the ODBC drivers for Microsoft SQLServer for Linux - dbi Blog","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.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/","og_locale":"en_US","og_type":"article","og_title":"Installing the ODBC drivers for Microsoft SQLServer for Linux","og_description":"This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/","og_site_name":"dbi Blog","article_published_time":"2022-01-13T15:51:03+00:00","article_modified_time":"2025-10-24T07:38:40+00:00","author":"Middleware Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Middleware Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/"},"author":{"name":"Middleware Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"headline":"Installing the ODBC drivers for Microsoft SQLServer for Linux","datePublished":"2022-01-13T15:51:03+00:00","dateModified":"2025-10-24T07:38:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/"},"wordCount":249,"commentCount":0,"articleSection":["Database Administration &amp; Monitoring","Development &amp; Performance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/","url":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/","name":"Installing the ODBC drivers for Microsoft SQLServer for Linux - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-01-13T15:51:03+00:00","dateModified":"2025-10-24T07:38:40+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Installing the ODBC drivers for Microsoft SQLServer for Linux"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1","name":"Middleware Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","caption":"Middleware Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16861"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16861\/revisions"}],"predecessor-version":[{"id":41197,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16861\/revisions\/41197"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16861"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}