{"id":43395,"date":"2026-03-16T09:09:00","date_gmt":"2026-03-16T08:09:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=43395"},"modified":"2026-03-16T09:09:00","modified_gmt":"2026-03-16T08:09:00","slug":"ogg-12020-payload-error-in-goldengate-migration-utility","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/","title":{"rendered":"OGG-12020 payload error in GoldenGate Migration Utility"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">While migrating a GoldenGate classic architecture setup with the <a href=\"https:\/\/docs.oracle.com\/en\/database\/goldengate\/core\/26\/coredoc\/migration-utility-migrate-classic-ma.html#GUID-D2515415-01D0-43CB-A439-F13BC9D36D58\" target=\"_blank\" rel=\"noreferrer noopener\">migration utility<\/a>, I recently had the following <code>OGG-12020<\/code> error:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;ERROR] OGG-12020 - The request payload for &amp;#x27;POST \/services\/v2\/config\/files\/ext.prm&amp;#x27; is not defined as an object<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">It is a very cryptic error at first glance, but let&#8217;s try to understand what happened.<\/p>\n\n\n\n<h2 id=\"h-where-does-the-error-come-from\" class=\"wp-block-heading\">Where does the error come from ?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The first step is to understand what is causing the issue. For this, you need to understand how the GoldenGate migration utility works.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When migrating extracts (or any other GoldenGate object), GoldenGate will make <strong>API calls<\/strong> to the new microservices architecture administration service to register the extracts. The <code>OGG-12020<\/code> error is just the API telling you that the <code>POST<\/code> call is invalid.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s use the API log reader from a previous <a href=\"https:\/\/www.dbi-services.com\/blog\/querying-goldengate-rest-api-log-efficiently\/\" target=\"_blank\" rel=\"noreferrer noopener\">blog post<\/a> to ease the analysis. You can also just read through the <code>restapi.log<\/code> of your target deployment, but it will be harder to read.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>python3 restapi_log_reader.py $OGG_DEPLOYMENT_HOME\/var\/log restapi.ndjson<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Using <code>jq<\/code>, we filter the failed <code>POST<\/code> calls against the URI given in the migration logs (<code>\/services\/v2\/config\/files\/ext.prm<\/code>).<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt; jq -c 'select (.request.context.verb == \"POST\" and .request.context.uri == \"\/services\/v2\/config\/files\/ext.prm\" and .restapi_status == \"ERROR\")' restapi.ndjson\n{\"request\":{\"context\":{\"httpContextKey\":140077954104240,\"verbId\":4,\"verb\":\"POST\",\"originalVerb\":\"POST\",\"uri\":\"\/services\/v2\/config\/files\/ext.prm\",\"protocol\":\"https\",\"headers\":{\"Authorization\":\"** Masked **\",\"Content-type\":\"application\/json\",\"User-Agent\":\"Java\/1.8.0_482\",\"Host\":\"oggma:port\",\"Accept\":\"text\/html, image\/gif, image\/jpeg, *; q=.2, *\/*; q=.2\",\"Connection\":\"keep-alive\",\"Content-Length\":\"12417\", \"Content-Type\":null,\"X-OGG-Requestor-Id\":\"\",\"X-OGG-Feature-List\":\"\"},\"host\":\"oggma:port\",\"securityEnabled\":true,\"authorization\":{\"authUserName\":\"ogg_user\",\"authPassword\":\"** Masked **\", \"authMode\":\"Basic\",\"authUserRole\":\"Security\"},\"requestId\":5,\"uriTemplate\":\"\/services\/{version}\/config\/files\/{file}\"},\"content\":null,\"isScaRequest\":true,\"parameters\":{\"uri\":{\"file\":\"ext.prm\",\"version\":\"v2\"}}},\"response\":{\"context\":{\"httpContextKey\":140077954104240,\"requestId\":5,\"code\":\"400 Bad Request\",\"headers\":{\"Content-Type\":\"application\/json\",\"Strict-Transport-Security\":\"max-age=31536000;includeSubDomains\",\"Set-Cookie\":\"** Masked **\"},\"Content-Type\":\"application\/json\",\"contentType\":\"text\/html\"},\"isScaResponse\":true,\"content\":{\"$schema\":\"api:standardResponse\",\"links\":&#091;{\"rel\":\"canonical\",\"href\":\"https:\/\/oggma:port\/services\/v2\/config\/files\/ext.prm\",\"mediaType\":\"text\/html\"},{\"rel\":\"self\",\"href\":\"https:\/\/oggma:port\/services\/v2\/config\/files\/ext.prm\",\"mediaType\":\"text\/html\"}],\"messages\":&#091;{\"$schema\":\"ogg:message\",\"title\":\"The request payload for 'POST \/services\/v2\/config\/files\/ext.prm' is not defined as an object.\",\"code\":\"OGG-12020\",\"severity\":\"ERROR\",\"issued\":\"2026-03-05T09:55:24Z\",\"type\":\"https:\/\/docs.oracle.com\/en\/middleware\/goldengate\/core\/23.26\/error-messages\/\"}]}},\"restapi_datetime\":\"2026-03-05 10:55:24.448+0100\",\"restapi_epoch\":1772704524,\"restapi_status\":\"ERROR\",\"restapi_service\":\"adminsrvr\",\"restapi_reqno\":18}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You might not see the root cause at first, but if we only retrieve the <code>content<\/code> object:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt; jq -c 'select (.request.context.verb == \"POST\" and .request.context.uri == \"\/services\/v2\/config\/files\/ext.prm\" and .restapi_status == \"ERROR\") | {content:.request.content, message:.response.content.messages&#091;0].title}' restapi.ndjson\n{\"content\":null,\"message\":\"The request payload for 'POST \/services\/v2\/config\/files\/ext.prm' is not defined as an object.\"}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The migration utility is sending a request to the API with a <code>null<\/code> content, which obviously fails. Normally, the <code>content<\/code> key should contain a <strong>list with all the lines<\/strong> from the parameter file.<\/p>\n\n\n\n<h2 id=\"h-how-to-solve-this-issue\" class=\"wp-block-heading\">How to solve this issue ?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Unfortunately, there is <strong>no easy solution here<\/strong>. But here are the steps I took to solve the issue.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, you should make sure that the <code>dryrun<\/code> of the migration utility did not highlight any error in the formatting of the file.<\/li>\n\n\n\n<li>Then, make sure you are using the <strong>latest version of the migration utility<\/strong>.<\/li>\n\n\n\n<li>If it still doesn&#8217;t work, you unfortunately found a bug in the migration utility, and there is little you can do.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">However, you can still use the tool to migrate. In my case, I managed to pinpoint the error to this line of the extract parameter file:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>TOKENS (\n    &#091;...]\n    TK_COL = &#091;...] @STRSUB(column_name, '|', '\\|', '\\', '\\\\') &#091;...]\n);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The migration utility seems to have poor handling of these escape characters and does not fail properly. It should either fail before attempting the API call or send proper <code>content<\/code> to the API.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you are sure that the incriminated syntax is valid in your target GoldenGate version, migrate with the following steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Remove the incriminated syntax<\/strong> from the file. In my case, it meant removing the <code>STRSUB<\/code> section of the file.<\/li>\n\n\n\n<li><strong>Migrate<\/strong> with the temporary parameter file<\/li>\n\n\n\n<li><strong>Modify the parameter file<\/strong> in the target GoldenGate deployment, undoing the changes.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If you have a lot of extracts and replicats that need to be migrated, using this temporary file trick might be your best chance to secure your GoldenGate migration.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While migrating a GoldenGate classic architecture setup with the migration utility, I recently had the following OGG-12020 error: It is a very cryptic error at first glance, but let&#8217;s try to understand what happened. Where does the error come from ? The first step is to understand what is causing the issue. For this, you&hellip;&nbsp;<\/p>\n","protected":false},"author":152,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[3787,59],"tags":[979,1545,11061,15,6415,1520],"class_list":["post-43395","post","type-post","status-publish","format-standard","category-goldengate","category-oracle","tag-api","tag-error","tag-goldengate-26ai","tag-migration","tag-oracle-26ai","tag-post"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>OGG-12020 payload error in GoldenGate Migration Utility - dbi services Blog<\/title>\n<meta name=\"description\" content=\"When migrating GoldenGate using the Oracle Migration Utility, an OGG-12020 is the sign that your parameter files cannot be read properly.\" \/>\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\/ogg-12020-payload-error-in-goldengate-migration-utility\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OGG-12020 payload error in GoldenGate Migration Utility\" \/>\n<meta property=\"og:description\" content=\"When migrating GoldenGate using the Oracle Migration Utility, an OGG-12020 is the sign that your parameter files cannot be read properly.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-16T08:09:00+00:00\" \/>\n<meta name=\"author\" content=\"Julien Delattre\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julien Delattre\" \/>\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\\\/ogg-12020-payload-error-in-goldengate-migration-utility\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ogg-12020-payload-error-in-goldengate-migration-utility\\\/\"},\"author\":{\"name\":\"Julien Delattre\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0e990b04385bd7ff84b414bb8d92c544\"},\"headline\":\"OGG-12020 payload error in GoldenGate Migration Utility\",\"datePublished\":\"2026-03-16T08:09:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ogg-12020-payload-error-in-goldengate-migration-utility\\\/\"},\"wordCount\":425,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"keywords\":[\"api\",\"Error\",\"GoldenGate 26ai\",\"Migration\",\"Oracle 26ai\",\"post\"],\"articleSection\":[\"GoldenGate\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ogg-12020-payload-error-in-goldengate-migration-utility\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ogg-12020-payload-error-in-goldengate-migration-utility\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ogg-12020-payload-error-in-goldengate-migration-utility\\\/\",\"name\":\"OGG-12020 payload error in GoldenGate Migration Utility - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2026-03-16T08:09:00+00:00\",\"description\":\"When migrating GoldenGate using the Oracle Migration Utility, an OGG-12020 is the sign that your parameter files cannot be read properly.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ogg-12020-payload-error-in-goldengate-migration-utility\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ogg-12020-payload-error-in-goldengate-migration-utility\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ogg-12020-payload-error-in-goldengate-migration-utility\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OGG-12020 payload error in GoldenGate Migration Utility\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0e990b04385bd7ff84b414bb8d92c544\",\"name\":\"Julien Delattre\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/JDE_Web-1-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/JDE_Web-1-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/JDE_Web-1-scaled.jpg\",\"caption\":\"Julien Delattre\"},\"description\":\"Julien Delattre, member of the Oracle Team Zurich, has more than five years of experience specializing in Oracle databases, plus expertise in MariaDB and MongoDB. Prior to dbi services, he was a Database Administrator at Atos in Angers, France, and a Data Scientist at Air France in Paris and Apurata in Lima. Julien holds a Master's degree in Computer Science, Data Science, and Statistics from Centrale Paris \\\/ Universit\u00e9 Paris-Saclay.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/julien-delattre\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"OGG-12020 payload error in GoldenGate Migration Utility - dbi services Blog","description":"When migrating GoldenGate using the Oracle Migration Utility, an OGG-12020 is the sign that your parameter files cannot be read properly.","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\/ogg-12020-payload-error-in-goldengate-migration-utility\/","og_locale":"en_US","og_type":"article","og_title":"OGG-12020 payload error in GoldenGate Migration Utility","og_description":"When migrating GoldenGate using the Oracle Migration Utility, an OGG-12020 is the sign that your parameter files cannot be read properly.","og_url":"https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2026-03-16T08:09:00+00:00","author":"Julien Delattre","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Julien Delattre","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/"},"author":{"name":"Julien Delattre","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0e990b04385bd7ff84b414bb8d92c544"},"headline":"OGG-12020 payload error in GoldenGate Migration Utility","datePublished":"2026-03-16T08:09:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/"},"wordCount":425,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"keywords":["api","Error","GoldenGate 26ai","Migration","Oracle 26ai","post"],"articleSection":["GoldenGate","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/","url":"https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/","name":"OGG-12020 payload error in GoldenGate Migration Utility - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2026-03-16T08:09:00+00:00","description":"When migrating GoldenGate using the Oracle Migration Utility, an OGG-12020 is the sign that your parameter files cannot be read properly.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/ogg-12020-payload-error-in-goldengate-migration-utility\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"OGG-12020 payload error in GoldenGate Migration Utility"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0e990b04385bd7ff84b414bb8d92c544","name":"Julien Delattre","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/JDE_Web-1-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/JDE_Web-1-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/JDE_Web-1-scaled.jpg","caption":"Julien Delattre"},"description":"Julien Delattre, member of the Oracle Team Zurich, has more than five years of experience specializing in Oracle databases, plus expertise in MariaDB and MongoDB. Prior to dbi services, he was a Database Administrator at Atos in Angers, France, and a Data Scientist at Air France in Paris and Apurata in Lima. Julien holds a Master's degree in Computer Science, Data Science, and Statistics from Centrale Paris \/ Universit\u00e9 Paris-Saclay.","url":"https:\/\/www.dbi-services.com\/blog\/author\/julien-delattre\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43395","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\/152"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=43395"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43395\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=43395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=43395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=43395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}