{"id":13971,"date":"2020-07-24T17:11:23","date_gmt":"2020-07-24T21:11:23","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=13971"},"modified":"2024-07-17T14:40:01","modified_gmt":"2024-07-17T18:40:01","slug":"connecting-to-informix-in-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/","title":{"rendered":"Connecting Informix to IRI (IDS12 DB in IRI Workbench)"},"content":{"rendered":"<p>This article documents the database connectivity tools and configurations necessary in <a href=\"https:\/\/www.iri.com\/products\/workbench\">IRI Workbench<\/a> and 64-bit CoSort-compatible runtime environments to work with 64-bit <a href=\"https:\/\/www.ibm.com\/products\/informix\">Informix<\/a> Dynamic Server (IDS) v12 table sources and targets. As you will see, these steps track the same way as other RDBMS connections we\u2019ve documented in this blog, including: <a href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-ms-sql-iri-workbench\/\">MS SQL<\/a>, <a href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-iri-software-oracle\/\">Oracle<\/a>, <a href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connect-to-postgresql-in-workbench\/\">PostgreSQL<\/a>, <a href=\"https:\/\/www.iri.com\/blog\/data-protection\/connecting-masking-data-salesforce\/\">Salesforce<\/a>, <a href=\"https:\/\/www.iri.com\/blog\/etl\/connecting-snowflake-db-iri-workbench\/\">Snowflake<\/a>, and <a href=\"https:\/\/www.iri.com\/blog\/vldb-operations\/iri-workbench-teradata\/\">Teradata<\/a>.<\/p>\n<p>In each case, a JDBC connection is necessary to support visual browsing, and metadata exchange with the Data Source Explorer view and top toolbar wizards in, IRI Workbench. An ODBC connection is needed to support data transfer between the database and the <a href=\"https:\/\/www.iri.com\/products\/cosort\/sortcl\">SortCL<\/a> engine that runs IRI Voracity, CoSort, FieldShield, NextForm, and RowGen jobs. <a href=\"https:\/\/www.iri.com\/blog\/data-protection\/darkshield-relational-databases\/\">DarkShield<\/a>, however, only requires a JDBC connection.<\/p>\n<h5><b>Prerequisites<\/b><\/h5>\n<ul>\n<li>IRI Workbench<\/li>\n<li>64-bit install of the IRI Voracity\/CoSort back-end for Windows (in this case), Linux or another IRI-supported flavor of Unix. Note that if you use a 32-bit version of ODBC, you will need to request a 32-bit CoSort archive instead.<\/li>\n<li>Informix Client Software Development Kit Version 4.10 (CSDK) 64 bits. See its requirements <a href=\"https:\/\/www.ibm.com\/support\/pages\/informix-client-software-development-kit-client-sdk-and-informix-connect-system-requirements\">here<\/a>.<\/li>\n<\/ul>\n<h5><b>Step 1. Establish the ODBC Connection<\/b><\/h5>\n<p>Generate DSN (ODBC) towards Informix IDS 12 64-bit database.<\/p>\n<p>For example, in Windows 10, after installing IDS and CSDK components, launch the ODBC Data Source Administrator (64-bits) from the Start menu. This was performed on a computer at SysViewSoft S.A. de C.V., the IRI partner in Mexico.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image1.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13976 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image1.png\" alt=\"\" width=\"650\" height=\"484\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image1.png 709w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image1-300x223.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<p>Select the Informix driver and click Next to complete the tabbed configuration options as follows:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image2.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13977 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image2.png\" alt=\"\" width=\"651\" height=\"567\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image2.png 658w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image2-300x261.png 300w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/a><\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image3.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13978 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image3.png\" alt=\"\" width=\"649\" height=\"565\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image3.png 658w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image3-300x261.png 300w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/a><\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image4.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13979 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image4.png\" alt=\"\" width=\"650\" height=\"566\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image4.png 658w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image4-300x261.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image5.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13980 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image5.png\" alt=\"\" width=\"650\" height=\"566\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image5.png 658w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image5-300x261.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<p>Finally, from the Connection tab, click Apply &amp; Test Connection. It should display a confirmation:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13981 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image6.png\" alt=\"\" width=\"383\" height=\"228\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image6.png 383w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image6-300x179.png 300w\" sizes=\"(max-width: 383px) 100vw, 383px\" \/><\/a><\/p>\n<p>If a failure message is displayed instead, contact your DBA and\/or network administrator for help.<\/p>\n<h5><b>Step 2. Establish the JDBC Connection<\/b><\/h5>\n<p>Begin in the Data Source Explorer (DSE) view in IRI Workbench. If you do not see that pane open, click Window &gt; Perspective &gt; Reset Perspective. Click on the New Connection Profile Icon in the DSE to bring up the list of default data sources:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13982 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png\" alt=\"\" width=\"651\" height=\"555\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png 855w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7-300x256.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7-768x655.png 768w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/a><\/p>\n<p>Select Infomix, name the database connection if desired, and click Next to add your new driver:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image8.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13983 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image8.png\" alt=\"\" width=\"651\" height=\"555\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image8.png 855w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image8-300x256.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image8-768x655.png 768w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/a><\/p>\n<p>Once you click the Add icon above, from the Name\/Type tab (below), you can select a version:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image9.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13984 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image9.png\" alt=\"\" width=\"650\" height=\"615\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image9.png 756w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image9-300x284.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<p>For IDS 12, I selected <i>Other Driver, Informix 10.0<\/i>, for compatibility with IDS 12.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image10.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13985 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image10.png\" alt=\"\" width=\"651\" height=\"616\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image10.png 756w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image10-300x284.png 300w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/a><\/p>\n<p>Next in the JAR List tab, remove any existing .jar file and click Add JAR\/ZIP \u2026 to specify the right one.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image11.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13986 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image11.png\" alt=\"\" width=\"650\" height=\"615\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image11.png 756w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image11-300x284.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<p>Browse to the ifxjdbc.jar installed with the Informix CSDK and click the Properties tab to specify your connection details; for example,<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image12.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13988 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image12-1024x596.png\" alt=\"\" width=\"840\" height=\"489\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image12-1024x596.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image12-300x175.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image12-768x447.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image12.png 1228w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><\/a><\/p>\n<p>Here is how I created my URL connection via JDBC to IDS 12.<\/p>\n<p>Note that the syntax is:<\/p>\n<pre><b>jdbc: informix-sqli: \/\/ &lt;serverfisico&gt;: &lt;puertoconexion&gt; \/ &lt;nombrebase&gt;: INFORMIXSERVER = &lt; serverinformix&gt;; user = &lt;base user&gt;; password = &lt;paswdbase&gt;;<\/b><\/pre>\n<p>where:<\/p>\n<pre><b>serverfisico <\/b>= server where informix is \u200b\u200binstalled (name or ip).\r\n\r\n<b>connectionport<\/b> = port found in file (services)\r\n                 On Windows, see C:\\Windows\\System32\\drivers\\etc\\ services\r\n                 On\u00a0 Linux, Solaris, HP-UX, or AIX, see \/etc\/services\r\n\u00a0\u00a0\u00a0\u00a0\u00a0            For example, for the Informix server name (ol_informix1210), the services file might contain:\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0           ol_informix1210 \u00a0 \u00a0 \u00a0   9088 \/ tcp\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0                dr_informix1210 \u00a0 \u00a0 \u00a0\u00a0\u00a0 9089 \/ tcp\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0                lo_informix1210 \u00a0 \u00a0 \u00a0\u00a0\u00a0 9090 \/ tcp\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0           ol_informix1210_json\u00a0\u00a0 27017 \/ tcp\u00a0\u00a0\u00a0 #JSON listener for ol_informix1210<\/pre>\n<p>The most logical thing to select would seem to be port 9088, but it is not; you must use the port for the <i>third <\/i>service; i.e., lo_informix1210 on port 9090.<\/p>\n<pre><b>basename <\/b>= name of the database in informix that you want to access.\r\n\r\n<b>serverinformix <\/b>= name of the internal informix server.\r\n\r\n<b>baseuser <\/b>= database user ID\r\n\r\n<b>paswdbase <\/b>= access password<\/pre>\n<p>Example URL:<\/p>\n<pre>jdbc: informix-sqli: \/\/ localhost: 9090 \/ scott: INFORMIXSERVER = ol_informix1210; user = informix; password = Svs123;<\/pre>\n<p>Click OK once you have completed the details in this section. You can then test your connection as follows:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image13.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13987 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image13.png\" alt=\"\" width=\"649\" height=\"553\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image13.png 855w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image13-300x256.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image13-768x655.png 768w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/a><\/p>\n<p>Check the Save password option, and click Test Connection.\u00a0 It should display a confirmation:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image14.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13989 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image14.png\" alt=\"\" width=\"602\" height=\"152\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image14.png 856w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image14-300x76.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image14-768x194.png 768w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/a><\/p>\n<p>If a failure message is displayed instead, contact your DBA and\/or network administrator for help.<\/p>\n<h5><b>Step 3. Register the Connection<\/b><b><br \/>\n<\/b><\/h5>\n<p>From the Workbench Windows menu, select Preferences. Once in Preferences, select IRI &gt; Data Connection Registry to open this dialog:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image15.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-13990 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/07\/Informix-image15-1024x642.png\" alt=\"\" width=\"649\" height=\"407\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image15-1024x642.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image15-300x188.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image15-768x481.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image15.png 1061w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/a><\/p>\n<p>Select the ODBC connection created previously (INFORMIXW) and the (Data Source Explorer) connection profile created via JDBC for Informix IDS 12. Click Apply and Close to finish.<\/p>\n<p>At this point, your connections to Informix are confirmed the IRI Workbench integration is complete. You and ready use Informix with IRI Voracity for data discovery, data integration, data migration, data masking, data quality, data wrangling, and test data. Use the job creation wizards in IRI Workbench, and run your SortCL-compatible job scripts from there or the command-line.<\/p>\n<p>If you need help setting up or making use of your Informix database connection in IRI Workbench, contact your <a href=\"https:\/\/www.iri.com\/partners\/resellers\">IRI representative<\/a> or <a href=\"mailto:support@iri.com\">support@iri.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article documents the database connectivity tools and configurations necessary in IRI Workbench and 64-bit CoSort-compatible runtime environments to work with 64-bit Informix Dynamic Server (IDS) v12 table sources and targets. As you will see, these steps track the same way as other RDBMS connections we\u2019ve documented in this blog, including: MS SQL, Oracle, PostgreSQL,<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/\" title=\"Connecting Informix to IRI (IDS12 DB in IRI Workbench)\">Read More<\/a><\/div>\n","protected":false},"author":130,"featured_media":13982,"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,31,776,91,29,3],"tags":[1480,1854,1852,1853,1850,1851,546,1204,789,850,956,75],"class_list":["post-13971","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-data-migration","category-etl","category-iri-workbench","category-test-data","category-vldb-operations","tag-informix","tag-informix-data-integration","tag-informix-data-masking","tag-informix-data-migration","tag-informix-jdbc","tag-informix-odbc","tag-iri-cosort","tag-iri-sortcl","tag-iri-voracity","tag-iri-workbench","tag-jdbc","tag-odbc"],"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 Informix to IRI (IDS12 DB in IRI Workbench) - IRI<\/title>\n<meta name=\"description\" content=\"This article documents the Informix database connection steps. Connect Informix to IRI Workbench and CoSort for Informix data integration.\" \/>\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\/connecting-to-informix-in-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecting Informix to IRI (IDS12 DB in IRI Workbench)\" \/>\n<meta property=\"og:description\" content=\"This article documents the Informix database connection steps. Connect Informix to IRI Workbench and CoSort for Informix data integration.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-24T21:11:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-17T18:40:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png\" \/>\n\t<meta property=\"og:image:width\" content=\"855\" \/>\n\t<meta property=\"og:image:height\" content=\"729\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Carlos Hernandez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Carlos Hernandez\" \/>\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.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/\"},\"author\":{\"name\":\"Carlos Hernandez\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/bb6711d82a41b46039f02972895e8937\"},\"headline\":\"Connecting Informix to IRI (IDS12 DB in IRI Workbench)\",\"datePublished\":\"2020-07-24T21:11:23+00:00\",\"dateModified\":\"2024-07-17T18:40:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/\"},\"wordCount\":653,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png\",\"keywords\":[\"Informix\",\"Informix data integration\",\"Informix data masking\",\"Informix data migration\",\"Informix JDBC\",\"Informix ODBC\",\"IRI CoSort\",\"IRI SortCL\",\"IRI Voracity\",\"IRI Workbench\",\"JDBC\",\"ODBC\"],\"articleSection\":[\"Data Masking\/Protection\",\"Data Migration\",\"ETL\",\"IRI Workbench\",\"Test Data\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/\",\"name\":\"Connecting Informix to IRI (IDS12 DB in IRI Workbench) - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png\",\"datePublished\":\"2020-07-24T21:11:23+00:00\",\"dateModified\":\"2024-07-17T18:40:01+00:00\",\"description\":\"This article documents the Informix database connection steps. Connect Informix to IRI Workbench and CoSort for Informix data integration.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png\",\"width\":855,\"height\":729},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connecting Informix to IRI (IDS12 DB 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\/bb6711d82a41b46039f02972895e8937\",\"name\":\"Carlos Hernandez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/045d4ef7aa5f3ccb3eec07531171f1a1?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/045d4ef7aa5f3ccb3eec07531171f1a1?s=96&d=blank&r=g\",\"caption\":\"Carlos Hernandez\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/carlosh\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Connecting Informix to IRI (IDS12 DB in IRI Workbench) - IRI","description":"This article documents the Informix database connection steps. Connect Informix to IRI Workbench and CoSort for Informix data integration.","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\/connecting-to-informix-in-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Connecting Informix to IRI (IDS12 DB in IRI Workbench)","og_description":"This article documents the Informix database connection steps. Connect Informix to IRI Workbench and CoSort for Informix data integration.","og_url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/","og_site_name":"IRI","article_published_time":"2020-07-24T21:11:23+00:00","article_modified_time":"2024-07-17T18:40:01+00:00","og_image":[{"width":855,"height":729,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png","type":"image\/png"}],"author":"Carlos Hernandez","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Carlos Hernandez","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/"},"author":{"name":"Carlos Hernandez","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/bb6711d82a41b46039f02972895e8937"},"headline":"Connecting Informix to IRI (IDS12 DB in IRI Workbench)","datePublished":"2020-07-24T21:11:23+00:00","dateModified":"2024-07-17T18:40:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/"},"wordCount":653,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png","keywords":["Informix","Informix data integration","Informix data masking","Informix data migration","Informix JDBC","Informix ODBC","IRI CoSort","IRI SortCL","IRI Voracity","IRI Workbench","JDBC","ODBC"],"articleSection":["Data Masking\/Protection","Data Migration","ETL","IRI Workbench","Test Data","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/","url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/","name":"Connecting Informix to IRI (IDS12 DB in IRI Workbench) - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png","datePublished":"2020-07-24T21:11:23+00:00","dateModified":"2024-07-17T18:40:01+00:00","description":"This article documents the Informix database connection steps. Connect Informix to IRI Workbench and CoSort for Informix data integration.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png","width":855,"height":729},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-informix-in-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Connecting Informix to IRI (IDS12 DB 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\/bb6711d82a41b46039f02972895e8937","name":"Carlos Hernandez","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/045d4ef7aa5f3ccb3eec07531171f1a1?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/045d4ef7aa5f3ccb3eec07531171f1a1?s=96&d=blank&r=g","caption":"Carlos Hernandez"},"url":"https:\/\/www.iri.com\/blog\/author\/carlosh\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/07\/Informix-image7.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/13971"}],"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\/130"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=13971"}],"version-history":[{"count":10,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/13971\/revisions"}],"predecessor-version":[{"id":17769,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/13971\/revisions\/17769"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/13982"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=13971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=13971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=13971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}