{"id":10764,"date":"2016-12-20T10:29:27","date_gmt":"2016-12-20T15:29:27","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=10764"},"modified":"2023-03-10T14:46:28","modified_gmt":"2023-03-10T19:46:28","slug":"creating-executing-sql-statements-in-iri-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/","title":{"rendered":"Creating &#038; Executing SQL Statements in IRI Workbench"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Among the many database-centric features in <\/span><a href=\"http:\/\/www.iri.com\/products\/workbench\"><span style=\"font-weight: 400;\">IRI Workbench<\/span><\/a><span style=\"font-weight: 400;\"> is the ability to create, modify, and execute SQL statements manually or graphically. These \u201cSQL scrap-booking\u201d features are available through the free Data Tools Platform (<\/span><a href=\"http:\/\/wiki.eclipse.org\/Connectivity\"><span style=\"font-weight: 400;\">DTP<\/span><\/a><span style=\"font-weight: 400;\">) plug-in for Eclipse, which also supports<em> IRI<\/em> job wizards for database:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">profiling, searching, classification, E-R diagramming, and integrity checking<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">integration, including ETL, pivoting, slowly changing dimensions, and change data capture<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">column masking, including format-preserving encryption, redaction, and pseudonymization<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">subsetting, test data generation, and bulk loading<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">migration, replication, and offline reorgs<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">To use the cross-platform(!) SQL and IRI facilities in Workbench, you must first <\/span><span style=\"font-weight: 400;\"><a href=\"http:\/\/www.iri.com\/assets\/uploads\/editor\/DB%20Setup.pdf\">make a JDBC connection<\/a><span id='easy-footnote-1-10764' class='easy-footnote-margin-adjust'><\/span><span class='easy-footnote'><a href='https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#easy-footnote-bottom-1-10764' title='You will also need an &lt;em&gt;ODBC&lt;\/em&gt; connection for data movement; i.e., to process database or other JDBC-viewed data directly in IRI software. See &lt;a href=&quot;http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-iri-workbench-data-connection-registry\/&quot;&gt;this article&lt;\/a&gt; and contact &lt;a href=&quot;mailto:support@iri.com&quot;&gt;support@iri.com&lt;\/a&gt; if you need help with that.'><sup>1<\/sup><\/a><\/span><\/span><span style=\"font-weight: 400;\">\u00a0to your database from the DTP\u2019s <\/span><b>Data Source Explorer<\/b><span style=\"font-weight: 400;\"> view. Once you are connected, you will be able to see your tables, and work with them with Eclipse or IRI tooling. This article focuses only on the use of DTP features for creating and executing SQL statements.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">There are two ways to create a SQL file:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">From within a project, click <\/span><b>File<\/b><span style=\"font-weight: 400;\"> on the menu bar -&gt; <\/span><b>New<\/b><span style=\"font-weight: 400;\"> -&gt; <\/span><b>File<\/b><span style=\"font-weight: 400;\">. In the <\/span><b>File Name<\/b><span style=\"font-weight: 400;\"> field, type in the file name, making sure it has a <\/span><i><span style=\"font-weight: 400;\">.sql<\/span><\/i><span style=\"font-weight: 400;\"> extension, then click <\/span><b>Finish<\/b><span style=\"font-weight: 400;\">. \u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>Data Source Explorer<\/b><span style=\"font-weight: 400;\">, right-click on the connection name -&gt; click <\/span><b>Open SQL Scrapbook<\/b><span style=\"font-weight: 400;\">. This will have the name \u201cSQL Scrapbook <\/span><i><span style=\"font-weight: 400;\">n\u201d<\/span><\/i><span style=\"font-weight: 400;\">, where <\/span><i><span style=\"font-weight: 400;\">n<\/span><\/i><span style=\"font-weight: 400;\"> is the number of the next scrapbook file in sequence if any previous files were not saved. Then you must select a project where the file will be saved, give the file a name, and click <\/span><b>Finish<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">For each method, a new file opens in the editor with an upper section for defining the <\/span><b>Connection profile <\/b><span style=\"font-weight: 400;\">for the database you are working with. The <\/span><b>Connection profile<\/b><span style=\"font-weight: 400;\"> has three menus:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><b>Type<\/b><span style=\"font-weight: 400;\"> lists the installed driver types<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Name<\/b><span style=\"font-weight: 400;\"> lists the name of defined database connections<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Database<\/b><span style=\"font-weight: 400;\"> lists the name for the database instance<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Select the <\/span><b>Name<\/b><span style=\"font-weight: 400;\"> first, then the driver <\/span><b>Type<\/b><span style=\"font-weight: 400;\"> defined for the <\/span><b>Name<\/b><span style=\"font-weight: 400;\"> will automatically be selected. Once those are selected, the <\/span><b>Status<\/b><span style=\"font-weight: 400;\"> indicates if that profile is connected or active in IRI Workbench. To activate the connection, go to the <\/span><b>Data Source Explorer<\/b><span style=\"font-weight: 400;\">, right-click on the connection name, and click <\/span><b>Connect<\/b><span style=\"font-weight: 400;\">. The status will show <\/span><b>Connected<\/b><span style=\"font-weight: 400;\">. Now select the instance from the <\/span><b>Database<\/b><span style=\"font-weight: 400;\"> dropdown menu.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The IRI Workbench window below shows two SQL files at once: one with SQL statements for a MySQL database and the other for an Oracle database. You can have multiple unrelated SQL statements in a file, but you must make separate SQL files for different connections. When you are ready to execute the statements, highlight the desired statements -&gt; right-click -&gt; click <\/span><b>Execute Selected Text<\/b><span style=\"font-weight: 400;\">. To execute the entire file, right-click -&gt; click <\/span><b>Execute All<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For example, if we highlight just the <a href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/\">CREATE TABLE<\/a> \u00a0section in the file <\/span><i><span style=\"font-weight: 400;\">qa2_create.sql<\/span><\/i><span style=\"font-weight: 400;\">, we will create the table SG_TRANSACTIONS in our Oracle database. After execution, the <\/span><b>SQL Results<\/b><span style=\"font-weight: 400;\"> perspective has columns that show the <\/span><b>Status <\/b><span style=\"font-weight: 400;\">(<\/span><b>Succeeded<\/b><span style=\"font-weight: 400;\"> or <\/span><b>Failed<\/b><span style=\"font-weight: 400;\">), <\/span><b>Operation <\/b><span style=\"font-weight: 400;\">(the SQL operation that was executed), <\/span><b>Date<\/b><span style=\"font-weight: 400;\"> of execution, and <\/span><b>Connection Profile<\/b><span style=\"font-weight: 400;\"> for the operation. In the <\/span><b>Data Source Explorer<\/b><span style=\"font-weight: 400;\">, you can expand the connection until you see the newly created table and its columns.<br \/>\n<\/span><span style=\"font-weight: 400;\"><br \/>\n<a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10765\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png\" alt=\"Data Source Explorer in IRI Workbench\" width=\"600\" height=\"402\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png 624w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer-300x201.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\"><a href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/\">Tables you have created<\/a> and\/or altered are immediately available for use as sources and targets in IRI job scripts, and if you use a wizard to create those jobs, you can create the metadata definitions within the wizard or select an existing metadata file.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">IRI jobs connect to the tables via defined <\/span><i><span style=\"font-weight: 400;\">ODBC<\/span><\/i><span style=\"font-weight: 400;\"> connections with \/INFILE or \/OUTFILE=<\/span><i><span style=\"font-weight: 400;\">table definition<\/span><\/i><span style=\"font-weight: 400;\"> and \/PROCESS=ODBC statements. For example, you might use a wizard to generate a script like this:<\/span><\/p>\n<blockquote>\n<pre><b>\/INFILE<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\"><span style=\"color: #ff0000;\">\"NIGHTLY.SG_TRANSACTIONS;DSN=Oracle_qa2;UID=nightly;PWD=N321ghtly;\"<\/span>\r\n<\/span><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0<\/span><b>\/ALIAS<\/b><span style=\"font-weight: 400;\">=NIGHTLY_SG_TRANSACTIONS\r\n<\/span><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0<\/span><b>\/PROCESS<\/b><span style=\"font-weight: 400;\">=<\/span><b>ODBC\r\n<\/b><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0<\/span><b>\/FIELD<\/b><span style=\"font-weight: 400;\">=(ACCT_NUM, <\/span><b>TYPE<\/b><span style=\"font-weight: 400;\">=ASCII, <\/span><b>POSITION<\/b><span style=\"font-weight: 400;\">=1, <\/span><b>SEPARATOR<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">\"|\"<\/span><span style=\"font-weight: 400;\">, <\/span><b>EXT_FIELD<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400; color: #ff0000;\">\"ACCT_NUM\"<\/span><span style=\"font-weight: 400;\">)\r\n<\/span><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0<\/span><b>\/FIELD<\/b><span style=\"font-weight: 400;\">=(TRANSTYPE, <\/span><b>TYPE<\/b><span style=\"font-weight: 400;\">=ASCII, <\/span><b>POSITION<\/b><span style=\"font-weight: 400;\">=2, <\/span><b>SEPARATOR<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">\"|\"<\/span><span style=\"font-weight: 400;\">, <\/span><b>EXT_FIELD<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400; color: #ff0000;\">\"TRANSTYPE\"<\/span><span style=\"font-weight: 400;\">)\r\n<\/span><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0<\/span><b>\/FIELD<\/b><span style=\"font-weight: 400;\">=(TRANS_DATE, <\/span><b>TYPE<\/b><span style=\"font-weight: 400;\">=ISO_DATE, <\/span><b>POSITION<\/b><span style=\"font-weight: 400;\">=3, <\/span><b>SEPARATOR<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">\"|\"<\/span><span style=\"font-weight: 400;\">, <\/span><b>EXT_FIELD<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400; color: #ff0000;\">\"TRANS_DATE\"<\/span><span style=\"font-weight: 400;\">)\r\n<\/span><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0<\/span><b>\/FIELD<\/b><span style=\"font-weight: 400;\">=(TRANS_AMOUNT, <\/span><b>TYPE<\/b><span style=\"font-weight: 400;\">=NUMERIC, <\/span><b>POSITION<\/b><span style=\"font-weight: 400;\">=4, <\/span><b>SEPARATOR<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">\"|\"<\/span><span style=\"font-weight: 400;\">, <\/span><b>EXT_FIELD<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400; color: #ff0000;\">\"TRANS_AMOUNT\"<\/span><span style=\"font-weight: 400;\">)\r\n<\/span><b>\/REPORT\r\n<\/b><b>\/OUTFILE<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\"><span style=\"color: #ff0000;\">\"SG_TRANSACTIONS;DSN=Twister MySQL;\"<\/span>\r\n<\/span><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0<\/span><b>\/PROCESS<\/b><span style=\"font-weight: 400;\">=<\/span><b>ODBC\r\n<\/b><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0<\/span><b>\/FIELD<\/b><span style=\"font-weight: 400;\">=(ACCT_NUM, <\/span><b>TYPE<\/b><span style=\"font-weight: 400;\">=ASCII, <\/span><b>POSITION<\/b><span style=\"font-weight: 400;\">=1, <\/span><b>SEPARATOR<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">\"|\"<\/span><span style=\"font-weight: 400;\">, <\/span><b>EXT_FIELD<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400; color: #ff0000;\">\"ACCT_NUM\"<\/span><span style=\"font-weight: 400;\">)\r\n<\/span><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0<\/span><b>\/FIELD<\/b><span style=\"font-weight: 400;\">=(TRANSTYPE, <\/span><b>TYPE<\/b><span style=\"font-weight: 400;\">=ASCII, <\/span><b>POSITION<\/b><span style=\"font-weight: 400;\">=2, <\/span><b>SEPARATOR<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">\"|\"<\/span><span style=\"font-weight: 400;\">, <\/span><b>EXT_FIELD<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400; color: #ff0000;\">\"TRANSTYPE\"<\/span><span style=\"font-weight: 400;\">)\r\n<\/span><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0<\/span><b>\/FIELD<\/b><span style=\"font-weight: 400;\">=(TRANS_DATE, <\/span><b>TYPE<\/b><span style=\"font-weight: 400;\">=ISO_DATE, <\/span><b>POSITION<\/b><span style=\"font-weight: 400;\">=3, <\/span><b>SEPARATOR<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">\"|\"<\/span><span style=\"font-weight: 400;\">, <\/span><b>EXT_FIELD<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400; color: #ff0000;\">\"TRANS_DATE\"<\/span><span style=\"font-weight: 400;\">)\r\n<\/span><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0<\/span><b>\/FIELD<\/b><span style=\"font-weight: 400;\">=(TRANS_AMOUNT, <\/span><b>TYPE<\/b><span style=\"font-weight: 400;\">=NUMERIC, <\/span><b>POSITION<\/b><span style=\"font-weight: 400;\">=4, <\/span><b>SEPARATOR<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">\"|\"<\/span><span style=\"font-weight: 400;\">, <\/span><b>EXT_FIELD<\/b><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400; color: #ff0000;\">\"TRANS_AMOUNT\"<\/span><span style=\"font-weight: 400;\">)<\/span><\/pre>\n<\/blockquote>\n<p><span style=\"font-weight: 400;\">This job replicates data from an Oracle table to a table in MySQL. The EXT_FIELD is the name of the column in the table. This handles the cases where the field name and column name need to be different.<\/span><\/p>\n<p>You can also use the built-in scrapbook feature to build and modify queries in a graphical editor:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/sqlbuilder.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11416\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/sqlbuilder.png\" alt=\"\" width=\"500\" height=\"496\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/sqlbuilder.png 732w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/sqlbuilder-150x150.png 150w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/sqlbuilder-300x298.png 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>Execute the final query in this window or the editing page shown above.<\/p>\n<p>Once you have your saved statements or procedures in an .sql file, you can include them in a Voracity workflow like this one:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/devblog\/wp-content\/uploads\/2016\/12\/example-schematic-creating-executing-sql-statements.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11934\" src=\"http:\/\/www.iri.com\/devblog\/wp-content\/uploads\/2016\/12\/example-schematic-creating-executing-sql-statements.png\" alt=\"IRI Voracity workflow schematic\" width=\"863\" height=\"395\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/example-schematic-creating-executing-sql-statements.png 863w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/example-schematic-creating-executing-sql-statements-300x137.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/example-schematic-creating-executing-sql-statements-768x352.png 768w\" sizes=\"(max-width: 863px) 100vw, 863px\" \/><\/a><\/p>\n<p>You can insert one or more &#8220;SQL Command&#8221; items from the workflow design palette at any point(s) in your job. For more information about designing visual workflows in Voracity, see <a href=\"http:\/\/www.iri.com\/blog\/?s=flow+diagram\">these articles<\/a>.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Among the many database-centric features in IRI Workbench is the ability to create, modify, and execute SQL statements manually or graphically. These \u201cSQL scrap-booking\u201d features are available through the free Data Tools Platform (DTP) plug-in for Eclipse, which also supports IRI job wizards for database: profiling, searching, classification, E-R diagramming, and integrity checking integration, including<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/\" title=\"Creating &#038; Executing SQL Statements in IRI Workbench\">Read More<\/a><\/div>\n","protected":false},"author":10,"featured_media":10765,"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":[108,1,776,91],"tags":[82,315,272,831,832,1222,71,100,1220,850,956,296,543,1066,974,50,1174,1223,544,87,1221,1224],"class_list":["post-10764","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-big-data-2","category-data-transformation2","category-etl","category-iri-workbench","tag-change-data-capture","tag-create","tag-data","tag-data-tools-platform","tag-dtp","tag-e-r-diagram","tag-eclipse","tag-etl","tag-execute","tag-iri-workbench","tag-jdbc","tag-masking","tag-migration","tag-modify","tag-mysql","tag-oracle","tag-plug-in","tag-profiling","tag-replication","tag-slowly-changing-dimensions","tag-sql-statements","tag-table"],"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>Creating &amp; Executing SQL Statements in IRI Workbench - IRI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating &amp; Executing SQL Statements in IRI Workbench\" \/>\n<meta property=\"og:description\" content=\"Among the many database-centric features in IRI Workbench is the ability to create, modify, and execute SQL statements manually or graphically. These \u201cSQL scrap-booking\u201d features are available through the free Data Tools Platform (DTP) plug-in for Eclipse, which also supports IRI job wizards for database: profiling, searching, classification, E-R diagramming, and integrity checking integration, includingRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-20T15:29:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-10T19:46:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png\" \/>\n\t<meta property=\"og:image:width\" content=\"624\" \/>\n\t<meta property=\"og:image:height\" content=\"418\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Susan Gegner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Susan Gegner\" \/>\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\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/\"},\"author\":{\"name\":\"Susan Gegner\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\"},\"headline\":\"Creating &#038; Executing SQL Statements in IRI Workbench\",\"datePublished\":\"2016-12-20T15:29:27+00:00\",\"dateModified\":\"2023-03-10T19:46:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/\"},\"wordCount\":783,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png\",\"keywords\":[\"Change Data Capture\",\"create\",\"data\",\"Data Tools Platform\",\"DTP\",\"E-R diagram\",\"Eclipse\",\"ETL\",\"execute\",\"IRI Workbench\",\"JDBC\",\"masking\",\"migration\",\"modify\",\"MySQL\",\"Oracle\",\"plug-in\",\"profiling\",\"replication\",\"slowly changing dimensions\",\"SQL statements\",\"table\"],\"articleSection\":[\"Big Data\",\"Data Transformation\",\"ETL\",\"IRI Workbench\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/\",\"name\":\"Creating & Executing SQL Statements in IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png\",\"datePublished\":\"2016-12-20T15:29:27+00:00\",\"dateModified\":\"2023-03-10T19:46:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png\",\"width\":624,\"height\":418,\"caption\":\"Data Source Explorer in IRI Workbench\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating &#038; Executing SQL Statements 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\/87be5da567628ab9396ca81170f36d63\",\"name\":\"Susan Gegner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"caption\":\"Susan Gegner\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/susang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Creating & Executing SQL Statements in IRI Workbench - IRI","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\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Creating & Executing SQL Statements in IRI Workbench","og_description":"Among the many database-centric features in IRI Workbench is the ability to create, modify, and execute SQL statements manually or graphically. These \u201cSQL scrap-booking\u201d features are available through the free Data Tools Platform (DTP) plug-in for Eclipse, which also supports IRI job wizards for database: profiling, searching, classification, E-R diagramming, and integrity checking integration, includingRead More","og_url":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/","og_site_name":"IRI","article_published_time":"2016-12-20T15:29:27+00:00","article_modified_time":"2023-03-10T19:46:28+00:00","og_image":[{"width":624,"height":418,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png","type":"image\/png"}],"author":"Susan Gegner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Susan Gegner","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/"},"author":{"name":"Susan Gegner","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63"},"headline":"Creating &#038; Executing SQL Statements in IRI Workbench","datePublished":"2016-12-20T15:29:27+00:00","dateModified":"2023-03-10T19:46:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/"},"wordCount":783,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png","keywords":["Change Data Capture","create","data","Data Tools Platform","DTP","E-R diagram","Eclipse","ETL","execute","IRI Workbench","JDBC","masking","migration","modify","MySQL","Oracle","plug-in","profiling","replication","slowly changing dimensions","SQL statements","table"],"articleSection":["Big Data","Data Transformation","ETL","IRI Workbench"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/","url":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/","name":"Creating & Executing SQL Statements in IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png","datePublished":"2016-12-20T15:29:27+00:00","dateModified":"2023-03-10T19:46:28+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png","width":624,"height":418,"caption":"Data Source Explorer in IRI Workbench"},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Creating &#038; Executing SQL Statements 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\/87be5da567628ab9396ca81170f36d63","name":"Susan Gegner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","caption":"Susan Gegner"},"url":"https:\/\/www.iri.com\/blog\/author\/susang\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/12\/Data-Source-Explorer.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10764"}],"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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=10764"}],"version-history":[{"count":16,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10764\/revisions"}],"predecessor-version":[{"id":16437,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10764\/revisions\/16437"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/10765"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=10764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=10764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=10764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}