{"id":9722,"date":"2016-06-03T08:38:39","date_gmt":"2016-06-03T12:38:39","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=9722"},"modified":"2024-08-14T17:27:23","modified_gmt":"2024-08-14T21:27:23","slug":"using-the-iri-workbench-data-connection-registry","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/","title":{"rendered":"Using the IRI Workbench Data Connection Registry"},"content":{"rendered":"<p><em><strong>Abstract<\/strong>: This is another IRI Workbench tutorial article on the data integration tools, data discovery tools and data masking tools in the IRI Voracity data management platform which use relational database sources and targets. Specifically, it covers the <strong>Data Connection Registry<\/strong>, which IRI FieldShield, NextForm (DB Edition), CoSort, RowGen and\/or Ripcurrent product installers use for data connection management.<\/em><\/p>\n<p>The Data Connection Registry in <a style=\"color: #1155cc; text-decoration: underline;\" href=\"http:\/\/www.iri.com\/products\/workbench\">IRI Workbench<\/a> is database connection software for relational databases. Found in the IRI menu of the Preferences section of the GUI, the registry gives you the ability to view, add, remove, and modify your connections one convenient place.<\/p>\n<p>The page displays all your registered connections and specific information about each. You can also import or export the data connection registry.<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/preferences-file.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9752 aligncenter\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/preferences-file.png\" alt=\"preferences-file\" width=\"616\" height=\"434\" \/><\/a><\/p>\n<p>While the <span style=\"font-weight: bold;\">DSN<\/span> column on the page lists all DSNs listed in ODBC Admin screen under System and User, the <strong>Active<\/strong> box shows that those DSNs should be visible in DSN combo boxes in IRI Workbench. <span style=\"line-height: 1.5;\">\u00a0<\/span><\/p>\n<p>A green check mark displays in the <span style=\"font-weight: bold;\">Auth<\/span> column if you saved, on this preference page, the authentication of any ODBC connection that does not store the user name and password for you.<\/p>\n<p>Referring to the JDBC connection you\u2019ve made in the Data Tools Platform (DTP) plug-in in the Workbench (shown in the Data Source Explorer windows), the <span style=\"font-weight: bold;\">Connection Profile<\/span>\u00a0column provides the mapping information for the specific data source.<\/p>\n<p>The <span style=\"font-weight: bold;\">Add<\/span> and <span style=\"font-weight: bold;\">Edit<\/span> buttons open the Data Connection Registry dialog to add new connections to the registry, or to modify existing connections:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/03\/DataConnectionDialog-e1615995216687.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14355 size-full aligncenter\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/03\/DataConnectionDialog-e1615995216687.png\" alt=\"\" width=\"440\" height=\"540\" \/><\/a><\/p>\n<p>This dialog provides four options for data connections:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><span style=\"font-weight: bold;\">DSN Type<\/span> \u2013 Add a new system or user data source via the ODBC Data Source Administrator, which opens when you click the button in this section. Complete the ODBC Data Source Administrator session to add (and test) a new connection. The new system or user data source is automatically included in the Data Connection Registry.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p align=\"center\"><a title=\"Using the IRI Workbench Data Connection Registry - Sharon Hewitt 2.jpg\" href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/Using-the-IRI-Workbench-Data-Connection-Registry-Sharon-Hewitt-2.jpg\" rel=\"prettyPhoto\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" style=\"width: 436px; height: 361px;\" title=\"ODBC Data Source Administrator\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/t_Using-the-IRI-Workbench-Data-Connection-Registry-Sharon-Hewitt-2.jpg\" alt=\"ODBC Data Source Administrator\" width=\"436\" height=\"361\" \/><\/a><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><span style=\"font-weight: bold;\">File DSN<\/span> \u2013 Use the browse option to locate and select a <span style=\"font-style: italic;\">file<\/span>.dsn. The path and file name display in the <span style=\"font-weight: bold;\">File<\/span> field, and the name of the <span style=\"font-style: italic;\">file<\/span>.dsn is in the <span style=\"font-weight: bold;\">Name<\/span> field. Note that to create a file DSN connection, you must first <a style=\"color: #1155cc; text-decoration: underline;\" href=\"http:\/\/www.iri.com\/blog\/vldb-operations\/dsn-files-and-iri-software\/\">create the file which includes the connection information and a .dsn extension<\/a>. While a system or user DSN is automatically included in the Data Connection Registry, you must add a file DSN because the system cannot automatically locate the file that defines the DSN.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><span style=\"font-weight: bold;\">Bit version<\/span> \u2013 Select the bit version to match the driver bit version.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><span style=\"font-weight: bold;\">Schema filter<\/span> \u2013 \u00a0Use the Schema Filter field to\u00a0filter schema to any ODBC or system DSN. For example, if your schema is SCOTT, only the tables in the SCOTT schema are shown.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><span style=\"font-weight: bold;\">Authentication<\/span> \u2013 Add authentication for any ODBC connection\u00a0by adding the username and password. To encrypt either in the scripts, select the appropriate encrypt checkbox. When a connection has authentication added, a green check mark displays in the <span style=\"font-weight: bold;\">Auth <\/span>column on the Data Connection Registry.<span style=\"line-height: 1.5;\">\u00a0<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><span style=\"font-weight: bold;\">Mapping<\/span> \u2013 To map your specified data source, select a connection profile from the list in the Mapping section. Or, create a new connection profile that contains the connection property information for a data source in your enterprise. Mapping your data connections to the Data Tools Platform (DTP) is required. If the connection is not mapped, you are prompted to do so while using a job wizard.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>To remove a connection from the registry list, select that connection, and then click <span style=\"font-weight: bold;\">Remove<\/span>.<\/p>\n<p>To import or export your entire data connection registry in an XML-formatted document, use the corresponding <span style=\"font-weight: bold;\">Import <\/span>and <span style=\"font-weight: bold;\">Export <\/span>buttons on the Data Connection Registry preferences page. The following is a piece of the XML file of the exported data connection registry shown in the screens above.<\/p>\n<p><a title=\"Using the IRI Workbench Data Connection Registry - Sharon Hewitt 3.jpg\" href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/Using-the-IRI-Workbench-Data-Connection-Registry-Sharon-Hewitt-3.jpg\" rel=\"prettyPhoto\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" style=\"width: 624px; height: 268px;\" title=\"A piece of the XML file of the exported data connection registry\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/t_Using-the-IRI-Workbench-Data-Connection-Registry-Sharon-Hewitt-3.jpg\" alt=\"A piece of the XML file of the exported data connection registry\" width=\"624\" height=\"268\" \/><\/a><\/p>\n<p>If you need help with the data connection registry in IRI Workbench, please contact <a style=\"color: #1155cc; text-decoration: underline;\" href=\"mailto:support@iri.com\">support@iri.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Abstract: This is another IRI Workbench tutorial article on the data integration tools, data discovery tools and data masking tools in the IRI Voracity data management platform which use relational database sources and targets. Specifically, it covers the Data Connection Registry, which IRI FieldShield, NextForm (DB Edition), CoSort, RowGen and\/or Ripcurrent product installers use for<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/\" title=\"Using the IRI Workbench Data Connection Registry\">Read More<\/a><\/div>\n","protected":false},"author":7,"featured_media":11813,"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":[91],"tags":[1064,1071,1062,1070,831,1067,1068,1069,850,956,1066,75,1065,1063,550],"class_list":["post-9722","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-iri-workbench","tag-add","tag-authentication","tag-data-connection-registry","tag-data-source-administrator","tag-data-tools-platform","tag-database-connections","tag-dsn","tag-dtp-mapping","tag-iri-workbench","tag-jdbc","tag-modify","tag-odbc","tag-remove","tag-view","tag-xml"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using the IRI Workbench Data Connection Registry - IRI<\/title>\n<meta name=\"description\" content=\"Learn how to use the Data Connection Registry in IRI Workbench to manage your RDB connections for ETL, data classification, data masking, 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.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using the IRI Workbench Data Connection Registry\" \/>\n<meta property=\"og:description\" content=\"Learn how to use the Data Connection Registry in IRI Workbench to manage your RDB connections for ETL, data classification, data masking, etc.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-03T12:38:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-14T21:27:23+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/fiber-optic-connect.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1110\" \/>\n\t<meta property=\"og:image:height\" content=\"740\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sharon Hewitt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sharon Hewitt\" \/>\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\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/\"},\"author\":{\"name\":\"Sharon Hewitt\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/18c4f34270c95345ba1274daad4ed795\"},\"headline\":\"Using the IRI Workbench Data Connection Registry\",\"datePublished\":\"2016-06-03T12:38:39+00:00\",\"dateModified\":\"2024-08-14T21:27:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/\"},\"wordCount\":647,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/fiber-optic-connect.jpg\",\"keywords\":[\"add\",\"Authentication\",\"Data Connection Registry\",\"Data Source Administrator\",\"Data Tools Platform\",\"database connections\",\"DSN\",\"DTP Mapping\",\"IRI Workbench\",\"JDBC\",\"modify\",\"ODBC\",\"remove\",\"view\",\"xml\"],\"articleSection\":[\"IRI Workbench\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/\",\"url\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/\",\"name\":\"Using the IRI Workbench Data Connection Registry - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/fiber-optic-connect.jpg\",\"datePublished\":\"2016-06-03T12:38:39+00:00\",\"dateModified\":\"2024-08-14T21:27:23+00:00\",\"description\":\"Learn how to use the Data Connection Registry in IRI Workbench to manage your RDB connections for ETL, data classification, data masking, etc.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/fiber-optic-connect.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/fiber-optic-connect.jpg\",\"width\":1110,\"height\":740,\"caption\":\"fiber optic connection\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using the IRI Workbench Data Connection Registry\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.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:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/18c4f34270c95345ba1274daad4ed795\",\"name\":\"Sharon Hewitt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bd823330fbdcccbe30b856710edc3f94?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/bd823330fbdcccbe30b856710edc3f94?s=96&d=blank&r=g\",\"caption\":\"Sharon Hewitt\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/sharonh\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Using the IRI Workbench Data Connection Registry - IRI","description":"Learn how to use the Data Connection Registry in IRI Workbench to manage your RDB connections for ETL, data classification, data masking, 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.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/","og_locale":"en_US","og_type":"article","og_title":"Using the IRI Workbench Data Connection Registry","og_description":"Learn how to use the Data Connection Registry in IRI Workbench to manage your RDB connections for ETL, data classification, data masking, etc.","og_url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/","og_site_name":"IRI","article_published_time":"2016-06-03T12:38:39+00:00","article_modified_time":"2024-08-14T21:27:23+00:00","og_image":[{"width":1110,"height":740,"url":"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/fiber-optic-connect.jpg","type":"image\/jpeg"}],"author":"Sharon Hewitt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sharon Hewitt","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/"},"author":{"name":"Sharon Hewitt","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/18c4f34270c95345ba1274daad4ed795"},"headline":"Using the IRI Workbench Data Connection Registry","datePublished":"2016-06-03T12:38:39+00:00","dateModified":"2024-08-14T21:27:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/"},"wordCount":647,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/fiber-optic-connect.jpg","keywords":["add","Authentication","Data Connection Registry","Data Source Administrator","Data Tools Platform","database connections","DSN","DTP Mapping","IRI Workbench","JDBC","modify","ODBC","remove","view","xml"],"articleSection":["IRI Workbench"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/","url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/","name":"Using the IRI Workbench Data Connection Registry - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/fiber-optic-connect.jpg","datePublished":"2016-06-03T12:38:39+00:00","dateModified":"2024-08-14T21:27:23+00:00","description":"Learn how to use the Data Connection Registry in IRI Workbench to manage your RDB connections for ETL, data classification, data masking, etc.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/fiber-optic-connect.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/fiber-optic-connect.jpg","width":1110,"height":740,"caption":"fiber optic connection"},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using the IRI Workbench Data Connection Registry"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.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:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/18c4f34270c95345ba1274daad4ed795","name":"Sharon Hewitt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/bd823330fbdcccbe30b856710edc3f94?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bd823330fbdcccbe30b856710edc3f94?s=96&d=blank&r=g","caption":"Sharon Hewitt"},"url":"https:\/\/www.iri.com\/blog\/author\/sharonh\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/06\/fiber-optic-connect.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9722"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=9722"}],"version-history":[{"count":25,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9722\/revisions"}],"predecessor-version":[{"id":17901,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9722\/revisions\/17901"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/11813"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=9722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=9722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=9722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}