{"id":10558,"date":"2016-09-16T01:43:27","date_gmt":"2016-09-16T05:43:27","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=10558"},"modified":"2026-02-23T15:14:29","modified_gmt":"2026-02-23T20:14:29","slug":"data-replication-in-iri-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/","title":{"rendered":"Data Replication in IRI Workbench"},"content":{"rendered":"<p><a href=\"http:\/\/www.iri.com\/solutions\/data-and-database-migration\/replication\"><span style=\"font-weight: 400;\">Data replication<\/span><\/a><span style=\"font-weight: 400;\"> means copying data from one place to another, and is usually done between users of different databases who need to share the same level of information. Replication can also involve other data sources and targets, and become more complex in transformation and temporal terms.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This is the first of two articles covering database replication in the <\/span><a href=\"http:\/\/www.iri.com\/products\/workbench\"><span style=\"font-weight: 400;\">IRI Workbench<\/span><\/a><span style=\"font-weight: 400;\"> GUI. IRI Workbench is the free IDE built on Eclipse\u2122 that supports all IRI products, including <\/span><a href=\"http:\/\/www.iri.com\/products\/nextform\"><span style=\"font-weight: 400;\">IRI NextForm<\/span><\/a><span style=\"font-weight: 400;\"> (for data and database migration) and <\/span><a href=\"http:\/\/www.iri.com\/products\/voracity\"><span style=\"font-weight: 400;\">IRI Voracity<\/span><\/a><span style=\"font-weight: 400;\"> (a \u00a0total data management platform that includes NextForm et al.). IRI Workbench creates and runs data replication jobs through wizards, scripts, and workflow diagrams.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here are some of the ways in which replications occur:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Data in one database is copied into another database on the same or another server.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Data from two or more databases are combined into a single database.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Users get full initial copies of the database and then periodic updates as data changes.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Data are selectively extracted from a database and replicated in an external file.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Data replication allows you to replicate only a part of database; i .e., selected tables, columns, and\/or rows. Replicating all of the tables is part of database mirroring. However, changes to schemas, constraints, procedures, and access authorizations are not as easy to replicate, and may involve separate processes.<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<h3><b>Basic Example in IRI Workbench<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">We<\/span> <span style=\"font-weight: 400;\">will use a job creation wizard from the NextForm menu in the IRI Workbench toolbar for this first data replication example. We will copy data from an Oracle table into both a MySQL table and a modified flat file. <a href=\"http:\/\/www.iri.com\/blog\/data-transformation2\/incremental-data-replication-in-iri-workbench\/\">This second article<\/a> demonstrates the replication of only updated data in a table by evaluating timestamp column values. <\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">The NextForm menu contains three job creation wizards:<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"> New Reformat Job<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"> New Single Source Migration Job<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"> New Multi Table Migration Job<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">We will use the New Reformat Job wizard to perform this replication. For a more complex job, we would use a different NextForm wizard, or an ETL job wizard in the Voracity menu (or manually build a new workflow).<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here are the structure of the source and target tables:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10587 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/Sql.jpg\" alt=\"Source Target Tables\" width=\"578\" height=\"205\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/Sql.jpg 578w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/Sql-300x106.jpg 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><br \/>\n<b><i>Step 1: Specify the Name and Job Options<\/i><\/b><\/p>\n<p>From the NextForm menu on the top toolbar, select the New Reformat Job wizard. For this example, enter the job file name<i><span style=\"font-weight: 400;\">datareplication<\/span><\/i><span style=\"font-weight: 400;\">. NextForm adds the extension .ncl. You can also add any relevant information about this job which will appear as comments in the script.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">From the radio button list, leave the default selection of <\/span><b>Create script<\/b><span style=\"font-weight: 400;\"> because this is a standalone job and not part of a larger flow or batch project. <\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/1-Job-Specification-File.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10560\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/1-Job-Specification-File.png\" alt=\"Job Specification File\" width=\"469\" height=\"474\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/1-Job-Specification-File.png 469w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/1-Job-Specification-File-297x300.png 297w\" sizes=\"(max-width: 469px) 100vw, 469px\" \/><\/a><\/p>\n<h4><b><i>Step 2: Identify the Source<\/i><\/b><\/h4>\n<p><span style=\"font-weight: 400;\"><br \/>\nOn the next screen, Data Sources, click\u00a0<\/span><b>Add Data Source<\/b><span style=\"font-weight: 400;\">. The source in this example is an ODBC-connected database, so select <\/span><b>ODBC, <\/b><span style=\"font-weight: 400;\">and then click <\/span><b>Browse <\/b><span style=\"font-weight: 400;\">to select the data source name (DSN) and table.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Data-Source.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10561\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Data-Source.png\" alt=\"Data Source\" width=\"569\" height=\"440\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Data-Source.png 569w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Data-Source-300x232.png 300w\" sizes=\"(max-width: 569px) 100vw, 569px\" \/><\/a><\/p>\n<h4><b><i>Step 3: Specify the Source Metadata<\/i><\/b><\/h4>\n<p><span style=\"font-weight: 400;\"><br \/>\nFor IRI software to move and manipulate the data in its engine (in this case, replicate in NextForm), you need metadata for the source and targets defined in the job script, in IRI\u2019s data definition file (DDF) format.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You can build the DDFs for any source (or target) automatically in IRI Workbench. That functionality is embedded here, where you can choose to either <\/span><b>Discover Metadata<\/b><span style=\"font-weight: 400;\"> or <\/span><b>Add Existing Metadata<\/b><span style=\"font-weight: 400;\">. In this case, we will add existing metadata, which was created in a different way.<span id='easy-footnote-1-10558' class='easy-footnote-margin-adjust'><\/span><span class='easy-footnote'><a href='https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#easy-footnote-bottom-1-10558' title='From the Data Source Explorer, right click on the table, select &lt;b&gt;IRI&lt;\/b&gt; &lt;b&gt;&amp;gt;&lt;\/b&gt; &lt;b&gt;Generate DDF&lt;\/b&gt;. This creates the DDF for the table in the active project folder, and will be referenced by IRI\u2019s data manipulation engine at runtime.'><sup>1<\/sup><\/a><\/span><\/span><span style=\"font-weight: 400;\">\u00a0That choice, and its results, are shown in the following dialog:<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/3-Data-Sources.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10563\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/3-Data-Sources.png\" alt=\"Data Sources\" width=\"525\" height=\"593\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/3-Data-Sources.png 525w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/3-Data-Sources-266x300.png 266w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Click <\/span><b>Source Field Layout<\/b><span style=\"font-weight: 400;\"> to see the layout of the data.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/4-Source-Field-Layout.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10564\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/4-Source-Field-Layout.png\" alt=\"Source Field Layout\" width=\"544\" height=\"450\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/4-Source-Field-Layout.png 544w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/4-Source-Field-Layout-300x248.png 300w\" sizes=\"(max-width: 544px) 100vw, 544px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Click <\/span><b>OK<\/b><span style=\"font-weight: 400;\"> to close the Source Field Layout. Then click <\/span><b>Next <\/b><span style=\"font-weight: 400;\">on the Data Sources page to open the Data Target page.<\/span><\/p>\n<h4><b><i>Step 4: Define the Target(s)<\/i><\/b><\/h4>\n<p><span style=\"font-weight: 400;\"><br \/>\nWe are sending the replicated Oracle data to two targets: a MySQL table that we are naming<\/span><i><span style=\"font-weight: 400;\">customers_out<\/span><\/i><span style=\"font-weight: 400;\">, and a file called <\/span><i><span style=\"font-weight: 400;\">personout.csv<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h4><b>Add a target table<\/b><\/h4>\n<p><span style=\"font-weight: 400;\"><br \/>\nClick\u00a0<\/span><b>Add Data Target<\/b><span style=\"font-weight: 400;\">. Select <\/span><b>ODBC <\/b><span style=\"font-weight: 400;\">and click <\/span><b>Browse<\/b><span style=\"font-weight: 400;\">. Then select the Data source name (DSN) <\/span><b>Oracle <\/b><span style=\"font-weight: 400;\">and the table <\/span><b>CUSTOMERS_REP<\/b><span style=\"font-weight: 400;\">. Click <\/span><b>OK<\/b><span style=\"font-weight: 400;\"> to close the dialog.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">On the Data Targets page, highlight the table name and click <\/span><b>Add Existing Metadata<\/b><span style=\"font-weight: 400;\">. Select <\/span><i><span style=\"font-weight: 400;\">cust.ddf<\/span><\/i><span style=\"font-weight: 400;\"> (which was created earlier), and click <\/span><b>OK<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">We want to limit the number of records in this file to 100. Click <\/span><b>Edit Target Options<\/b><span style=\"font-weight: 400;\"> to open the editor, and in the <\/span><b>Outcollect <\/b><span style=\"font-weight: 400;\">field, enter <\/span><i><span style=\"font-weight: 400;\">100<\/span><\/i><span style=\"font-weight: 400;\">, and click <\/span><b>OK<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h4><b>Add a target file<\/b><\/h4>\n<p><span style=\"font-weight: 400;\"><br \/>\nAgain, click\u00a0<\/span><b>Add Data Target<\/b><span style=\"font-weight: 400;\">. Select <\/span><b>File <\/b><span style=\"font-weight: 400;\">and enter <\/span><i><span style=\"font-weight: 400;\">personout.csv<\/span><\/i><span style=\"font-weight: 400;\">, and click <\/span><b>OK<\/b><span style=\"font-weight: 400;\">. We want to limit the number of records in the file to no more than 50, and we also need to change the format to CSV. To do both, click <\/span><b>Edit Target Options<\/b><span style=\"font-weight: 400;\"> to open the editor. Change the <\/span><b>Format <\/b><span style=\"font-weight: 400;\">field to <\/span><b>CSV<\/b><span style=\"font-weight: 400;\">, and in the <\/span><b>Outcollect <\/b><span style=\"font-weight: 400;\">field, enter <\/span><i><span style=\"font-weight: 400;\">50<\/span><\/i><span style=\"font-weight: 400;\">, and click <\/span><b>OK<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/5-Target-Options.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10565\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/5-Target-Options.png\" alt=\"Target Options\" width=\"525\" height=\"767\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/5-Target-Options.png 525w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/5-Target-Options-205x300.png 205w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/a><\/p>\n<h4><b>Add a string function to the target file<\/b><\/h4>\n<p><span style=\"font-weight: 400;\"><br \/>\nWe will also add a string function to display only the last four digits of the SSN field. To do this, click\u00a0<\/span><b>Target Field Layout,<\/b><span style=\"font-weight: 400;\"> and click the personout.csv tab.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Select the SSN field, right-click and select <\/span><b>Apply Rule<\/b> <b>&gt;<\/b> <b>Create Rule<\/b><span style=\"font-weight: 400;\">. On the New Field Rule Wizard Selection page, select <\/span><b>String Manipulation Functions<\/b><span style=\"font-weight: 400;\">. On the next page &#8211; String Manipulation Functions &#8211; \u00a0select <\/span><b>sub_string<\/b><span style=\"font-weight: 400;\">. In the <\/span><b>Offset <\/b><span style=\"font-weight: 400;\">field, enter 6 for the number of characters from the left of the field, and in the <\/span><b>Length <\/b><span style=\"font-weight: 400;\">field, enter 4 for the length of the substring, and then click <\/span><b>Finish<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/6-String-Manipulation-Functions.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10566\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/6-String-Manipulation-Functions.png\" alt=\"String Manipulation Functions\" width=\"600\" height=\"525\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/6-String-Manipulation-Functions.png 724w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/6-String-Manipulation-Functions-300x263.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<h4><b>Add an include filter<\/b><\/h4>\n<p><span style=\"font-weight: 400;\"><br \/>\nTo continue modifying the CSV file, we will add a filter to limit the data to include only those records from CA. Click<\/span><b>Record Filter<\/b><span style=\"font-weight: 400;\"> to create the filter. Select <\/span><b>Include <\/b><span style=\"font-weight: 400;\">for the Filter Action, and select <\/span><b>New Condition <\/b><span style=\"font-weight: 400;\">for the type. Open the Expression Builder by clicking the Function\u00a0<\/span><span style=\"font-weight: 400;\">icon.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10567 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/Function-icon.png\" alt=\"Function icon\" width=\"26\" height=\"25\" \/><\/span><span style=\"font-weight: 400;\">In the Expression Builder, select the category <\/span><b>Relational Operators<\/b><span style=\"font-weight: 400;\"> and the item <\/span><b>EQ<\/b><span style=\"font-weight: 400;\">. In the <\/span><b>Expression <\/b><span style=\"font-weight: 400;\">field at the top, enter STATE EQ &#8220;CA&#8221; using the tools on the toolbar, and click <\/span><b>Finish<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/7-Expression-Builder.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10568\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/7-Expression-Builder.png\" alt=\"Expression Builder\" width=\"525\" height=\"562\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/7-Expression-Builder.png 525w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/7-Expression-Builder-280x300.png 280w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Back on the Data Targets page, we decide to re-position the last and first name fields after the zip field. Select <\/span><b>LASTNAME <\/b><span style=\"font-weight: 400;\">and click <\/span><b>Down <\/b><span style=\"font-weight: 400;\">until the field is at the bottom of the list, then select <\/span><b>FIRSTNAME <\/b><span style=\"font-weight: 400;\">and do the same.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">When we are done adding both targets, the fields and modifications display on the Data Targets page.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/8-Data-Targets.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10569\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/8-Data-Targets.png\" alt=\"Data Targets\" width=\"525\" height=\"622\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/8-Data-Targets.png 525w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/8-Data-Targets-253x300.png 253w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Click <\/span><b>Finish <\/b><span style=\"font-weight: 400;\">to complete building the script, which is shown below in the color-coded, syntax-aware editor view of IRI Workbench:<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/9-IRI-Workbench-Script.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10570\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/9-IRI-Workbench-Script.png\" alt=\"IRI Workbench Script\" width=\"600\" height=\"425\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/9-IRI-Workbench-Script.png 756w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/9-IRI-Workbench-Script-300x213.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<h3><b><i>Results<\/i><\/b><\/h3>\n<p><span style=\"font-weight: 400;\"><br \/>\nRun the job script by right-clicking in the script and selecting<\/span><b>Run As &gt;<\/b> <b>IRI Job<\/b><span style=\"font-weight: 400;\">. The target data is shown in the tabs open below:<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10571\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png\" alt=\"Workbench Results\" width=\"600\" height=\"468\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png 1103w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results-300x234.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results-768x599.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results-1024x798.png 1024w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">If you have any questions about replicating data in NextForm or Voracity, contact your IRI representative.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data replication means copying data from one place to another, and is usually done between users of different databases who need to share the same level of information. Replication can also involve other data sources and targets, and become more complex in transformation and temporal terms. This is the first of two articles covering database<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/\" title=\"Data Replication in IRI Workbench\">Read More<\/a><\/div>\n","protected":false},"author":53,"featured_media":10571,"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":[31,91,3,2255],"tags":[77,51,519,1188,561,100,126,553,789,850,489,680,1119,1186,96,1187],"class_list":["post-10558","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-migration","category-iri-workbench","category-vldb-operations","category-archived-articles","tag-data-migration-2","tag-data-replication","tag-database","tag-database-mirroring","tag-ddf","tag-etl","tag-expression-builder","tag-iri-nextform","tag-iri-voracity","tag-iri-workbench","tag-metadata","tag-reformat","tag-script","tag-string-function","tag-wizard","tag-workflow-diagram"],"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>Data Replication 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\/vldb-operations\/data-replication-in-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Replication in IRI Workbench\" \/>\n<meta property=\"og:description\" content=\"Data replication means copying data from one place to another, and is usually done between users of different databases who need to share the same level of information. Replication can also involve other data sources and targets, and become more complex in transformation and temporal terms. This is the first of two articles covering databaseRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-16T05:43:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-23T20:14:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1103\" \/>\n\t<meta property=\"og:image:height\" content=\"860\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Chaitali Mitra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chaitali Mitra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 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\/data-replication-in-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/\"},\"author\":{\"name\":\"Chaitali Mitra\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf\"},\"headline\":\"Data Replication in IRI Workbench\",\"datePublished\":\"2016-09-16T05:43:27+00:00\",\"dateModified\":\"2026-02-23T20:14:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/\"},\"wordCount\":1158,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png\",\"keywords\":[\"data migration\",\"data replication\",\"database\",\"database mirroring\",\"DDF\",\"ETL\",\"expression builder\",\"IRI NextForm\",\"IRI Voracity\",\"IRI Workbench\",\"metadata\",\"reformat\",\"script\",\"string function\",\"wizard\",\"workflow diagram\"],\"articleSection\":[\"Data Migration\",\"IRI Workbench\",\"VLDB\",\"Archived Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/\",\"name\":\"Data Replication in IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png\",\"datePublished\":\"2016-09-16T05:43:27+00:00\",\"dateModified\":\"2026-02-23T20:14:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png\",\"width\":1103,\"height\":860,\"caption\":\"Workbench Results\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Replication 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\/9bae14a309616863b027c2d56f532caf\",\"name\":\"Chaitali Mitra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g\",\"caption\":\"Chaitali Mitra\"},\"sameAs\":[\"http:\/\/www.iri.com\"],\"url\":\"https:\/\/www.iri.com\/blog\/author\/chaitalim\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Replication 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\/vldb-operations\/data-replication-in-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Data Replication in IRI Workbench","og_description":"Data replication means copying data from one place to another, and is usually done between users of different databases who need to share the same level of information. Replication can also involve other data sources and targets, and become more complex in transformation and temporal terms. This is the first of two articles covering databaseRead More","og_url":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/","og_site_name":"IRI","article_published_time":"2016-09-16T05:43:27+00:00","article_modified_time":"2026-02-23T20:14:29+00:00","og_image":[{"width":1103,"height":860,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png","type":"image\/png"}],"author":"Chaitali Mitra","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chaitali Mitra","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/"},"author":{"name":"Chaitali Mitra","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf"},"headline":"Data Replication in IRI Workbench","datePublished":"2016-09-16T05:43:27+00:00","dateModified":"2026-02-23T20:14:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/"},"wordCount":1158,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png","keywords":["data migration","data replication","database","database mirroring","DDF","ETL","expression builder","IRI NextForm","IRI Voracity","IRI Workbench","metadata","reformat","script","string function","wizard","workflow diagram"],"articleSection":["Data Migration","IRI Workbench","VLDB","Archived Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/","url":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/","name":"Data Replication in IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png","datePublished":"2016-09-16T05:43:27+00:00","dateModified":"2026-02-23T20:14:29+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png","width":1103,"height":860,"caption":"Workbench Results"},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/data-replication-in-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Replication 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\/9bae14a309616863b027c2d56f532caf","name":"Chaitali Mitra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g","caption":"Chaitali Mitra"},"sameAs":["http:\/\/www.iri.com"],"url":"https:\/\/www.iri.com\/blog\/author\/chaitalim\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/10-Workbench-Results.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10558"}],"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\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=10558"}],"version-history":[{"count":17,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10558\/revisions"}],"predecessor-version":[{"id":11259,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10558\/revisions\/11259"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/10571"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=10558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=10558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=10558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}