{"id":15932,"date":"2022-06-28T12:33:01","date_gmt":"2022-06-28T16:33:01","guid":{"rendered":"https:\/\/www.iri.com\/blog\/?p=15932"},"modified":"2024-10-23T12:19:49","modified_gmt":"2024-10-23T16:19:49","slug":"cdc","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/","title":{"rendered":"Getting Started with IRI Ripcurrent"},"content":{"rendered":"

Abstract<\/i><\/b>: Data collected, processed, and saved across industries is constantly generated and updated. Database (DB) tables can be refreshed with new data from applications or events in intervals as frequent as a fraction of a second. With this in mind, IRI developed <\/span><\/i>Ripcurrent<\/i><\/b> as an adjunct feature in <\/span><\/i>Voracity<\/span><\/i><\/a> for real-time data replication to monitor, refresh and mask DB data that changes in real-time.<\/span><\/i><\/p>\n

Editors Note<\/strong><\/em>: You can read the press release introducing Ripcurrent here<\/a>.<\/em><\/p>\n

What is Ripcurrent?<\/b><\/h5>\n

Ripcurrent<\/span><\/a> is the name of an IRI-developed Java application included in the Voracity data management platform<\/a> that combines the <\/span>Debezium embedded engine<\/span><\/a> with the streaming feature of the <\/span>IRI (CoSort) SortCL program<\/span><\/a> to react in real-time to DB change events by <\/span>replicating <\/span><\/i>data to downstream target(s), optionally with transformation (e.g., PII <\/span>masking<\/span><\/i>) rules consistently applied based on your <\/span>classification<\/span><\/a> of the data.<\/span><\/p>\n

Ripcurrent integrates with <\/span>Debezium to track changes from several different DBs. Ripcurrent bundles Debezium connectors for MySQL, SQL Server, PostgreSQL, and Oracle.\u00a0 Debezium may eventually also support MongoDB, DB2 and Vitess, but more work is required.<\/span><\/p>\n

Ripcurrent automatically triggers SortCL to take action on data in an inserted, updated, or deleted row. This can keep a set of equivalent targets (likely in a lower environment) in sync with source tables, and optionally apply consistent field-level transforms (like PII-classified masking) to the data.<\/span><\/p>\n

Ripcurrent is a seamless analog<\/em> to <\/span>this approach<\/span><\/a> for processing changes to flat files in real time, and an alternative<\/em> to <\/span>this approach<\/span><\/a> for moving and masking changed DB data incrementally. <\/span><\/p>\n

This diagram shows the approach Ripcurrent takes for supported DB sources:<\/span>
\n<\/span><\/p>\n

\"\"<\/p>\n

How Ripcurrent replicates data in real-time from a source table to a target<\/span><\/i><\/i><\/p>\n

Ripcurrent can detect changes for every row insertion, update, or delete in all tables in a DB, excluding any tables or schemas that have been filtered out based on the configuration properties passed to Ripcurrent.\u00a0<\/span><\/p>\n

Additionally, other DB change events like the change of the structure of a table are monitored and recorded by Ripcurrent. However, only DB change events that involve the modification, addition, or deletion of data in a table trigger Ripcurrent to take action on that event.<\/span><\/p>\n

Why Use Ripcurrent?<\/b><\/h4>\n

The ability to replicate and\/or mask data in DB tables to other DB tables or files has long been supported by IRI software. This is commonly done through <\/span>IRI Workbench<\/span><\/a>, the graphical user interface for all IRI (structured) data management products.\u00a0<\/span><\/p>\n

The <\/span>Schema Data Class Job<\/span><\/i><\/a> wizard in IRI Workbench \u2013 where data in a schema are searched and grouped into data classes \u2013 can be paired with <\/span>masking rules<\/span><\/a>. A batch file or shell script is generated from the wizard to execute bulk masking operations defined in FieldShield scripts.\u00a0<\/span><\/p>\n

However, if there are any changes to the DB, there is no easy way to replicate the changes without running the batch\/shell script again. And, if there were any additional tables added to the DB or new columns added to existing tables, those will be ignored unless the wizard is run again to generate a new batch\/shell script and the relevant FieldShield scripts for the operation.<\/span><\/p>\n

The need to keep in sync with DB changes is the motivation for the development of IRI Ripcurrent. For those who want to keep the downstream target(s) in-sync with a source DB, perhaps for testing, Ripcurrent provides the functionality of a <\/span>Data Class DB Masking Job<\/span><\/i><\/a>, but in a dynamic fashion. In other words, Ripcurrent enables real-time data masking.<\/span><\/p>\n

Ripcurrent Prerequisites<\/b><\/h4>\n

If duplicating data to tables in a target DB, the target tables must <\/span>be created beforehand<\/span><\/a> with the same DDL as the source table. If the structure of a source table is changed, the target table must also have the change applied. Ripcurrent cannot automatically change the structure of a target table.<\/span><\/p>\n

If duplicating to target tables in the same DB instance and DB schema, a postfix string (i.e. _masked) should be applied. This consistent postfix allows the target tables to be filtered out from monitoring by Debezium if they are in the same DB. This can be done by using a regular expression like .<\/span>*_masked<\/span><\/i> as the value of the <\/span>table.exclude.list<\/i><\/b> configuration property.<\/span><\/p>\n

Ripcurrent <\/span>cannot <\/b>use a DB change event to replicate data to any tables being monitored themselves by Debezium as this would trigger an infinite feedback loop of DB change events.<\/span><\/p>\n

Ripcurrent requires a <\/span>licensed Voracity installation<\/span><\/a> with a CoSort 10.5 build tag of May 2022 or newer, and an installation of <\/span>Java JRE <\/span><\/a>11 or greater.\u00a0<\/span><\/p>\n

To monitor Oracle databases, place the Oracle <\/span>JDBC driver<\/span><\/a>, <\/span>JDBC 4.x standard java.sql.SQLXML interface<\/span><\/a>, and <\/span>the<\/span> Oracle Database XML Parser library<\/span><\/a> jar files into the <\/span>lib<\/i><\/b> folder of the Ripcurrent distribution. These Oracle dependencies could not be packaged directly into the distribution due to licensing restrictions.<\/span><\/p>\n

Installing Ripcurrent<\/b><\/h4>\n

IRI Ripcurrent is installed as an optional feature for IRI Workbench. From the top menu in IRI Workbench, select <\/span>Help->Install New Software\u2026<\/i><\/b>\u00a0<\/span><\/p>\n

A screen similar to the one below will be displayed:<\/span><\/p>\n

\"\"
IRI Voracity Ripcurrent feature installation in IRI Workbench<\/em><\/figcaption><\/figure>\n

Select the <\/span>IRI Tools<\/i><\/b> site, and select IRI Ripcurrent from the available options.<\/span><\/p>\n

When Ripcurrent is installed as a feature, there should be a <\/span>ripcurrent<\/span><\/i> directory located within the <\/span>Ripcurrent<\/span><\/i> feature folder of the Workbench distribution. This directory is the root directory of the Ripcurrent distribution.\u00a0<\/span><\/p>\n

In addition, the feature installs several user interface plugins to generate and edit a properties file, which is a file that specifies configuration options to Ripcurrent.<\/span><\/p>\n

Configuring Ripcurrent<\/b><\/h4>\n

After installing the <\/span>Ripcurrent<\/i><\/b> feature, there is a new wizard available from the IRI Voracity (orca icon) menu to generate a Ripcurrent properties file. A Ripcurrent properties file contains configuration options that are read by Ripcurrent at the start of execution.\u00a0<\/span><\/p>\n

\"\"<\/p>\n

The first page contains options for the source DB to be monitored by Ripcurrent. Ripcurrent can monitor MySQL, PostgreSQL, Oracle, and SQL Server DBs. A source DB connection must be selected from one of the aforementioned supported DB types.\u00a0<\/span><\/p>\n

The port number associated with that connection should be entered. The default port number for the type of DB will be automatically shown, but the number must be modified if the DB is not using the default port.\u00a0<\/span><\/p>\n

Optionally, a regular expression pattern for filtering schemas and tables to be monitored within the DB can be specified. For some DB types such as Oracle and PostgreSQL, a DB name should be specified (e.g. ORCL). If the DB connection selected is a DB type that does not require this property, the text box will be disabled.<\/span><\/p>\n

\"\"<\/p>\n

The second page contains options for Ripcurrent targets.\u00a0<\/span><\/p>\n

Ripcurrent can replicate data to either a set of files, DB tables in a schema, or both files and tables in a schema. After selecting a replication option, this page will be filled in with only the relevant configuration options for the replication option selected.\u00a0<\/span><\/p>\n

When targeting DB tables, select the target DB from the list of connection profiles. A target schema can be selected to which all events from the source DB will be replicated.<\/span><\/p>\n

Ripcurrent will not create tables if they do not exist; therefore, a set of tables with the equivalent structure to the source tables being monitored <\/span>must be already created<\/span><\/a> in the target schema. The name of the target table should be the same as the source table, optionally with a consistent suffix such as <\/span>_masked<\/i><\/b>.<\/span><\/p>\n

Alternatively, the target schema selection could be left unselected; in this case, an event received from the source DB will attempt to be replicated to the target DB using the same schema name as the table of the source event.\u00a0<\/span><\/p>\n

The file target path configuration should include a directory and base file name. The file name part of the path is actually not necessary but may be important so that the file has the desired extension, such as <\/span>.xlsx<\/i><\/b> for Excel files (otherwise the operating system will not know how to open the file by default).<\/span><\/p>\n

A set of files are created \u2013 one for each unique table that changes have been replicated from \u2013 in the following format:\u00a0<\/span><\/p>\n

{Folder Portion of dataTarget}{SOURCE_SCHEMA}.{SOURCE_TABLE}-{suffix}-{Filename Portion of dataTarget}\u00a0<\/span><\/i><\/p>\n

For example:<\/span><\/p>\n

C:\\Users\\dakoz\\Desktop\\replication-station\\TEST.TRANSACTIONS-_masked-file.tsv\u00a0<\/i><\/b><\/p>\n

for an event from the <\/span>TRANSACTIONS<\/span><\/i> table of the <\/span>TEST<\/span><\/i> schema in the source DB.<\/span><\/p>\n

The <\/span>target process type<\/i><\/b> is an option that specifies the SortCL process type of the output file. Record is for delimited files, CSV for delimited files with a header, XML for Extensible Markup Language, and XLSX for a Microsoft Excel Open XML Spreadsheet.<\/span><\/p>\n

The <\/span>target separator<\/i><\/b> option specifies the separator between columns in delimited flat file outputs. It can be a maximum of 15 characters.<\/span><\/p>\n

The target name suffix option is an optional configuration option that adds a consistent suffix to a target table name, which would otherwise be the same as the source table name.<\/span><\/p>\n

The third page allows existing IRI libraries, which are artifacts generated in other Workbench wizards like the <\/span>Schema Data Class Search<\/i><\/b> wizard, to be selected for use in data classification and consistent rule application in the replication of data to targets.<\/span><\/p>\n

\"\"<\/p>\n

For example, a data class could be defined in the IRI data class library to consistently classify credit card numbers. A default rule can be assigned to the Credit Card data class to consistently mask all data classified as a credit card with <\/span>format-preserving encryption<\/span><\/a>.\u00a0<\/span><\/p>\n

The details of the rule referenced in the data class library are contained in the IRI rules library. If no data class library or rules library is selected, data will just be mirrored from source to target.<\/span><\/p>\n

The fourth page has several other miscellaneous Ripcurrent properties to select from.<\/span><\/p>\n

\"\"<\/p>\n

Name<\/i><\/b> is a required property that specifies a unique name for the connector. It is not important what exactly this name is so long as one instance of Ripcurrent is running.<\/span><\/p>\n

Server ID<\/i><\/b> is an optional property to identify the DB client. A positive integer can be specified as the Server ID; otherwise a random ID is generated.<\/span><\/p>\n

Server name <\/i><\/b>is a logical name that identifies and provides a namespace for the particular DB server\/cluster in which Debezium is capturing changes. Again, it is not important what exactly this name is if only one instance of Ripcurrent is running.<\/span><\/p>\n

Finally, a file path that DDL contents of schema change events will be logged to can be selected (<\/span>schema_change_events.log<\/span><\/i> is the default value if no location is selected).<\/span><\/p>\n

After clicking the <\/span>Finish <\/span><\/i>button, the properties file should be successfully generated and automatically opened in an editor for review. For example:<\/span><\/p>\n

\"\"<\/p>\n

Executing Ripcurrent<\/b><\/h4>\n

Once a properties file has been successfully generated to the <\/span>conf<\/i><\/b> directory of the Ripcurrent distribution, Ripcurrent can be started.<\/span><\/p>\n

To start Ripcurrent, execute the <\/span>ripcurrent <\/span><\/i>(Unix) or<\/span> ripcurrent.bat <\/span><\/i>(Windows) scripts in the <\/span>bin <\/span><\/i>directory of the Ripcurrent distribution.<\/span><\/p>\n

Since Ripcurrent is run as a script (a batch script on Windows, otherwise a shell script), it can also be launched through the <\/span>External Tools Configuration<\/b> run configuration in IRI Workbench. As a run configuration, it can also be <\/span>scheduled<\/span><\/a>.<\/span><\/p>\n

\"\"<\/p>\n

Ripcurrent will run constantly, monitoring the source DB for changes. Ripcurrent must be explicitly terminated to stop running.\u00a0<\/span><\/p>\n

If DB changes occur when Ripcurrent is not running, Ripcurrent will resume from where it left off; the changes that occurred in the meantime will not be skipped over.<\/span><\/p>\n

Ripcurrent Documentation<\/b><\/h4>\n

Detailed documentation for Ripcurrent is available <\/span>here<\/span><\/a>, and help for Ripcurrent is also included in IRI Workbench.<\/span><\/p>\n

Demonstrating Ripcurrent<\/b><\/h4>\n

This article provided an introduction of Ripcurrent, and detailed how to install and configure Ripcurrent. Additional articles in this series will display the capabilities of Ripcurrent through demonstration.<\/span><\/p>\n

The <\/span>second article<\/span><\/a> demonstrates real-time replication of data with Ripcurrent, the <\/span>third article<\/span><\/a> demonstrates real-time data masking with Ripcurrent, and the <\/span>fourth article<\/span><\/a> demonstrates how the schema change event log generated by Ripcurrent can be monitored to alert when the structure of a database has changed (database change monitoring).<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Abstract: Data collected, processed, and saved across industries is constantly generated and updated. Database (DB) tables can be refreshed with new data from applications or events in intervals as frequent as a fraction of a second. With this in mind, IRI developed Ripcurrent as an adjunct feature in Voracity for real-time data replication to monitor,<\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":119,"featured_media":15949,"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,1,776,91,29,3],"tags":[13,51,5,1696,789,1896,1706,1948,1949,1697,24],"class_list":["post-15932","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-data-migration","category-data-transformation2","category-etl","category-iri-workbench","category-test-data","category-vldb-operations","tag-data-protection-2","tag-data-replication","tag-data-transformation","tag-iri-ripcurrent","tag-iri-voracity","tag-oracle-data-masking","tag-oracle-data-replication","tag-real-time-db-replication","tag-real-time-masking","tag-ripcurrent","tag-vldb"],"acf":[],"yoast_head":"\nGetting Started with IRI Ripcurrent - IRI<\/title>\n<meta name=\"description\" content=\"Discover IRI Ripcurrent, the onboard CDC module in Voracity that allows you to monitor, replicate and mask database data in real time.\" \/>\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\/cdc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Getting Started with IRI Ripcurrent\" \/>\n<meta property=\"og:description\" content=\"Discover IRI Ripcurrent, the onboard CDC module in Voracity that allows you to monitor, replicate and mask database data in real time.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-28T16:33:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-23T16:19:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Image-Feature-Ripcurrent.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1110\" \/>\n\t<meta property=\"og:image:height\" content=\"581\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Devon Kozenieski\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Devon Kozenieski\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 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\/cdc\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/\"},\"author\":{\"name\":\"Devon Kozenieski\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1\"},\"headline\":\"Getting Started with IRI Ripcurrent\",\"datePublished\":\"2022-06-28T16:33:01+00:00\",\"dateModified\":\"2024-10-23T16:19:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/\"},\"wordCount\":2012,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Image-Feature-Ripcurrent.png\",\"keywords\":[\"data protection\",\"data replication\",\"data transformation\",\"IRI Ripcurrent\",\"IRI Voracity\",\"Oracle data masking\",\"oracle data replication\",\"real-time db replication\",\"real-time masking\",\"Ripcurrent\",\"VLDB\"],\"articleSection\":[\"Data Masking\/Protection\",\"Data Migration\",\"Data Transformation\",\"ETL\",\"IRI Workbench\",\"Test Data\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/\",\"url\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/\",\"name\":\"Getting Started with IRI Ripcurrent - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Image-Feature-Ripcurrent.png\",\"datePublished\":\"2022-06-28T16:33:01+00:00\",\"dateModified\":\"2024-10-23T16:19:49+00:00\",\"description\":\"Discover IRI Ripcurrent, the onboard CDC module in Voracity that allows you to monitor, replicate and mask database data in real time.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Image-Feature-Ripcurrent.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Image-Feature-Ripcurrent.png\",\"width\":1110,\"height\":581},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting Started with IRI Ripcurrent\"}]},{\"@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\/de972c035aaeecfc40a3ae2ea5ff7ba1\",\"name\":\"Devon Kozenieski\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e4c421588c1a85dd9a76146fe15528f7?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e4c421588c1a85dd9a76146fe15528f7?s=96&d=blank&r=g\",\"caption\":\"Devon Kozenieski\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/devonk\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Getting Started with IRI Ripcurrent - IRI","description":"Discover IRI Ripcurrent, the onboard CDC module in Voracity that allows you to monitor, replicate and mask database data in real time.","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\/cdc\/","og_locale":"en_US","og_type":"article","og_title":"Getting Started with IRI Ripcurrent","og_description":"Discover IRI Ripcurrent, the onboard CDC module in Voracity that allows you to monitor, replicate and mask database data in real time.","og_url":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/","og_site_name":"IRI","article_published_time":"2022-06-28T16:33:01+00:00","article_modified_time":"2024-10-23T16:19:49+00:00","og_image":[{"width":1110,"height":581,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Image-Feature-Ripcurrent.png","type":"image\/png"}],"author":"Devon Kozenieski","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Devon Kozenieski","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/"},"author":{"name":"Devon Kozenieski","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1"},"headline":"Getting Started with IRI Ripcurrent","datePublished":"2022-06-28T16:33:01+00:00","dateModified":"2024-10-23T16:19:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/"},"wordCount":2012,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Image-Feature-Ripcurrent.png","keywords":["data protection","data replication","data transformation","IRI Ripcurrent","IRI Voracity","Oracle data masking","oracle data replication","real-time db replication","real-time masking","Ripcurrent","VLDB"],"articleSection":["Data Masking\/Protection","Data Migration","Data Transformation","ETL","IRI Workbench","Test Data","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/","url":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/","name":"Getting Started with IRI Ripcurrent - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Image-Feature-Ripcurrent.png","datePublished":"2022-06-28T16:33:01+00:00","dateModified":"2024-10-23T16:19:49+00:00","description":"Discover IRI Ripcurrent, the onboard CDC module in Voracity that allows you to monitor, replicate and mask database data in real time.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Image-Feature-Ripcurrent.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Image-Feature-Ripcurrent.png","width":1110,"height":581},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/cdc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Getting Started with IRI Ripcurrent"}]},{"@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\/de972c035aaeecfc40a3ae2ea5ff7ba1","name":"Devon Kozenieski","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e4c421588c1a85dd9a76146fe15528f7?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e4c421588c1a85dd9a76146fe15528f7?s=96&d=blank&r=g","caption":"Devon Kozenieski"},"url":"https:\/\/www.iri.com\/blog\/author\/devonk\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Image-Feature-Ripcurrent.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15932"}],"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\/119"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=15932"}],"version-history":[{"count":12,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15932\/revisions"}],"predecessor-version":[{"id":18058,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15932\/revisions\/18058"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/15949"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=15932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=15932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=15932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}