{"id":62468,"date":"2023-06-23T14:52:18","date_gmt":"2023-06-23T12:52:18","guid":{"rendered":"https:\/\/www.arcadsoftware.com\/?post_type=avada_portfolio&#038;p=62468"},"modified":"2025-05-16T14:09:42","modified_gmt":"2025-05-16T12:09:42","slug":"ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction","status":"publish","type":"avada_portfolio","link":"https:\/\/www.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/","title":{"rendered":"Test Data Management &#8211; Part 1 Data Extraction"},"content":{"rendered":"<p><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling podcast-header\" style=\"--awb-background-blend-mode:overlay;--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-overflow:visible;--awb-padding-top:45px;--awb-padding-bottom:45px;--awb-padding-top-medium:40px;--awb-padding-bottom-medium:40px;--awb-padding-top-small:45px;--awb-padding-right-small:20px;--awb-padding-bottom-small:45px;--awb-padding-left-small:20px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-justify-content-center fusion-flex-content-wrap\" style=\"max-width:1248px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:auto;--awb-margin-top-large:0px;--awb-spacing-right-large:2%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:2%;--awb-width-medium:auto;--awb-order-medium:0;--awb-spacing-right-medium:2%;--awb-spacing-left-medium:2%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-margin-bottom-small:0px;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-image-element \" style=\"--awb-max-width:340px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);--awb-filter:opacity(82%);--awb-filter-transition:filter 0.3s ease;--awb-filter-hover:opacity(82%);\"><span class=\" fusion-imageframe imageframe-none imageframe-1 hover-type-none\"><a class=\"fusion-no-lightbox\" href=\"#tech-talk\" target=\"_self\"><img decoding=\"async\" width=\"800\" height=\"544\" alt=\"Illustration podcast section\" src=\"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2022\/10\/illustration-podcast-en.png\" class=\"img-responsive wp-image-60428\" srcset=\"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2022\/10\/illustration-podcast-en-200x136.png 200w, https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2022\/10\/illustration-podcast-en-400x272.png 400w, https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2022\/10\/illustration-podcast-en-600x408.png 600w, https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2022\/10\/illustration-podcast-en.png 800w\" sizes=\"(max-width: 640px) 100vw, 800px\" \/><\/a><\/span><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_3_5 3_5 fusion-flex-column\" style=\"--awb-padding-right:25px;--awb-bg-blend:overlay;--awb-bg-size:cover;--awb-width-large:60%;--awb-margin-top-large:0px;--awb-spacing-right-large:3.2%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:3.2%;--awb-width-medium:40%;--awb-spacing-right-medium:4.8%;--awb-spacing-left-medium:4.8%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-1 fusion-sep-none fusion-title-text fusion-title-size-one\" style=\"--awb-text-color:#437cb4;--awb-margin-top:0px;--awb-margin-bottom:5px;--awb-margin-top-small:0px;--awb-margin-bottom-small:0px;--awb-font-size:45px;\"><h1 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"font-family:&quot;Poppins&quot;;font-style:normal;font-weight:400;margin:0;font-size:1em;--fontSize:45;line-height:1.16;\"><p><span style=\"font-size: 20px !important;\">IBM i DevOps TechTalk #6<\/span><br \/>\n<span style=\"display: block; font-weight: 800; line-height: 1;\">Test Data Management &#8211; Data Extraction part 1\u00a0<\/span><\/p><\/h1><\/div><div class=\"fusion-title title fusion-title-2 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"--awb-text-color:#437cb4;--awb-margin-top-small:10px;--awb-margin-bottom-small:10px;--awb-font-size:22px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:22;--minFontSize:22;line-height:1.2;\">by the experts at ARCAD<\/h2><\/div><div class=\"fusion-text fusion-text-1 fusion-text-no-margin\" style=\"--awb-content-alignment:left;--awb-font-size:16px;--awb-margin-bottom:0px;\"><p>The topic of this IBM i DevOps TechTalk is <strong>Test Data Management with the focus on data extraction<\/strong>. It features Alan Ashley, an expert in test data management, who will answers questions by our host, Ray Bernardi:<\/p>\n<ul>\n<li>Where\/how to start a test data management plan<\/li>\n<li>What are the main benefits of data extraction<\/li>\n<li>How to manage data security &amp; privacy concerns<\/li>\n<li>How to automate the test data management process<\/li>\n<li>How to maintain integrity between IBM i and non-IBM i databases during extraction<\/li>\n<\/ul>\n<p>Listen to this episode to get started <strong>with the management of your own test data<\/strong>!<\/p>\n<\/div><\/div><\/div><\/div><\/div><div id=\"tech-talk\" class=\"fusion-container-anchor\"><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-2 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling iframe\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:45px;--awb-padding-bottom:45px;--awb-padding-top-small:45px;--awb-padding-bottom-small:45px;--awb-background-color:#daeaf65e;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-justify-content-center fusion-flex-content-wrap\" style=\"max-width:1248px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 fusion_builder_column_3_4 3_4 fusion-flex-column fusion-flex-align-self-center integration-podcast\" style=\"--awb-padding-bottom:55px;--awb-padding-bottom-medium:0px;--awb-bg-size:cover;--awb-width-large:75%;--awb-margin-top-large:0px;--awb-spacing-right-large:2.56%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:2.56%;--awb-width-medium:75%;--awb-order-medium:0;--awb-spacing-right-medium:2.56%;--awb-spacing-left-medium:2.56%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-center fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-3 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"--awb-text-color:#437cb4;--awb-margin-top-small:10px;--awb-margin-bottom-small:10px;--awb-font-size:40px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"font-family:&quot;Poppins&quot;;font-style:normal;font-weight:800;margin:0;font-size:1em;--fontSize:40;line-height:1.2;\">Listen to the Podcast<\/h2><\/div><div style=\"left: 0; width: 100%; height: 102px; position: relative;\"><iframe src=\"https:\/\/podcasters.spotify.com\/pod\/show\/arcad-software\/embed\/episodes\/IBM-i-DevOps-TechTalk-6---Test-Data-Management-part-1---Data-Extraction-e260q9r\" height=\"202px\" width=\"100%\" frameborder=\"0\" scrolling=\"no\"><\/iframe><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-3 fusion_builder_column_2_5 2_5 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:40%;--awb-margin-top-large:0px;--awb-spacing-right-large:4.8%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:4.8%;--awb-width-medium:40%;--awb-order-medium:0;--awb-spacing-right-medium:4.8%;--awb-spacing-left-medium:4.8%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-builder-row fusion-builder-row-inner fusion-row fusion-flex-align-items-flex-start fusion-flex-justify-content-center fusion-flex-content-wrap\" style=\"--awb-flex-grow:0;--awb-flex-grow-medium:0;--awb-flex-grow-small:0;--awb-flex-shrink:0;--awb-flex-shrink-medium:0;--awb-flex-shrink-small:0;width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column_inner fusion-builder-nested-column-0 fusion_builder_column_inner_1_2 1_2 fusion-flex-column\" style=\"--awb-padding-top:10px;--awb-bg-size:cover;--awb-width-large:50%;--awb-margin-top-large:0px;--awb-spacing-right-large:3.84%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:3.84%;--awb-width-medium:50%;--awb-order-medium:0;--awb-spacing-right-medium:3.84%;--awb-spacing-left-medium:3.84%;--awb-width-small:50%;--awb-order-small:0;--awb-spacing-right-small:3.84%;--awb-spacing-left-small:3.84%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-image-element \" style=\"text-align:center;--awb-max-width:200px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><span class=\" fusion-imageframe imageframe-none imageframe-2 hover-type-none\"><a class=\"fusion-no-lightbox\" href=\"https:\/\/open.spotify.com\/episode\/4t49B3pLrrtTaWJH2ZgCxu?si=fXesWvBsSLyrvQED6jFtzg\" target=\"_blank\" aria-label=\"listen-on-spotify\" rel=\"noopener noreferrer\"><img decoding=\"async\" width=\"300\" height=\"73\" alt=\"Spotify Podcast Badge\" src=\"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2023\/01\/listen-on-spotify.webp\" class=\"img-responsive wp-image-61372\" srcset=\"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2023\/01\/listen-on-spotify-200x49.webp 200w, https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2023\/01\/listen-on-spotify.webp 300w\" sizes=\"(max-width: 640px) 100vw, 300px\" \/><\/a><\/span><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column_inner fusion-builder-nested-column-1 fusion_builder_column_inner_1_2 1_2 fusion-flex-column\" style=\"--awb-padding-top:10px;--awb-bg-size:cover;--awb-width-large:50%;--awb-margin-top-large:0px;--awb-spacing-right-large:3.84%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:3.84%;--awb-width-medium:50%;--awb-order-medium:0;--awb-spacing-right-medium:3.84%;--awb-spacing-left-medium:3.84%;--awb-width-small:50%;--awb-order-small:0;--awb-spacing-right-small:3.84%;--awb-spacing-left-small:3.84%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-image-element \" style=\"text-align:center;--awb-max-width:200px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><span class=\" fusion-imageframe imageframe-none imageframe-3 hover-type-none\"><a class=\"fusion-no-lightbox\" href=\"https:\/\/podcasts.apple.com\/us\/podcast\/ibm-i-devops-techtalk-6-test-data-management-part-1\/id1666813114?i=1000617997404\" target=\"_blank\" aria-label=\"apple-podcasts-badge\" rel=\"noopener noreferrer\"><img decoding=\"async\" width=\"300\" height=\"76\" alt=\"Apple Podcast Badge\" src=\"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2023\/01\/apple-podcasts-badge.webp\" class=\"img-responsive wp-image-61375\" srcset=\"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2023\/01\/apple-podcasts-badge-200x51.webp 200w, https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2023\/01\/apple-podcasts-badge.webp 300w\" sizes=\"(max-width: 640px) 100vw, 300px\" \/><\/a><\/span><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-3 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling transcription\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:45px;--awb-padding-right-small:20px;--awb-padding-left-small:20px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-center fusion-flex-justify-content-center fusion-flex-content-wrap\" style=\"max-width:1248px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-4 fusion_builder_column_2_3 2_3 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:66.666666666667%;--awb-margin-top-large:0px;--awb-spacing-right-large:2.88%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:2.88%;--awb-width-medium:66.666666666667%;--awb-order-medium:0;--awb-spacing-right-medium:2.88%;--awb-spacing-left-medium:2.88%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-4 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"--awb-text-color:#437cb4;--awb-margin-bottom:0px;--awb-margin-top-small:10px;--awb-margin-bottom-small:10px;--awb-font-size:25px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"font-family:&quot;Poppins&quot;;font-style:normal;font-weight:800;margin:0;font-size:1em;--fontSize:25;line-height:1.2;\">The Story Behind the Mic: Podcast Transcription<\/h2><\/div><div class=\"fusion-text fusion-text-2\" style=\"--awb-font-size:16px;\"><h3>Ray Bernardi &#8211; Welcome to IBM i DevOps TechTalk, where we discuss key questions and topics with ARCAD experts. Today we&#8217;ll discuss test data and test data management. My name is Ray Bernardi and with me is Alan Ashley.<\/h3>\n<h3>So Alan, I guess the first question would be: where would a person start with test data management? I mean, of course talking about extracting data today, but what do you need to even think about? What are the goals that you need to achieve?<\/h3>\n<p><b> Alan Ashley<\/b> &#8211; When you start talking about taking your production data and relocating it for another purpose, you need to kind of lay out why. Is it going to be a test database, is it going to be training? What kind of data do you need to bring over? Is this something that you&#8217;re going to maybe have to repeat?<br \/>\nHow often are you going to have to do this? So when you start laying out your goals or kind of almost your workflow of how this is going to go, you need to plan your extraction, how are you going to do it? When are you going to do it? Do you need to take into account, maybe security?<br \/>\nAnd I know in the States, the GDPR aspect of things that they have in the EU and the PII security that happens in the EU has not quite made it all the way over to the States yet. To the extreme, give it time. They&#8217;ll figure it out. I know some new laws out of California and Quebec are making their way around, but you also have to factor in that, what kind of security do you need to filter out? Maybe data that doesn&#8217;t contain certain information?<\/p>\n<h3>R.B. &#8211; I don&#8217;t think a lot of American companies know that if one person in their database is a European customer, all this applies to them.<\/h3>\n<p><b> A.A.<\/b> &#8211; Exactly. And they think of it as a production level, not what happens when the data leaves production and becomes a test environment. But guess what? That&#8217;s still applies. When you start extracting the data, you can start filtering some of that information out so that it does not go to test. And one of the big keys to this is how are you going to automate it?<br \/>\nHow often are you going to have to do this? So is it going to be part of a pipeline, are you going to do it manually every two months? That&#8217;s something you need to think about.<\/p>\n<h3>R.B. &#8211; So I think basically what you said here was in order to get going, you should understand your data requirements. You should plan your data extraction, you should ensure data privacy and security when you&#8217;re done with that, and you should use automation.<\/h3>\n<p><b> A.A.<\/b> &#8211; Exactly.<\/p>\n<h3>R.B. &#8211; So now that we have an idea of why we&#8217;re doing this. What are some of the benefits of creating these subsets of data?<\/h3>\n<p><b> A.A.<\/b> &#8211; If you&#8217;re building a test environment or a training environment, you can go after certain segments of your production database. So let&#8217;s say you want to focus on US customers for your training environment because you&#8217;re training maybe us based personnel. If it&#8217;s a global company, maybe you will need to pull data that is only French.<br \/>\nYou can create this subset and then it can make it a repeatable process from that. So that&#8217;s one of the benefits is you can really segment what type of data you want to use and pull in.<\/p>\n<h3>R.B. &#8211; That&#8217;s what you meant just a minute ago when you said filter the data as you bring it out of the like get rid of the European customers as you&#8217;re extracting data from a production. Is that what you meant?<\/h3>\n<p><b> A.A.<\/b> &#8211; Yes, exactly. So that you can get the data that you need to test on, that fits your plan. Now with that, you can also really diversify the data that you get. Let&#8217;s say you&#8217;re testing a big release and you need all sorts of data, but not a lot of it. So you can pull a little bit from the U.S., a little bit from the EU, a little bit from APAC, and put it all together so that you can test for the maybe double bi character sets in your data fields, but without having 100 million records to go through.<br \/>\nAnd lastly, part of this, this is becoming a bigger topic, is building environments on the fly. So you get your front end backend server, backend database. When you have these subsets of data, you can provision those temporary environments a lot faster. It takes a lot less time to load a million records than 100 million records, and there are many companies out there that have hundreds of millions of records across multiple tables, and this would save them time if they were building up these little small data sets.<\/p>\n<h3>R.B. &#8211; All right. Since we have this need to handle and manage test data, how exactly can ARCAD help?<\/h3>\n<p><b> A.A.<\/b> &#8211; ARCAD has this nice product called <a href=\"https:\/\/www.arcadsoftware.com\/dot\/data-subsetting\/dot-extract\/\" target=\"_blank\" rel=\"noopener noreferrer\"><b>DOT Extrac<\/b><\/a>t as part of our test out of management suite of tools. The other one is <a href=\"https:\/\/www.arcadsoftware.com\/dot\/data-masking\/dot-anonymizer\/\" target=\"_blank\" rel=\"noopener noreferrer\"><b>DOT Anonymizer<\/b><\/a>, which really plays into anonymizing data, hence the name, to protect your PII, to follow GDPR rules and things like that. With DOT Extract, what it does is it allows you to start creating your data sources, either DDL or GDS.<br \/>\nIf you&#8217;re using our observer product, observer DB so that it can build out the referential integrity and then map it, because that&#8217;s the key here. When you start creating these subsets of data, you need to have the integrity of the data. Otherwise it&#8217;s kind of worthless data and DOT Extract really comes into play there because it one maintains and builds a repository of those database relationships to help filter it out. Not everyone is an SQL guru, so it has a little wizard that can help go through it and build your filter. Maybe you&#8217;re reducing it by country, by product line, by sales numbers, you name it, and it will help guide you through that. Now, if you are the SQL guru, it has an option to allow you to just write your own right there.<br \/>\nIt gives you the option to include the where and that will build out your filter. And with this, you can build filters on filters across multiple tables within the schema so that when you go to do your extract, it can go through each one of those rules, each one of those filters, and it pulls the data together. And what is really great about this, it maintains that integrity. So if you have an account number that is, let&#8217;s say, for example, based in the U.S., it&#8217;s going to find all the relative data that goes with that record.<\/p>\n<h3>R.B. &#8211; But most of the data usable.<\/h3>\n<p><b> A.A.<\/b> &#8211; Right. It&#8217;s got to be usable and it&#8217;s got to be consistent so that you know what you&#8217;re getting there. And then lastly, it stores this information or this extract in a repository. And what is nice is now you can inject this data repeatedly. If you have a database DB2 for i and you pull off your extracted data and you need to build out three training environments, one for EU, one for the U.S., maybe one for Asia-Pac. With one extract, it can point to three injections on DB2 for i and it will populate those at the same time.<\/p>\n<h3>R.B. &#8211; So you&#8217;re starting to talk about a process here. Now, I&#8217;ve heard you say this term before, ETL (Extract Transfer Load). What would be a typical workflow?<\/h3>\n<p><b> A.A.<\/b> &#8211; So DOT Extract when you start put it into workflow is a little bit less ETL because ETL is a true extract transfer load, it&#8217;s going to be one fluid process going through. Extract is really about refining the subset of your data. So for us, a good workflow would be you extract your data, you anonymize your data, that&#8217;s key.<br \/>\nSo now you&#8217;re protecting your PII information before anybody else can get to it in your test environments. And I brought this up at a conference and I asked the crowd: where do you get your test out it from? And everybody said production. Do you have PII data? And they&#8217;re like, yes. Do you protect it in your test?<br \/>\nAnd all our eyes glazed over as they realized: we&#8217;ve got a problem here. So this is when you come in and anonymize because nobody thinks about the test side of things. And then lastly, you inject it into the environment that you want to go to. So whether or not you&#8217;re injecting it going from MySQL out of MySQL, PostgreSQL to PostgreSQL.<br \/>\nThat&#8217;s where the injections would take place.<\/p>\n<h3>R.B. &#8211; So just I guess a final question here, Alan. What databases does this thing support?<\/h3>\n<p><b> A.A.<\/b> &#8211; So currently today DOT Extract handles DB2 for i, Microsoft SQL Server, MySQL, Oracle and PostgreSQL. That&#8217;s where it sits today. And of course, this is all the stuff in development. So we&#8217;re adding new databases down the road. I imagine MangoDB is going to be coming. I imagine some flat files support will probably come as well.<br \/>\nBut right now we&#8217;re starting on those five databases because those are some of the most popular databases in the market today.<\/p>\n<h3>R.B. &#8211; Thank you, Alan. I don&#8217;t know about you, but I learned a lot about test data extraction today. I learned that first, I need to understand my data requirements, and then I really need to plan that data extraction. During that, I need to ensure data privacy and its security. And the best way to perform all this is through automation. Thanks for listening today.<\/h3>\n<\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-4 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling presenters\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:45px;--awb-padding-right-small:0px;--awb-padding-left-small:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-stretch fusion-flex-content-wrap\" style=\"max-width:1248px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-5 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-padding-left-small:25px;--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-5 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"--awb-text-color:var(--awb-color5);--awb-margin-top:0px;--awb-margin-bottom:0px;--awb-margin-top-small:10px;--awb-margin-bottom-small:0px;--awb-font-size:35px;\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"font-family:&quot;Poppins&quot;;font-style:normal;font-weight:600;margin:0;font-size:1em;--fontSize:35;line-height:1.2;\">Our Hosts<\/h2><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-6 fusion_builder_column_1_3 1_3 fusion-flex-column\" style=\"--awb-padding-top:25px;--awb-padding-right:25px;--awb-padding-left:25px;--awb-bg-color:var(--awb-color1);--awb-bg-color-hover:var(--awb-color1);--awb-bg-size:cover;--awb-box-shadow:5px 8px 19px -4px rgba(0,0,0,0.1);;--awb-width-large:33.333333333333%;--awb-margin-top-large:0px;--awb-spacing-right-large:5.76%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:5.76%;--awb-width-medium:33.333333333333%;--awb-order-medium:0;--awb-spacing-right-medium:5.76%;--awb-spacing-left-medium:5.76%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-builder-row fusion-builder-row-inner fusion-row fusion-flex-align-items-stretch fusion-flex-content-wrap\" style=\"--awb-flex-grow:0;--awb-flex-grow-medium:0;--awb-flex-grow-small:0;--awb-flex-shrink:0;--awb-flex-shrink-medium:0;--awb-flex-shrink-small:0;width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column_inner fusion-builder-nested-column-2 fusion_builder_column_inner_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:0%;--awb-margin-bottom-large:5px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:0%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-image-element \" style=\"--awb-max-width:110px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><span class=\" fusion-imageframe imageframe-none imageframe-4 hover-type-none\" style=\"border-radius:50px;\"><img decoding=\"async\" width=\"200\" height=\"200\" alt=\"Alan Ashley\" src=\"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2024\/11\/alan-ashley.png\" class=\"img-responsive wp-image-70503\" srcset=\"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2024\/11\/alan-ashley-66x66.png 66w, https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2024\/11\/alan-ashley-150x150.png 150w, https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2024\/11\/alan-ashley.png 200w\" sizes=\"(max-width: 200px) 100vw, 200px\" \/><\/span><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column_inner fusion-builder-nested-column-3 fusion_builder_column_inner_1_1 1_1 fusion-flex-column fusion-flex-align-self-center\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-margin-top-small:0px;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-6 fusion-sep-none fusion-title-text fusion-title-size-three\" style=\"--awb-text-color:var(--awb-color5);--awb-margin-top:0px;--awb-margin-bottom:0px;--awb-margin-top-small:0px;--awb-margin-bottom-small:0px;--awb-font-size:22px;\"><h3 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"font-family:&quot;Poppins&quot;;font-style:normal;font-weight:600;margin:0;font-size:1em;--fontSize:22;--minFontSize:22;line-height:1.3;\">Alan Ashley<\/h3><\/div><div class=\"fusion-title title fusion-title-7 fusion-sep-none fusion-title-text fusion-title-size-four\" style=\"--awb-text-color:var(--awb-color5);--awb-margin-top:0px;--awb-margin-bottom:5px;--awb-margin-top-small:0px;--awb-margin-bottom-small:10px;--awb-font-size:16px;\"><h4 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"font-family:&quot;Poppins&quot;;font-style:normal;font-weight:400;margin:0;font-size:1em;--fontSize:16;--minFontSize:16;line-height:1.36;\">Solution Architect, ARCAD Software<\/h4><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column_inner fusion-builder-nested-column-4 fusion_builder_column_inner_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-margin-top-small:0px;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-text fusion-text-3\" style=\"--awb-font-size:15px;--awb-line-height:1.4;--awb-text-font-family:&quot;Poppins&quot;;--awb-text-font-style:normal;--awb-text-font-weight:400;\"><p>Alan has been in support and promotion of the IBM i platform for over 30 years and is the Presales Consultant for DevOps on IBM i role with ARCAD Software. Prior to joining ARCAD Software, he spent many years in multiple roles within IBM from supporting customers through HA to DR to Application promotion to migrations of the IBM i to the cloud. In those roles, he saw first hand the pains many have with Application Lifecycle Management, modernization, and data protection. His passion in those areas fits right in with the ARCAD suite of products.<\/p>\n<\/div><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-7 fusion_builder_column_1_3 1_3 fusion-flex-column\" style=\"--awb-padding-top:25px;--awb-padding-right:25px;--awb-padding-left:25px;--awb-bg-color:var(--awb-color1);--awb-bg-color-hover:var(--awb-color1);--awb-bg-size:cover;--awb-box-shadow:5px 8px 19px -4px rgba(0,0,0,0.1);;--awb-width-large:33.333333333333%;--awb-margin-top-large:0px;--awb-spacing-right-large:5.76%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:5.76%;--awb-width-medium:33.333333333333%;--awb-order-medium:0;--awb-spacing-right-medium:5.76%;--awb-spacing-left-medium:5.76%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-builder-row fusion-builder-row-inner fusion-row fusion-flex-align-items-stretch fusion-flex-content-wrap\" style=\"--awb-flex-grow:0;--awb-flex-grow-medium:0;--awb-flex-grow-small:0;--awb-flex-shrink:0;--awb-flex-shrink-medium:0;--awb-flex-shrink-small:0;width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column_inner fusion-builder-nested-column-5 fusion_builder_column_inner_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:0%;--awb-margin-bottom-large:5px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:0%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-image-element \" style=\"--awb-max-width:110px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><span class=\" fusion-imageframe imageframe-none imageframe-5 hover-type-none\"><img decoding=\"async\" width=\"200\" height=\"200\" alt=\"C\u00e9cile Masson\" src=\"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2024\/11\/ray-bernardi.png\" class=\"img-responsive wp-image-70504\" srcset=\"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2024\/11\/ray-bernardi-66x66.png 66w, https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2024\/11\/ray-bernardi-150x150.png 150w, https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2024\/11\/ray-bernardi.png 200w\" sizes=\"(max-width: 200px) 100vw, 200px\" \/><\/span><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column_inner fusion-builder-nested-column-6 fusion_builder_column_inner_1_1 1_1 fusion-flex-column fusion-flex-align-self-center\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-margin-top-small:0px;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-8 fusion-sep-none fusion-title-text fusion-title-size-three\" style=\"--awb-text-color:var(--awb-color5);--awb-margin-top:0px;--awb-margin-bottom:0px;--awb-margin-top-small:0px;--awb-margin-bottom-small:0px;--awb-font-size:22px;\"><h3 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"font-family:&quot;Poppins&quot;;font-style:normal;font-weight:600;margin:0;font-size:1em;--fontSize:22;--minFontSize:22;line-height:1.3;\">Ray Bernardi<\/h3><\/div><div class=\"fusion-title title fusion-title-9 fusion-sep-none fusion-title-text fusion-title-size-four\" style=\"--awb-text-color:var(--awb-color5);--awb-margin-top:0px;--awb-margin-bottom:5px;--awb-margin-top-small:0px;--awb-margin-bottom-small:10px;--awb-font-size:16px;\"><h4 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"font-family:&quot;Poppins&quot;;font-style:normal;font-weight:400;margin:0;font-size:1em;--fontSize:16;--minFontSize:16;line-height:1.36;\">Senior Consultant, ARCAD Software<\/h4><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column_inner fusion-builder-nested-column-7 fusion_builder_column_inner_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-margin-top-small:0px;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-text fusion-text-4\" style=\"--awb-font-size:15px;--awb-line-height:1.4;--awb-text-font-family:&quot;Poppins&quot;;--awb-text-font-style:normal;--awb-text-font-weight:400;\"><p>Ray is a 30-year IT veteran and currently a Pre\/Post Sales technical Support Specialist for ARCAD Software, international ISV and IBM Business Partner. He has been involved with the development and sales of many cutting edge software products throughout his career, with specialist knowledge in Application Lifecycle Management (ALM) products from ARCAD Software covering a broad range of functional areas including enterprise IBM i modernization and DevOps.<\/p>\n<p>&nbsp;<\/p>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Discover automated secure test data extraction and anonymization for effective management.<\/p>\n","protected":false},"author":16,"featured_media":62473,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"portfolio_category":[588],"portfolio_skills":[],"portfolio_tags":[462],"class_list":["post-62468","avada_portfolio","type-avada_portfolio","status-publish","format-standard","has-post-thumbnail","hentry","portfolio_category-tech-talk","portfolio_tags-ibm-i-devops"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>IBM i DevOps TechTalk #6 - Test Data Management - Data Extraction<\/title>\n<meta name=\"description\" content=\"In our 6th iDevOps TechTalk podcast, we\u2019ll discuss about Test Data Management with the focus on data extraction.\" \/>\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.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IBM i DevOps TechTalk #6 - Test Data Management - Data Extraction\" \/>\n<meta property=\"og:description\" content=\"In our 6th iDevOps TechTalk podcast, we\u2019ll discuss about Test Data Management with the focus on data extraction.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/\" \/>\n<meta property=\"og:site_name\" content=\"ARCAD\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pages\/Arcad-Software\/116086138469235\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-16T12:09:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2023\/06\/ibm-i-devops-techtalk-tdm-part1-data-extraction.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"18 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/resource-items\\\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\\\/\",\"url\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/resource-items\\\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\\\/\",\"name\":\"IBM i DevOps TechTalk #6 - Test Data Management - Data Extraction\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/resource-items\\\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/resource-items\\\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/ibm-i-devops-techtalk-tdm-part1-data-extraction.jpg\",\"datePublished\":\"2023-06-23T12:52:18+00:00\",\"dateModified\":\"2025-05-16T12:09:42+00:00\",\"description\":\"In our 6th iDevOps TechTalk podcast, we\u2019ll discuss about Test Data Management with the focus on data extraction.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/resource-items\\\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/resource-items\\\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/resource-items\\\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/ibm-i-devops-techtalk-tdm-part1-data-extraction.jpg\",\"contentUrl\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/ibm-i-devops-techtalk-tdm-part1-data-extraction.jpg\",\"width\":600,\"height\":600,\"caption\":\"Banner Techtalk TDM Part 1 Data Extraction\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/resource-items\\\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"ARCAD\",\"item\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Portfolio\",\"item\":\"https:\\\/\\\/www.arcadsoftware.fr\\\/arcad\\\/resource-items\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Test Data Management &#8211; Part 1 Data Extraction\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#website\",\"url\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/\",\"name\":\"ARCAD\",\"description\":\"Experts DevOps &amp; Modernisation sur IBM i (alias AS\\\/400 ou AS400)\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#organization\",\"name\":\"ARCAD Software\",\"url\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/arcad-group-logo-text-144.png\",\"contentUrl\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/arcad-group-logo-text-144.png\",\"width\":144,\"height\":200,\"caption\":\"ARCAD Software\"},\"image\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/pages\\\/Arcad-Software\\\/116086138469235\",\"https:\\\/\\\/x.com\\\/arcad_software\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/arcad-software\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/ARCADSoftwareInc\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"IBM i DevOps TechTalk #6 - Test Data Management - Data Extraction","description":"In our 6th iDevOps TechTalk podcast, we\u2019ll discuss about Test Data Management with the focus on data extraction.","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.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/","og_locale":"en_US","og_type":"article","og_title":"IBM i DevOps TechTalk #6 - Test Data Management - Data Extraction","og_description":"In our 6th iDevOps TechTalk podcast, we\u2019ll discuss about Test Data Management with the focus on data extraction.","og_url":"https:\/\/www.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/","og_site_name":"ARCAD","article_publisher":"https:\/\/www.facebook.com\/pages\/Arcad-Software\/116086138469235","article_modified_time":"2025-05-16T12:09:42+00:00","og_image":[{"width":600,"height":600,"url":"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2023\/06\/ibm-i-devops-techtalk-tdm-part1-data-extraction.jpg","type":"image\/jpeg"}],"twitter_misc":{"Est. reading time":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/","url":"https:\/\/www.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/","name":"IBM i DevOps TechTalk #6 - Test Data Management - Data Extraction","isPartOf":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/#primaryimage"},"image":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/#primaryimage"},"thumbnailUrl":"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2023\/06\/ibm-i-devops-techtalk-tdm-part1-data-extraction.jpg","datePublished":"2023-06-23T12:52:18+00:00","dateModified":"2025-05-16T12:09:42+00:00","description":"In our 6th iDevOps TechTalk podcast, we\u2019ll discuss about Test Data Management with the focus on data extraction.","breadcrumb":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/#primaryimage","url":"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2023\/06\/ibm-i-devops-techtalk-tdm-part1-data-extraction.jpg","contentUrl":"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2023\/06\/ibm-i-devops-techtalk-tdm-part1-data-extraction.jpg","width":600,"height":600,"caption":"Banner Techtalk TDM Part 1 Data Extraction"},{"@type":"BreadcrumbList","@id":"https:\/\/www.arcadsoftware.com\/arcad\/resource-items\/ibm-i-devops-techtalk-6-test-data-management-part-1-data-extraction\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"ARCAD","item":"https:\/\/www.arcadsoftware.com\/arcad\/"},{"@type":"ListItem","position":2,"name":"Portfolio","item":"https:\/\/www.arcadsoftware.fr\/arcad\/resource-items\/"},{"@type":"ListItem","position":3,"name":"Test Data Management &#8211; Part 1 Data Extraction"}]},{"@type":"WebSite","@id":"https:\/\/www.arcadsoftware.com\/arcad\/#website","url":"https:\/\/www.arcadsoftware.com\/arcad\/","name":"ARCAD","description":"Experts DevOps &amp; Modernisation sur IBM i (alias AS\/400 ou AS400)","publisher":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.arcadsoftware.com\/arcad\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.arcadsoftware.com\/arcad\/#organization","name":"ARCAD Software","url":"https:\/\/www.arcadsoftware.com\/arcad\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.arcadsoftware.com\/arcad\/#\/schema\/logo\/image\/","url":"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2017\/09\/arcad-group-logo-text-144.png","contentUrl":"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2017\/09\/arcad-group-logo-text-144.png","width":144,"height":200,"caption":"ARCAD Software"},"image":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/pages\/Arcad-Software\/116086138469235","https:\/\/x.com\/arcad_software","https:\/\/www.linkedin.com\/company\/arcad-software","https:\/\/www.youtube.com\/user\/ARCADSoftwareInc"]}]}},"_links":{"self":[{"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/avada_portfolio\/62468","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/avada_portfolio"}],"about":[{"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/types\/avada_portfolio"}],"author":[{"embeddable":true,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/comments?post=62468"}],"version-history":[{"count":4,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/avada_portfolio\/62468\/revisions"}],"predecessor-version":[{"id":70544,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/avada_portfolio\/62468\/revisions\/70544"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/media\/62473"}],"wp:attachment":[{"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/media?parent=62468"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/portfolio_category?post=62468"},{"taxonomy":"portfolio_skills","embeddable":true,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/portfolio_skills?post=62468"},{"taxonomy":"portfolio_tags","embeddable":true,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/portfolio_tags?post=62468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}