{"id":22219,"date":"2023-01-31T11:05:16","date_gmt":"2023-01-31T10:05:16","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=22219"},"modified":"2023-01-31T13:12:46","modified_gmt":"2023-01-31T12:12:46","slug":"data-staging-with-omrun-migration-part1","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/","title":{"rendered":"Data Staging with OMrun – Migration (part I)"},"content":{"rendered":"\n

OMrun is a powerful tool for data staging that allows you to easily load a wide range of file formats like CSV and XML files in databases. This means, OMrun will automatically detect the data structure and convert it to the appropriate format for your database. It generates reusable SQL queries for every staged file. This can save you a lot of time and effort, especially when working with large datasets. <\/p>\n\n\n\n

\"Test<\/figure>\n\n\n\n

The various data loading processes are orchestrated with the OMrun test scenario. Based on the selected file type, the database table is generated and the corresponding data is loaded. The SQL query is automatically created and saved during the staging process. The stored queries are reusable to gather data from the staged tables within other test objects.<\/p>\n\n\n\n

\"Process<\/figure>\n\n\n\n

In addition to its powerful data staging features, OMrun also offers a variety of other benefits. For example it can be used to perform data validation and cleaning, as well as data transformation and aggregation. This means that you can use OMrun to ensure that your data is clean and accurate before it is loaded into your database.<\/p>\n\n\n\n

Overall, OMrun is a powerful tool for data management that offers a variety of features. Whether you’re working with large datasets or a variety of different data sources, OMrun can help you easily bring all of your data together in one place and ensure that it is clean and accurate.<\/p>\n\n\n\n

Read more about data migration with OMrun in Part 2 coming soon.<\/p>\n\n\n\n

https:\/\/www.dbi-services.com\/products\/omrun\/<\/a><\/p>\n\n\n\n

https:\/\/en.wikipedia.org\/wiki\/Staging_(data)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

OMrun is a powerful tool for data staging that allows you to easily load a wide range of file formats like CSV and XML files in databases. This means, OMrun will automatically detect the data structure and convert it to the appropriate format for your database. It generates reusable SQL queries for every staged file. […]<\/p>\n","protected":false},"author":112,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2725],"tags":[2751],"type_dbi":[2750],"class_list":["post-22219","post","type-post","status-publish","format-standard","hentry","category-omrun","tag-omrun","type-omrun"],"acf":[],"yoast_head":"\nData Staging with OMrun - Migration (part I) - dbi Blog<\/title>\n<meta name=\"description\" content=\"OMrun data migration: data staging from various file types (csv, xml, txt etc.) and from different data sources\" \/>\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.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Staging with OMrun - Migration (part I)\" \/>\n<meta property=\"og:description\" content=\"OMrun data migration: data staging from various file types (csv, xml, txt etc.) and from different data sources\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-31T10:05:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-31T12:12:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/01\/OMrun_DataStaging-1024x385.jpg\" \/>\n<meta name=\"author\" content=\"Frank Zeindler\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Frank Zeindler\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/\"},\"author\":{\"name\":\"Frank Zeindler\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/87e4d01e3243f97b1bfaec931033850b\"},\"headline\":\"Data Staging with OMrun – Migration (part I)\",\"datePublished\":\"2023-01-31T10:05:16+00:00\",\"dateModified\":\"2023-01-31T12:12:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/\"},\"wordCount\":269,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/01\\\/OMrun_DataStaging-1024x385.jpg\",\"keywords\":[\"OMrun\"],\"articleSection\":[\"OMrun\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/\",\"name\":\"Data Staging with OMrun - Migration (part I) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/01\\\/OMrun_DataStaging-1024x385.jpg\",\"datePublished\":\"2023-01-31T10:05:16+00:00\",\"dateModified\":\"2023-01-31T12:12:46+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/87e4d01e3243f97b1bfaec931033850b\"},\"description\":\"OMrun data migration: data staging from various file types (csv, xml, txt etc.) and from different data sources\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/01\\\/OMrun_DataStaging.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/01\\\/OMrun_DataStaging.jpg\",\"width\":2058,\"height\":774},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/data-staging-with-omrun-migration-part1\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Staging with OMrun – Migration (part I)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/87e4d01e3243f97b1bfaec931033850b\",\"name\":\"Frank Zeindler\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1055a5ed28b3ef08572481219dfbd16531efebf908151e83ae4ed850df123a84?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1055a5ed28b3ef08572481219dfbd16531efebf908151e83ae4ed850df123a84?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1055a5ed28b3ef08572481219dfbd16531efebf908151e83ae4ed850df123a84?s=96&d=mm&r=g\",\"caption\":\"Frank Zeindler\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/frankzeindler\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Staging with OMrun - Migration (part I) - dbi Blog","description":"OMrun data migration: data staging from various file types (csv, xml, txt etc.) and from different data sources","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.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/","og_locale":"en_US","og_type":"article","og_title":"Data Staging with OMrun - Migration (part I)","og_description":"OMrun data migration: data staging from various file types (csv, xml, txt etc.) and from different data sources","og_url":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/","og_site_name":"dbi Blog","article_published_time":"2023-01-31T10:05:16+00:00","article_modified_time":"2023-01-31T12:12:46+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/01\/OMrun_DataStaging-1024x385.jpg","type":"","width":"","height":""}],"author":"Frank Zeindler","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Frank Zeindler","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/"},"author":{"name":"Frank Zeindler","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/87e4d01e3243f97b1bfaec931033850b"},"headline":"Data Staging with OMrun – Migration (part I)","datePublished":"2023-01-31T10:05:16+00:00","dateModified":"2023-01-31T12:12:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/"},"wordCount":269,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/01\/OMrun_DataStaging-1024x385.jpg","keywords":["OMrun"],"articleSection":["OMrun"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/","url":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/","name":"Data Staging with OMrun - Migration (part I) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/01\/OMrun_DataStaging-1024x385.jpg","datePublished":"2023-01-31T10:05:16+00:00","dateModified":"2023-01-31T12:12:46+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/87e4d01e3243f97b1bfaec931033850b"},"description":"OMrun data migration: data staging from various file types (csv, xml, txt etc.) and from different data sources","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/01\/OMrun_DataStaging.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/01\/OMrun_DataStaging.jpg","width":2058,"height":774},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/data-staging-with-omrun-migration-part1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Staging with OMrun – Migration (part I)"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/87e4d01e3243f97b1bfaec931033850b","name":"Frank Zeindler","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1055a5ed28b3ef08572481219dfbd16531efebf908151e83ae4ed850df123a84?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1055a5ed28b3ef08572481219dfbd16531efebf908151e83ae4ed850df123a84?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1055a5ed28b3ef08572481219dfbd16531efebf908151e83ae4ed850df123a84?s=96&d=mm&r=g","caption":"Frank Zeindler"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/frankzeindler\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/22219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/112"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=22219"}],"version-history":[{"count":20,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/22219\/revisions"}],"predecessor-version":[{"id":22248,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/22219\/revisions\/22248"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=22219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=22219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=22219"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=22219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}