{"id":13648,"date":"2020-05-12T12:42:05","date_gmt":"2020-05-12T16:42:05","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=13648"},"modified":"2023-12-08T10:34:06","modified_gmt":"2023-12-08T15:34:06","slug":"connecting-ms-sql-iri-workbench","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/","title":{"rendered":"Connecting MS SQL to IRI Workbench"},"content":{"rendered":"<p>Whether your SQL Server database is on-premise or in a cloud platform like Azure, its data is accessible <a href=\"https:\/\/www.iri.com\/solutions\/database-acceleration\/sql-server\">for movement and manipulation<\/a> in <a href=\"https:\/\/www.iri.com\/products\/workbench\">IRI Workbench<\/a>-supported <a href=\"https:\/\/www.iri.com\/products\">products<\/a> like CoSort, FieldShield, DarkShield, NextForm and RowGen, or the IRI Voracity <a href=\"https:\/\/www.iri.com\/products\/voracity-platform\">platform<\/a> which includes them all. <span style=\"font-weight: 400;\">Note that if you are using DarkShield, only the JDBC connection described below is required.<\/span><\/p>\n<p>Connectivity follows the same paradigm as other relational databases. This means driver downloading and installation, configuration (using and testing with your credentials), registration, and validation. You will need to connect both ODBC for data movement between SQL Server and the IRI run-time engine, and JDBC for table browsing plus metadata interchange in IRI Workbench.<\/p>\n<p>Note that if you use DarkShield with MS SQL to handle unstructured data within certain columns instead of FieldShield, per <a href=\"https:\/\/www.iri.com\/blog\/data-protection\/darkshield-relational-databases\/\">this article<\/a>, you will only need to connect via JDBC.<\/p>\n<p style=\"text-align: center;\"><strong>Follow along with our YouTube video!<\/strong><\/p>\n<p><iframe loading=\"lazy\" title=\"SQLServer DB Tutorial\" width=\"1140\" height=\"641\" src=\"https:\/\/www.youtube.com\/embed\/1SQZVZYFQ0k?start=2&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/p>\n<h4><b>ODBC<\/b><\/h4>\n<p>Start with the 32-bit <b>ODBC <\/b>administrator to configure what should already be available in your Windows OS; i.e., Start &gt; ODBC Data Sources (32-bit). Add \u2026<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI1.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13650 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI1.png\" alt=\"\" width=\"597\" height=\"552\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI1.png 599w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI1-300x277.png 300w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/a><\/p>\n<p>And complete the prompts until successful; e.g.,<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI2.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13652 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI2.png\" alt=\"\" width=\"600\" height=\"549\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI2.png 797w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI2-300x275.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI2-768x703.png 768w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<h4><b>JDBC<\/b><\/h4>\n<p>Locate the <b>JDBC <\/b>driver for your version (or see below), and then open IRI Workbench. Turn your attention to the Data Source Explorer view. Click on\u00a0<a href=\"\/blog\/wp-content\/uploads\/2020\/05\/data-source-explorer-icon.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13665\" src=\"\/blog\/wp-content\/uploads\/2020\/05\/data-source-explorer-icon.png\" alt=\"\" width=\"28\" height=\"22\" \/><\/a> there to open:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI3.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13654 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI3.png\" alt=\"\" width=\"498\" height=\"691\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI3.png 527w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI3-216x300.png 216w\" sizes=\"(max-width: 498px) 100vw, 498px\" \/><\/a><\/p>\n<p>Select SQL Server and click <b>Next &gt;<\/b><\/p>\n<p>The next step is to click on the icon immediately to the right of the driver drop-down box. If you hover the mouse over the button, the tooltip &#8220;New Driver Definition&#8221; will appear.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13655 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI4.png\" alt=\"\" width=\"522\" height=\"164\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI4.png 522w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI4-300x94.png 300w\" sizes=\"(max-width: 522px) 100vw, 522px\" \/><\/a><\/p>\n<p>This will start the process of defining the new driver. On the screen that follows, select the appropriate driver template. <i>SQL Server 2019 is supported<\/i>, even if it does not appear on the list (shown below); you can pick 2016 or 2008 so long as the driver you define in the subsequent step supports it.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13656 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png\" alt=\"\" width=\"599\" height=\"476\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png 620w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5-300x239.png 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/a><\/p>\n<p>Now click on the &#8220;<b>JAR List<\/b>&#8221; tab. Highlight the existing jar file, then click &#8220;<b>Edit JAR\/Zip&#8230;<\/b>&#8221; button on the right. Browse to the location of your Microsoft SQL Server JDBC driver files, and select the jar file.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI6.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13659 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI6.png\" alt=\"\" width=\"599\" height=\"282\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI6.png 620w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI6-300x141.png 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/a><\/p>\n<p>If you cannot connect with the default driver, or want to use a different one (like the <i>32-bit JRE <\/i><b><i>8<\/i><\/b> JDBC v7.4 Driver, for MS SQL Server 2019 available from Microsoft <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/jdbc\/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15\">here<\/a>), remove the current JAR and Add the new one.<\/p>\n<p>Only one driver should be listed. Click &#8220;OK&#8221; to finish the driver definition.<\/p>\n<p>Next, complete the details needed to connect to your SQL Server instance, for example:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13658 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI7.png\" alt=\"\" width=\"517\" height=\"531\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI7.png 517w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI7-292x300.png 292w\" sizes=\"(max-width: 517px) 100vw, 517px\" \/><\/a><\/p>\n<p>If you want to use integrated authentication instead of a separate username and password, then you will have to copy the auth\\x64\\sqljdbc_auth.dll file from the driver folder into your C:\\WINDOWS\\System32 folder first. Administrator privilege is required to copy this file.<\/p>\n<p>Test the connection to make sure that it connects as expected. Save the password. If you use JDBC v11.2 or later and get a <em>SQLServerException<\/em> error because the driver could not establish a secure connection via SSL or find a valid certification path, you can bypass this using v9.4 <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/jdbc\/release-notes-for-the-jdbc-driver?view=sql-server-ver16#94\">here<\/a>.<\/p>\n<h4><b>Workbench Registration<\/b><\/h4>\n<p>Once you have finished creating the Data Source Explorer connection profile, you must <b>REGISTER<\/b> <b>it in preferences. <\/b>Open <i>Preferences <\/i>from the &#8220;Window&#8221; menu. Navigate to and expand the <i>IRI <\/i>preferences in the left side tree.<\/p>\n<p>Select the &#8220;Data Connection Registry&#8221; page. Double click on the entry for your ODBC DSN connection.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI8.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13660 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI8.png\" alt=\"\" width=\"766\" height=\"382\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI8.png 956w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI8-300x150.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI8-768x383.png 768w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/a><\/p>\n<p>Enter your user name and password. At the bottom, select the DTP connection profile that you just made.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI9.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13661 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI9.png\" alt=\"\" width=\"499\" height=\"559\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI9.png 511w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI9-268x300.png 268w\" sizes=\"(max-width: 499px) 100vw, 499px\" \/><\/a><\/p>\n<p>You should now be done with the database connectivity steps for SQL Server. If you need assistance, email <a href=\"mailto:support@iri.com\">support@iri.com<\/a>.<\/p>\n<p>If you have more tables to deal with than you can or need to see at once, you can filter them in the Data Source Explorer (DSE) at the schema or table level <a href=\"https:\/\/help.eclipse.org\/2019-09\/index.jsp?topic=%2Forg.eclipse.datatools.connectivity.doc.user%2Fdoc%2Fhtml%2Fasc1229700364666.html\">this way<\/a>. For more advanced table filtering, <a href=\"https:\/\/www.iri.com\/blog\/vldb-operations\/table-filtering-iri-workbench\/\">see this article<\/a>.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Whether your SQL Server database is on-premise or in a cloud platform like Azure, its data is accessible for movement and manipulation in IRI Workbench-supported products like CoSort, FieldShield, DarkShield, NextForm and RowGen, or the IRI Voracity platform which includes them all. Note that if you are using DarkShield, only the JDBC connection described below<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/\" title=\"Connecting MS SQL to IRI Workbench\">Read More<\/a><\/div>\n","protected":false},"author":2,"featured_media":13656,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[8,363,1,776,91,29,3],"tags":[850,956,647,1471,75],"class_list":["post-13648","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-data-quality","category-data-transformation2","category-etl","category-iri-workbench","category-test-data","category-vldb-operations","tag-iri-workbench","tag-jdbc","tag-microsoft-sql-server","tag-ms-sql","tag-odbc"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Connecting MS SQL to IRI Workbench - IRI<\/title>\n<meta name=\"description\" content=\"Whether your SQL Server database is on-premise or in a cloud platform like Azure, its data is accessible for movement and manipulation in IRI Workbench\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecting MS SQL to IRI Workbench - IRI\" \/>\n<meta property=\"og:description\" content=\"Whether your SQL Server database is on-premise or in a cloud platform like Azure, its data is accessible for movement and manipulation in IRI Workbench\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-12T16:42:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-08T15:34:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"620\" \/>\n\t<meta property=\"og:image:height\" content=\"493\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Don Purnhagen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Don Purnhagen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/\"},\"author\":{\"name\":\"Don Purnhagen\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/5f6325245947c8b8f0a0a76ef81580ec\"},\"headline\":\"Connecting MS SQL to IRI Workbench\",\"datePublished\":\"2020-05-12T16:42:05+00:00\",\"dateModified\":\"2023-12-08T15:34:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/\"},\"wordCount\":658,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png\",\"keywords\":[\"IRI Workbench\",\"JDBC\",\"Microsoft SQL Server\",\"MS SQL\",\"ODBC\"],\"articleSection\":[\"Data Masking\/Protection\",\"Data Quality (DQ&#041;\",\"Data Transformation\",\"ETL\",\"IRI Workbench\",\"Test Data\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/\",\"name\":\"Connecting MS SQL to IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png\",\"datePublished\":\"2020-05-12T16:42:05+00:00\",\"dateModified\":\"2023-12-08T15:34:06+00:00\",\"description\":\"Whether your SQL Server database is on-premise or in a cloud platform like Azure, its data is accessible for movement and manipulation in IRI Workbench\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png\",\"width\":620,\"height\":493},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connecting MS SQL to IRI Workbench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/5f6325245947c8b8f0a0a76ef81580ec\",\"name\":\"Don Purnhagen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/39a152e4ffaf1f20e40d0c6e56a9a91d?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/39a152e4ffaf1f20e40d0c6e56a9a91d?s=96&d=blank&r=g\",\"caption\":\"Don Purnhagen\"},\"url\":\"https:\/\/beta.iri.com\/blog\/author\/donp\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connecting MS SQL to IRI Workbench - IRI","description":"Whether your SQL Server database is on-premise or in a cloud platform like Azure, its data is accessible for movement and manipulation in IRI Workbench","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:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Connecting MS SQL to IRI Workbench - IRI","og_description":"Whether your SQL Server database is on-premise or in a cloud platform like Azure, its data is accessible for movement and manipulation in IRI Workbench","og_url":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/","og_site_name":"IRI","article_published_time":"2020-05-12T16:42:05+00:00","article_modified_time":"2023-12-08T15:34:06+00:00","og_image":[{"width":620,"height":493,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png","type":"image\/png"}],"author":"Don Purnhagen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Don Purnhagen","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/"},"author":{"name":"Don Purnhagen","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/5f6325245947c8b8f0a0a76ef81580ec"},"headline":"Connecting MS SQL to IRI Workbench","datePublished":"2020-05-12T16:42:05+00:00","dateModified":"2023-12-08T15:34:06+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/"},"wordCount":658,"commentCount":0,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png","keywords":["IRI Workbench","JDBC","Microsoft SQL Server","MS SQL","ODBC"],"articleSection":["Data Masking\/Protection","Data Quality (DQ&#041;","Data Transformation","ETL","IRI Workbench","Test Data","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/","url":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/","name":"Connecting MS SQL to IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png","datePublished":"2020-05-12T16:42:05+00:00","dateModified":"2023-12-08T15:34:06+00:00","description":"Whether your SQL Server database is on-premise or in a cloud platform like Azure, its data is accessible for movement and manipulation in IRI Workbench","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png","width":620,"height":493},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Connecting MS SQL to IRI Workbench"}]},{"@type":"WebSite","@id":"https:\/\/beta.iri.com\/blog\/#website","url":"https:\/\/beta.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta.iri.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beta.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/beta.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/5f6325245947c8b8f0a0a76ef81580ec","name":"Don Purnhagen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/39a152e4ffaf1f20e40d0c6e56a9a91d?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/39a152e4ffaf1f20e40d0c6e56a9a91d?s=96&d=blank&r=g","caption":"Don Purnhagen"},"url":"https:\/\/beta.iri.com\/blog\/author\/donp\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2020\/05\/msSQLIRI5.png","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/13648"}],"collection":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=13648"}],"version-history":[{"count":18,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/13648\/revisions"}],"predecessor-version":[{"id":17782,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/13648\/revisions\/17782"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/13656"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=13648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=13648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=13648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}