{"id":23289,"date":"2021-04-12T07:11:44","date_gmt":"2021-04-12T07:11:44","guid":{"rendered":"https:\/\/ultragenicglobal.com\/?p=23289"},"modified":"2024-02-22T04:53:25","modified_gmt":"2024-02-22T04:53:25","slug":"leading-cro-achieves-significant-cost-and-time-saving-with-our-fully-automated-data-extraction-and-migration-tool-ultramig","status":"publish","type":"post","link":"https:\/\/www.fyeo.in\/ultragenic\/leading-cro-achieves-significant-cost-and-time-saving-with-our-fully-automated-data-extraction-and-migration-tool-ultramig\/","title":{"rendered":"Leading CRO achieves significant cost and time saving with our Fully Automated Data Extraction and Migration Tool, UltraMIG."},"content":{"rendered":"<section data-vc-full-width=\"true\" data-vc-full-width-init=\"false\" class=\"vc_row wpb_row vc_row-fluid  vc_custom_1617789184205 vc_row-has-fill pofo-stretch-content pofo-stretch-row-container\"><div class=\"wpb_column vc_column_container vc_col-sm-12  col-xs-mobile-fullwidth\"><div class=\"vc_column-inner \"><div class=\"wpb_wrapper\"><\/div><\/div><\/div><\/section><div class=\"vc_row-full-width vc_clearfix\"><\/div><section class=\"vc_row wpb_row vc_row-fluid  vc_custom_1617790463776 position-relative vc_row-has-fill\"><div class=\"wpb_column vc_column_container  col-xs-mobile-fullwidth\"><div class=\"vc_column-inner \"><div class=\"wpb_wrapper\"><div class=\"vc_row wpb_row vc_inner vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12  col-xs-mobile-fullwidth text-justify\"><div class=\"vc_column-inner \"><div class=\"wpb_wrapper\"><h4 class=\"text-extra-dark-gray margin-20px-bottom font-weight-600 display-inline-block alt-font heading-style2  heading-1\"  style=\"font-size: 30px; line-height: 42px; font-weight: 600; color: #223d77;\" data-fontsize=\"30px\" data-lineheight=\"42px\">Leading CRO achieves significant cost and time saving with our Fully Automated Data Extraction and Migration Tool, UltraMIG.<\/h4><\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_inner vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-6  col-xs-mobile-fullwidth\"><div class=\"vc_column-inner vc_custom_1617790621498\"><div class=\"wpb_wrapper\"><h6 class=\"text-extra-dark-gray margin-20px-bottom font-weight-600 display-inline-block alt-font heading-style2  heading-2\"  style=\"font-size: 30px; font-weight: 700; color: #223d77;\" data-fontsize=\"30px\">The Challenge<\/h6><div class=\"last-paragraph-no-margin\"><p>The client, a Contract Research Organization (CRO), has a tenant who has decided to offboard from their Argus Safety System. The CRO needs to extract all of the tenant\u2019s data and share it with them to complete the offboarding process. They have limited time of a few weeks and it is critical for the CRO to complete the process within this short time span.<\/p>\n<\/div><\/div><\/div><\/div><div class=\"wpb_column vc_column_container vc_col-has-fill vc_col-sm-6  col-xs-mobile-fullwidth\"><div class=\"vc_column-inner vc_custom_1617790634491\"><div class=\"wpb_wrapper\"><div class=\"last-paragraph-no-margin\" style=\"color: #ffffff;\"><p><strong style=\"font-size: 24px;\">Key Deliverables<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Extract all cases in SQL DUMP format<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Extraction output should include the following:<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Extraction case listing<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Extracted data in Oracle .dmp file with the following content:<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">All Case Data Tables<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">All ESM Data Tables<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">All Configuration Tables<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">All DLP Tables<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Two extracts are required at an interval of 1.5 months (one from the development environment and one from the production environment)<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div><\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_inner vc_row-fluid  vc_custom_1617790432464\"><div class=\"wpb_column vc_column_container vc_col-sm-12  col-xs-mobile-fullwidth\"><div class=\"vc_column-inner \"><div class=\"wpb_wrapper\"><div class=\"separator-line-horrizontal-full bg-extra-light-gray center-col pofo-separator\" style=\"background-color:#ededed; min-height: 1px; width: 100%;\"><\/div><\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_inner vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12  col-xs-mobile-fullwidth\"><div class=\"vc_column-inner \"><div class=\"wpb_wrapper\"><h6 class=\"text-extra-dark-gray margin-20px-bottom font-weight-600 display-inline-block alt-font heading-style2  heading-3\"  style=\"font-size: 30px; font-weight: 700; color: #223d77;\" data-fontsize=\"30px\">Our Approach (Solution)<\/h6><div class=\"last-paragraph-no-margin\"><p>Data extraction is a time-consuming and intensive process. With the CRO working with a tight timeline, it was always going to be a challenge to ensure timely data extraction, while achieving 100% data accuracy.<\/p>\n<p>We deployed the \u2018Extract\u2019 module of our proprietary and fully automated Data Migration Tool, <strong>UltraMIG<\/strong>. Our team started with an impact assessment on the client brief and finalized the key deliverables. Then we configured UltraMIG as per the specific requirements of the extract and added the auto verification criteria to validate the accuracy of the extract. Once the extract was executed and verified, we created the Oracle dump file that the client required.<\/p>\n<p>Whereas a manual process would have taken weeks and even months to complete, UltraMIG delivered the first extract within one week. The process being fully automated, and the tool already configured for the client, the second extract (needed by client after 1.5 months of the first one) was achieved within a few hours.<\/p>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section><section data-vc-full-width=\"true\" data-vc-full-width-init=\"false\" class=\"vc_row wpb_row vc_row-fluid  vc_custom_1617790380832 vc_row-has-fill pofo-stretch-content pofo-stretch-row-container\"><div class=\"wpb_column vc_column_container vc_col-sm-6  col-xs-mobile-fullwidth\"><div class=\"vc_column-inner vc_custom_1617790191811\"><div class=\"wpb_wrapper\"><h6 class=\"text-extra-dark-gray margin-20px-bottom font-weight-600 display-inline-block alt-font heading-style2  heading-4\"  style=\"font-size: 30px; font-weight: 700; color: #223d77;\" data-fontsize=\"30px\">Client Benefits<\/h6><div class=\"last-paragraph-no-margin\"><p>Ultragenic was able to achieve the client\u2019s requirements within the project\u2019s stated timeline, ensuring the offboarding of tenant could take place without any complications. Since UltraMIG comes with built-in validations and requires minimal human intervention, the data quality was predictable and free of any human-error. <\/p>\n<\/div><\/div><\/div><\/div><div class=\"wpb_column vc_column_container vc_col-sm-6  col-xs-mobile-fullwidth\"><div class=\"vc_column-inner \"><div class=\"wpb_wrapper\"><div class=\"vc_row wpb_row vc_inner vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-6  col-xs-mobile-fullwidth text-center\"><div class=\"vc_column-inner vc_custom_1617790129458\"><div class=\"wpb_wrapper\"><h4 class=\"text-extra-dark-gray margin-20px-bottom font-weight-600 display-inline-block alt-font heading-style2  vc_custom_1617796124013  heading-5\"  style=\"line-height: 50px; font-weight: 700; color: #223d77;\" data-lineheight=\"50px\">50% +<\/h4><div class=\"last-paragraph-no-margin\"><p>Cost Saving<\/p>\n<\/div><\/div><\/div><\/div><div class=\"wpb_column vc_column_container vc_col-sm-6  col-xs-mobile-fullwidth text-center\"><div class=\"vc_column-inner vc_custom_1617790137470\"><div class=\"wpb_wrapper\"><h4 class=\"text-extra-dark-gray margin-20px-bottom font-weight-600 display-inline-block alt-font heading-style2  vc_custom_1617796131192  heading-6\"  style=\"line-height: 50px; font-weight: 700; color: #223d77;\" data-lineheight=\"50px\">40% +<\/h4><div class=\"last-paragraph-no-margin\"><p>Time Efficiency<\/p>\n<\/div><\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_inner vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-6  col-xs-mobile-fullwidth text-center\"><div class=\"vc_column-inner vc_custom_1617790148109\"><div class=\"wpb_wrapper\"><h4 class=\"text-extra-dark-gray margin-20px-bottom font-weight-600 display-inline-block alt-font heading-style2  vc_custom_1617796138464  heading-7\"  style=\"line-height: 50px; font-weight: 700; color: #223d77;\" data-lineheight=\"50px\">2<\/h4><div class=\"last-paragraph-no-margin\"><p>Extraction Cycles<\/p>\n<\/div><\/div><\/div><\/div><div class=\"wpb_column vc_column_container vc_col-sm-6  col-xs-mobile-fullwidth text-center\"><div class=\"vc_column-inner vc_custom_1617790155732\"><div class=\"wpb_wrapper\"><h4 class=\"text-extra-dark-gray margin-20px-bottom font-weight-600 display-inline-block alt-font heading-style2  vc_custom_1617796144230  heading-8\"  style=\"line-height: 50px; font-weight: 700; color: #223d77;\" data-lineheight=\"50px\">100%<\/h4><div class=\"last-paragraph-no-margin\"><p>Data Extract Accuracy<\/p>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section><div class=\"vc_row-full-width vc_clearfix\"><\/div><section class=\"vc_row wpb_row vc_row-fluid  vc_custom_1617793095950\"><div class=\"wpb_column vc_column_container vc_col-sm-12  col-xs-mobile-fullwidth text-center\"><div class=\"vc_column-inner \"><div class=\"wpb_wrapper\"><h6 class=\"text-extra-dark-gray margin-20px-bottom font-weight-600 display-block alt-font heading-style2  heading-9\"  style=\"font-weight: 600; color: #223d77;\">Share this Impact Study<\/h6><div class=\"last-paragraph-no-margin\"><div class=\"sfsi_widget sfsi_shortcode_container\"><div class=\"norm_row sfsi_wDiv \"  style=\"width:325px;text-align:center;\"><div style='width:50px; height:50px;margin-left:15px;margin-bottom:5px; ' class='sfsi_wicons shuffeldiv ' ><div class='inerCnt'><a class=' sficn' data-effect='fade_in' target='_blank'  href='' id='sfsiid_facebook_icon' style='width:50px;height:50px;opacity:0.6;'  ><img data-pin-nopin='true' alt='Facebook' title='Facebook' src='https:\/\/www.fyeo.in\/ultragenic\/wp-content\/plugins\/ultimate-social-media-icons\/images\/icons_theme\/thin\/thin_facebook.png' width='50' height='50' style='' class='sfcm sfsi_wicon ' data-effect='fade_in'   \/><\/a><div class=\"sfsi_tool_tip_2 fb_tool_bdr sfsiTlleft\" style=\"opacity:0;z-index:-1;\" id=\"sfsiid_facebook\"><span class=\"bot_arow bot_fb_arow\"><\/span><div class=\"sfsi_inside\"><div  class='icon2'><div class=\"fb-like\" width=\"200\" data-href=\"https:\/\/www.fyeo.in\/ultragenic\/leading-cro-achieves-significant-cost-and-time-saving-with-our-fully-automated-data-extraction-and-migration-tool-ultramig\/\"  data-send=\"false\" data-layout=\"button_count\" data-action=\"like\"><\/div><\/div><div  class='icon3'><a target='_blank' href='https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Fwww.fyeo.in%2Fultragenic%2Fwp-json%2Fwp%2Fv2%2Fposts%2F23289' style='display:inline-block;'  > <img class='sfsi_wicon'  data-pin-nopin='true' alt='fb-share-icon' title='Facebook Share' src='https:\/\/www.fyeo.in\/ultragenic\/wp-content\/plugins\/ultimate-social-media-icons\/images\/share_icons\/fb_icons\/en_US.svg' \/><\/a><\/div><\/div><\/div><\/div><\/div><div style='width:50px; height:50px;margin-left:15px;margin-bottom:5px; ' class='sfsi_wicons shuffeldiv ' ><div class='inerCnt'><a class=' sficn' data-effect='fade_in' target='_blank'  href='' id='sfsiid_twitter_icon' style='width:50px;height:50px;opacity:0.6;'  ><img data-pin-nopin='true' alt='Twitter' title='Twitter' src='https:\/\/www.fyeo.in\/ultragenic\/wp-content\/plugins\/ultimate-social-media-icons\/images\/icons_theme\/thin\/thin_twitter.png' width='50' height='50' style='' class='sfcm sfsi_wicon ' data-effect='fade_in'   \/><\/a><div class=\"sfsi_tool_tip_2 twt_tool_bdr sfsiTlleft\" style=\"opacity:0;z-index:-1;\" id=\"sfsiid_twitter\"><span class=\"bot_arow bot_twt_arow\"><\/span><div class=\"sfsi_inside\"><div  class='icon2'><div class='sf_twiter' style='display: inline-block;vertical-align: middle;width: auto;'>\r\n\t\t\t\t\t\t<a target='_blank' href='https:\/\/x.com\/intent\/post?text=Hey%2C+check+out+this+cool+site+I+found%3A+www.yourname.com+%23Topic+via%40my_twitter_name+https%3A%2F%2Fwww.fyeo.in%2Fultragenic%2Fwp-json%2Fwp%2Fv2%2Fposts%2F23289' style='display:inline-block' >\r\n\t\t\t\t\t\t\t<img data-pin-nopin= true class='sfsi_wicon' src='https:\/\/www.fyeo.in\/ultragenic\/wp-content\/plugins\/ultimate-social-media-icons\/images\/share_icons\/Twitter_Tweet\/en_US_Tweet.svg' alt='Post on X' title='Post on X' >\r\n\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t<\/div><\/div><\/div><\/div><\/div><\/div><div style='width:50px; height:50px;margin-left:15px;margin-bottom:5px; ' class='sfsi_wicons shuffeldiv ' ><div class='inerCnt'><a class=' sficn' data-effect='fade_in' target='_blank'  href='' id='sfsiid_linkedin_icon' style='width:50px;height:50px;opacity:0.6;'  ><img data-pin-nopin='true' alt='LinkedIn' title='LinkedIn' src='https:\/\/www.fyeo.in\/ultragenic\/wp-content\/plugins\/ultimate-social-media-icons\/images\/icons_theme\/thin\/thin_linkedin.png' width='50' height='50' style='' class='sfcm sfsi_wicon ' data-effect='fade_in'   \/><\/a><div class=\"sfsi_tool_tip_2 linkedin_tool_bdr sfsiTlleft\" style=\"opacity:0;z-index:-1;\" id=\"sfsiid_linkedin\"><span class=\"bot_arow bot_linkedin_arow\"><\/span><div class=\"sfsi_inside\"><div  class='icon2'><a target='_blank' href=\"https:\/\/www.linkedin.com\/sharing\/share-offsite\/?url=https%3A%2F%2Fwww.fyeo.in%2Fultragenic%2Fwp-json%2Fwp%2Fv2%2Fposts%2F23289\"><img decoding=\"async\" class=\"sfsi_wicon\" data-pin-nopin= true alt=\"Share\" title=\"Share\" src=\"https:\/\/www.fyeo.in\/ultragenic\/wp-content\/plugins\/ultimate-social-media-icons\/images\/share_icons\/Linkedin_Share\/en_US_share.svg\" \/><\/a><\/div><\/div><\/div><\/div><\/div><\/div ><div id=\"sfsi_holder\" class=\"sfsi_holders\" style=\"position: relative; float: left;width:100%;z-index:-1;\"><\/div ><script>window.addEventListener(\"sfsi_functions_loaded\", function()\n\t\t\t{\n\t\t\t\tif (typeof sfsi_widget_set == \"function\") {\n\t\t\t\t\tsfsi_widget_set();\n\t\t\t\t}\n\t\t\t}); <\/script><div style=\"clear: both;\"><\/div><\/div>\n<\/div><\/div><\/div><\/div><\/section><section class=\"vc_row wpb_row vc_row-fluid  vc_custom_1617791385843\"><div class=\"wpb_column vc_column_container vc_col-sm-12  col-xs-mobile-fullwidth\"><div class=\"vc_column-inner \"><div class=\"wpb_wrapper\"><div class=\"separator-line-horrizontal-full bg-extra-light-gray center-col pofo-separator\" style=\"background-color:#ededed; min-height: 1px; width: 100%;\"><\/div><\/div><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"<p>The client, a Contract Research Organization (CRO), has a tenant who has decided to &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[91],"tags":[],"class_list":["post-23289","post","type-post","status-publish","format-standard","hentry","category-casestudy"],"_links":{"self":[{"href":"https:\/\/www.fyeo.in\/ultragenic\/wp-json\/wp\/v2\/posts\/23289","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyeo.in\/ultragenic\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyeo.in\/ultragenic\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyeo.in\/ultragenic\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyeo.in\/ultragenic\/wp-json\/wp\/v2\/comments?post=23289"}],"version-history":[{"count":5,"href":"https:\/\/www.fyeo.in\/ultragenic\/wp-json\/wp\/v2\/posts\/23289\/revisions"}],"predecessor-version":[{"id":24747,"href":"https:\/\/www.fyeo.in\/ultragenic\/wp-json\/wp\/v2\/posts\/23289\/revisions\/24747"}],"wp:attachment":[{"href":"https:\/\/www.fyeo.in\/ultragenic\/wp-json\/wp\/v2\/media?parent=23289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyeo.in\/ultragenic\/wp-json\/wp\/v2\/categories?post=23289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyeo.in\/ultragenic\/wp-json\/wp\/v2\/tags?post=23289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}