{"id":15040,"date":"2021-09-23T12:36:12","date_gmt":"2021-09-23T16:36:12","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=15040"},"modified":"2024-09-23T13:48:31","modified_gmt":"2024-09-23T17:48:31","slug":"connecting-to-vertica-in-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/","title":{"rendered":"Connecting to Vertica in IRI Workbench"},"content":{"rendered":"<p><i>Like other articles in this blog on the connection and configuration of relational databases with the <\/i><a href=\"https:\/\/www.iri.com\/products\/voracity\"><i>IRI Voracity<\/i><\/a><i> data management platform &#8212; and its ecosystem products: CoSort, NextForm, FieldShield, DarkShield and RowGen &#8212; this article details how to reach Vertica sources. It describes the ODBC and JDBC connections and configurations necessary to register Vertica with the <\/i><a href=\"https:\/\/www.iri.com\/products\/cosort\/sortcl\"><i>SortCL<\/i><\/a><i> engine and <\/i><a href=\"https:\/\/www.iri.com\/products\/workbench\"><i>IRI Workbench<\/i><\/a><i> job design client common to most IRI software processing and protecting data in high-performance SQL databases and data analytics platforms.<\/i><\/p>\n<h6><b>Interoperability Prerequisites<\/b><\/h6>\n<p>To support Vertica database integration using the IRI back-end SortCL data manipulation engine written in C, an <i>ODBC <\/i>connection is required. To support visual table browsing and metadata interchange in the IRI Workbench GUI, a <i>JDBC <\/i>connection is required. Those two connection types will need to be registered in IRI Workbench to map between them. This article explains these steps.<\/p>\n<p>Note that if IRI DarkShield with Vertica is used for finding and masking PII or other sensitive data in structured, semi- and\/or unstructured columns per <a href=\"https:\/\/www.iri.com\/blog\/data-protection\/darkshield-relational-databases\">this<\/a> article, or through the DarkShield <a href=\"https:\/\/www.iri.com\/blog\/data-protection\/iri-darkshield-rdb-rpc-api\/\">RDB API<\/a>, only JDBC or another connection protocol would be needed.<\/p>\n<h6><b>JDBC<\/b><\/h6>\n<p>Micro Focus offers a <a href=\"https:\/\/www.vertica.com\/download\/vertica\/client-drivers\/\">JDBC driver<\/a> for Vertica. Download, extract and make a note of the installation location.<\/p>\n<p>In Workbench, in the <i>Data Source Explorer<\/i>, create a new connection profile. Select <i>Vertica<\/i>. Change the name and click <b>Next<\/b>.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2021\/10\/vertica-connection-profile.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15044 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/10\/vertica-connection-profile.png\" alt=\"\" width=\"450\" height=\"511\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertica-connection-profile.png 511w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertica-connection-profile-264x300.png 264w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<p>On the next page, click <b>New Driver<\/b> <b>Definition<\/b> next to the drop down. On the <i>Name\/Type<\/i> tab, click the database version and enter a custom driver name.<\/p>\n<p>On the <i>JAR List<\/i> tab, click <i>vertica-jdbc-11.0.0-0.jar <\/i>and click <b>Edit JAR\/Zip<\/b>. Navigate to the location of the JDBC driver. Select <i>vertica-jdbc-11.0.0-0.jar<\/i>.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2021\/10\/vertical-driver-details-jar.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15045 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/10\/vertical-driver-details-jar.png\" alt=\"\" width=\"489\" height=\"340\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-driver-details-jar.png 488w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-driver-details-jar-300x208.png 300w\" sizes=\"(max-width: 489px) 100vw, 489px\" \/><\/a><\/p>\n<p>On the <i>Properties <\/i>tab, in the URL, replace <i>host:port\/database<\/i> with the proper information. Enter the database name. Optionally, enter the user name and click <b>OK<\/b>.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2021\/10\/vertical-driver-details-properties.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15046 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/10\/vertical-driver-details-properties.png\" alt=\"\" width=\"499\" height=\"355\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-driver-details-properties.png 566w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-driver-details-properties-300x214.png 300w\" sizes=\"(max-width: 499px) 100vw, 499px\" \/><\/a><\/p>\n<p>Back on the New Connection Profile page, enter a password if applicable. The driver does not save the password but it is required to test the connection if authentication is set up on the database. Test the connection to make sure the settings are correct. Then, click <b>Finish<\/b>.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2021\/10\/vertical-connection-properties.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15047 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/10\/vertical-connection-properties.png\" alt=\"\" width=\"501\" height=\"384\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-connection-properties.png 730w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-connection-properties-300x230.png 300w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/><\/a><\/p>\n<p>The tables are now visible under the database and schema in the <i>Data Source Explorer<\/i>.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15048 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer.png\" alt=\"\" width=\"339\" height=\"427\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer.png 339w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-238x300.png 238w\" sizes=\"(max-width: 339px) 100vw, 339px\" \/><\/a><\/p>\n<p>The system tables may be visible here. However, following the instructions from <a href=\"https:\/\/www.iri.com\/blog\/vldb-operations\/table-filtering-iri-workbench\/\">this<\/a> article can filter out those tables from the connection.<\/p>\n<h6><b>ODBC<\/b><\/h6>\n<p>These instructions are based on a Windows OS. If Workbench is installed on another operating system, please research the applicable instructions for that system.<\/p>\n<p>Micro Focus offers an <a href=\"https:\/\/www.vertica.com\/download\/vertica\/client-drivers\/\">ODBC driver<\/a> for Vertica. Download, extract and make a note of the installation location.<\/p>\n<p>Open ODBC Data Source Administrator and select <b>Add<\/b>. Using <i>Vertica<\/i>, enter the DSN name, database, server, port, user, and password. Check the other tabs and add applicable options. Click <b>Test Connect<\/b> and then <b>OK<\/b>.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2021\/10\/vertical-ODBC-DSN-configuration.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15049 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/10\/vertical-ODBC-DSN-configuration.png\" alt=\"\" width=\"395\" height=\"699\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-ODBC-DSN-configuration.png 404w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-ODBC-DSN-configuration-170x300.png 170w\" sizes=\"(max-width: 395px) 100vw, 395px\" \/><\/a><\/p>\n<h6><b>Data Connection Registry<\/b><\/h6>\n<p>In Workbench, open <b>Preferences &gt; IRI &gt; Data Connection Registry<\/b>. If the new Vertica DSN is not visible, click <b>Refresh<\/b>. Then, double-click the entry to edit it. Enter a schema filter if desired. If authentication is set up on the database, enter the user and password here to avoid prompts for the password when running the scripts in Workbench. In <i>Mapping<\/i>, select the JDBC connection set up previously. Click <b>OK<\/b>.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2021\/10\/vertica-data-connection-registry.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15050 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2021\/10\/vertica-data-connection-registry.png\" alt=\"\" width=\"497\" height=\"557\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertica-data-connection-registry.png 511w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertica-data-connection-registry-268x300.png 268w\" sizes=\"(max-width: 497px) 100vw, 497px\" \/><\/a><\/p>\n<p>The Vertica database can now be used in wizards throughout Workbench. Note that some functionality is unavailable (i.e. automatic creation of create table statements) within some wizards. There will be a pop-up displayed if this is the case.<\/p>\n<p>If you need help establishing or verifying the Vertica connection with <a href=\"https:\/\/www.iri.com\/products\">IRI software<\/a>, contact <a href=\"mailto:support@iri.com\">support@iri.com<\/a>.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Like other articles in this blog on the connection and configuration of relational databases with the IRI Voracity data management platform &#8212; and its ecosystem products: CoSort, NextForm, FieldShield, DarkShield and RowGen &#8212; this article details how to reach Vertica sources. It describes the ODBC and JDBC connections and configurations necessary to register Vertica with<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/\" title=\"Connecting to Vertica in IRI Workbench\">Read More<\/a><\/div>\n","protected":false},"author":43,"featured_media":15052,"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,776,91,3],"tags":[968,1915,1305,1913,1912,1204,850,956,507,75,1545,1911,1916,1914],"class_list":["post-15040","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-etl","category-iri-workbench","category-vldb-operations","tag-data-management-platform","tag-data-mapping-tools","tag-data-masking-tools","tag-database-management-solutions","tag-high-performance-sql-databases","tag-iri-sortcl","tag-iri-workbench","tag-jdbc","tag-micro-focus","tag-odbc","tag-vertica","tag-vertica-database-integration","tag-vertica-tools","tag-vertical-performance-tuning"],"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>Connecting to Vertica in IRI Workbench - IRI<\/title>\n<meta name=\"description\" content=\"Learn how to connect your Vertica databases as sources and targets to IRI Voracity data mapping and masking tools in the IRI Workbench IDE.\" \/>\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\/vldb-operations\/connecting-to-vertica-in-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecting to Vertica in IRI Workbench\" \/>\n<meta property=\"og:description\" content=\"Learn how to connect your Vertica databases as sources and targets to IRI Voracity data mapping and masking tools in the IRI Workbench IDE.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-23T16:36:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-23T17:48:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-thumbnail.png\" \/>\n\t<meta property=\"og:image:width\" content=\"337\" \/>\n\t<meta property=\"og:image:height\" content=\"214\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Claudia Irvine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Claudia Irvine\" \/>\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:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/\"},\"author\":{\"name\":\"Claudia Irvine\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0\"},\"headline\":\"Connecting to Vertica in IRI Workbench\",\"datePublished\":\"2021-09-23T16:36:12+00:00\",\"dateModified\":\"2024-09-23T17:48:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/\"},\"wordCount\":604,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-thumbnail.png\",\"keywords\":[\"data management platform\",\"data mapping tools\",\"data masking tools\",\"database management solutions\",\"high-performance SQL databases\",\"IRI SortCL\",\"IRI Workbench\",\"JDBC\",\"micro focus\",\"ODBC\",\"Vertica\",\"vertica database integration\",\"Vertica tools\",\"vertical performance tuning\"],\"articleSection\":[\"Data Masking\/Protection\",\"ETL\",\"IRI Workbench\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/\",\"name\":\"Connecting to Vertica in IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-thumbnail.png\",\"datePublished\":\"2021-09-23T16:36:12+00:00\",\"dateModified\":\"2024-09-23T17:48:31+00:00\",\"description\":\"Learn how to connect your Vertica databases as sources and targets to IRI Voracity data mapping and masking tools in the IRI Workbench IDE.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-thumbnail.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-thumbnail.png\",\"width\":337,\"height\":214},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connecting to Vertica in IRI Workbench\"}]},{\"@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\/72af50bbb317610e193e96392081f9b0\",\"name\":\"Claudia Irvine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g\",\"caption\":\"Claudia Irvine\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/claudiai\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Connecting to Vertica in IRI Workbench - IRI","description":"Learn how to connect your Vertica databases as sources and targets to IRI Voracity data mapping and masking tools in the IRI Workbench IDE.","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\/vldb-operations\/connecting-to-vertica-in-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Connecting to Vertica in IRI Workbench","og_description":"Learn how to connect your Vertica databases as sources and targets to IRI Voracity data mapping and masking tools in the IRI Workbench IDE.","og_url":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/","og_site_name":"IRI","article_published_time":"2021-09-23T16:36:12+00:00","article_modified_time":"2024-09-23T17:48:31+00:00","og_image":[{"width":337,"height":214,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-thumbnail.png","type":"image\/png"}],"author":"Claudia Irvine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Claudia Irvine","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/"},"author":{"name":"Claudia Irvine","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0"},"headline":"Connecting to Vertica in IRI Workbench","datePublished":"2021-09-23T16:36:12+00:00","dateModified":"2024-09-23T17:48:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/"},"wordCount":604,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-thumbnail.png","keywords":["data management platform","data mapping tools","data masking tools","database management solutions","high-performance SQL databases","IRI SortCL","IRI Workbench","JDBC","micro focus","ODBC","Vertica","vertica database integration","Vertica tools","vertical performance tuning"],"articleSection":["Data Masking\/Protection","ETL","IRI Workbench","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/","url":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/","name":"Connecting to Vertica in IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-thumbnail.png","datePublished":"2021-09-23T16:36:12+00:00","dateModified":"2024-09-23T17:48:31+00:00","description":"Learn how to connect your Vertica databases as sources and targets to IRI Voracity data mapping and masking tools in the IRI Workbench IDE.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-thumbnail.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-thumbnail.png","width":337,"height":214},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/connecting-to-vertica-in-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Connecting to Vertica in IRI Workbench"}]},{"@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\/72af50bbb317610e193e96392081f9b0","name":"Claudia Irvine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g","caption":"Claudia Irvine"},"url":"https:\/\/www.iri.com\/blog\/author\/claudiai\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/10\/vertical-in-data-source-explorer-thumbnail.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15040"}],"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\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=15040"}],"version-history":[{"count":8,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15040\/revisions"}],"predecessor-version":[{"id":17896,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15040\/revisions\/17896"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/15052"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=15040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=15040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=15040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}