{"id":4906,"date":"2015-06-12T08:29:34","date_gmt":"2015-06-12T06:29:34","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/"},"modified":"2015-06-12T08:29:34","modified_gmt":"2015-06-12T06:29:34","slug":"qlikview-tips-tricks-the-link-table","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/","title":{"rendered":"QlikView Tips &amp; Tricks: The Link Table"},"content":{"rendered":"<div><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_qlikview-logo.jpg\" alt=\"\" \/><\/div>\n<p>In this blog, I will show you how to bypass a \u201cSynthetic Key\u201d table in QlickView.<\/p>\n<h3>Why bypassing a \u201cSynthetic Key\u201d table?<\/h3>\n<p>If you have multiples links between two tables, QlikView generates automatically a \u201cSynthetic Key\u201d table. (here \u201c$Syn 1\u201d table).<br \/>\nThe QlikView best practice recommend to remove such kind of key table for a question of performance and \u201ccorrectness\u201d of the result.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"1_QV_Link_Table.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1_QV_Link_Table.png\"><img loading=\"lazy\" decoding=\"async\" title=\"1_QV_Link_Table.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1_QV_Link_Table.png\" alt=\"1_QV_Link_Table.PNG\" width=\"560\" height=\"414\" \/><\/a><\/p>\n<h3>How to bypass this \u201cSynthetic key\u201d table?<\/h3>\n<p>The \u201cLink Table\u201d is the solution to bypass the generation of a synthetic key table.<\/p>\n<p>This table will contain two kind of fields:<\/p>\n<ul>\n<li>A \u201cforeign key\u201d, made with the fields that are common to the two tables<\/li>\n<li>The fields that have been used to create the new \u201cforeign key\u201d<\/li>\n<\/ul>\n<p>This \u201cLink Table\u201d will have the following structure:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"2_QV_Link_Table.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2_QV_Link_Table.png\"><img loading=\"lazy\" decoding=\"async\" title=\"2_QV_Link_Table.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2_QV_Link_Table.png\" alt=\"2_QV_Link_Table.PNG\" width=\"170\" height=\"226\" \/><\/a><\/p>\n<p>In our case, the structure of the \u201cLink Table\u201d will be the following:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"3_QV_Link_Table.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3_QV_Link_Table.png\"><img loading=\"lazy\" decoding=\"async\" title=\"3_QV_Link_Table.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3_QV_Link_Table.png\" alt=\"3_QV_Link_Table.PNG\" width=\"293\" height=\"185\" \/><\/a><\/p>\n<h3>How to proceed?<\/h3>\n<h4>Add the needed fields in the linked tables<\/h4>\n<p>Before creating the \u201cLink Table\u201d, we must add the fields in the tables that we should linked together.<br \/>\nRemark: A best practice to create this \u201cForeign_Key\u201d field is to separate the different fields with \u201c|\u201d.<br \/>\nSo, in our case, the fields in the table SALESDETAILS will be added as follow:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"4_QV_Link_Table.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/4_QV_Link_Table.png\"><img loading=\"lazy\" decoding=\"async\" title=\"4_QV_Link_Table.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/4_QV_Link_Table.png\" alt=\"4_QV_Link_Table.PNG\" width=\"570\" height=\"58\" \/><\/a><\/p>\n<p>The fields in table BUDGET will be added as follow:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"5_QV_Link_Table.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/5_QV_Link_Table.png\"><img loading=\"lazy\" decoding=\"async\" title=\"5_QV_Link_Table.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/5_QV_Link_Table.png\" alt=\"5_QV_Link_Table.PNG\" width=\"567\" height=\"57\" \/><\/a><\/p>\n<h4>Create the \u201cLink table\u201d<\/h4>\n<p>The fields to create the \u201cLink Table\u201d are now added. So we can create the table as follow:<br \/>\nClick on \u201cTab \/ Add Tab\u201d and name it \u201cLINK_TABLE\u201d (1).<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"6_QV_Link_Table.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/6_QV_Link_Table.png\"><img loading=\"lazy\" decoding=\"async\" title=\"6_QV_Link_Table.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/6_QV_Link_Table.png\" alt=\"6_QV_Link_Table.PNG\" width=\"264\" height=\"168\" \/><\/a><\/p>\n<p>Type the following script:<\/p>\n<p>(1) The name of the table<br \/>\n(2)The names of the fields should be the same in each table<br \/>\n(3) Use the CONCATENATE instruction<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"7_QV_Link_Table.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/7_QV_Link_Table.png\"><img loading=\"lazy\" decoding=\"async\" title=\"7_QV_Link_Table.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/7_QV_Link_Table.png\" alt=\"7_QV_Link_Table.PNG\" width=\"570\" height=\"183\" \/><\/a><\/p>\n<p>Reload the data (1) and check the result (2)<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"8_QV_Link_Table.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/8_QV_Link_Table.png\"><img loading=\"lazy\" decoding=\"async\" title=\"8_QV_Link_Table.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/8_QV_Link_Table.png\" alt=\"8_QV_Link_Table.PNG\" width=\"571\" height=\"267\" \/><\/a><\/p>\n<p>The result should be like this:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"9_QV_Link_Table.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/9_QV_Link_Table.png\"><img loading=\"lazy\" decoding=\"async\" title=\"9_QV_Link_Table.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/9_QV_Link_Table.png\" alt=\"9_QV_Link_Table.PNG\" width=\"570\" height=\"264\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, I will show you how to bypass a \u201cSynthetic Key\u201d table in QlickView. Why bypassing a \u201cSynthetic Key\u201d table? If you have multiples links between two tables, QlikView generates automatically a \u201cSynthetic Key\u201d table. (here \u201c$Syn 1\u201d table). The QlikView best practice recommend to remove such kind of key table for a [&hellip;]<\/p>\n","protected":false},"author":17,"featured_media":4907,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[294],"tags":[],"type_dbi":[],"class_list":["post-4906","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>QlikView Tips &amp; Tricks: The Link Table - dbi Blog<\/title>\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\/qlikview-tips-tricks-the-link-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Tips &amp; Tricks: The Link Table\" \/>\n<meta property=\"og:description\" content=\"In this blog, I will show you how to bypass a \u201cSynthetic Key\u201d table in QlickView. Why bypassing a \u201cSynthetic Key\u201d table? If you have multiples links between two tables, QlikView generates automatically a \u201cSynthetic Key\u201d table. (here \u201c$Syn 1\u201d table). The QlikView best practice recommend to remove such kind of key table for a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-12T06:29:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_qlikview-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"134\" \/>\n\t<meta property=\"og:image:height\" content=\"100\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Alain Lacour\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alain Lacour\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/\"},\"author\":{\"name\":\"Alain Lacour\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"headline\":\"QlikView Tips &amp; Tricks: The Link Table\",\"datePublished\":\"2015-06-12T06:29:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/\"},\"wordCount\":287,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_qlikview-logo.jpg\",\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/\",\"name\":\"QlikView Tips &amp; Tricks: The Link Table - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_qlikview-logo.jpg\",\"datePublished\":\"2015-06-12T06:29:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_qlikview-logo.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_qlikview-logo.jpg\",\"width\":134,\"height\":100},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"QlikView Tips &amp; Tricks: The Link Table\"}]},{\"@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\/acabba2b6ca473b44b098c2de61294b0\",\"name\":\"Alain Lacour\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"caption\":\"Alain Lacour\"},\"description\":\"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&amp;H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"QlikView Tips &amp; Tricks: The Link Table - dbi Blog","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\/qlikview-tips-tricks-the-link-table\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Tips &amp; Tricks: The Link Table","og_description":"In this blog, I will show you how to bypass a \u201cSynthetic Key\u201d table in QlickView. Why bypassing a \u201cSynthetic Key\u201d table? If you have multiples links between two tables, QlikView generates automatically a \u201cSynthetic Key\u201d table. (here \u201c$Syn 1\u201d table). The QlikView best practice recommend to remove such kind of key table for a [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/","og_site_name":"dbi Blog","article_published_time":"2015-06-12T06:29:34+00:00","og_image":[{"width":134,"height":100,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_qlikview-logo.jpg","type":"image\/jpeg"}],"author":"Alain Lacour","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alain Lacour","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/"},"author":{"name":"Alain Lacour","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"headline":"QlikView Tips &amp; Tricks: The Link Table","datePublished":"2015-06-12T06:29:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/"},"wordCount":287,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_qlikview-logo.jpg","articleSection":["Business Intelligence"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/","url":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/","name":"QlikView Tips &amp; Tricks: The Link Table - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_qlikview-logo.jpg","datePublished":"2015-06-12T06:29:34+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_qlikview-logo.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_qlikview-logo.jpg","width":134,"height":100},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-tips-tricks-the-link-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"QlikView Tips &amp; Tricks: The Link Table"}]},{"@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\/acabba2b6ca473b44b098c2de61294b0","name":"Alain Lacour","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","caption":"Alain Lacour"},"description":"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&amp;H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.","url":"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4906","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\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4906"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4906\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4907"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4906"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}