{"id":91,"date":"2011-12-12T09:39:06","date_gmt":"2011-12-12T08:39:06","guid":{"rendered":"http:\/\/blogs.encamina.com\/mascrm\/?p=91"},"modified":"2015-06-12T07:48:16","modified_gmt":"2015-06-12T06:48:16","slug":"integracion-cegedim-onekey-microsoft-dynamics-crm","status":"publish","type":"post","link":"https:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/","title":{"rendered":"Integraci\u00f3n de datos CEGEDIM – OneKey en Microsoft Dynamics CRM"},"content":{"rendered":"

\"\"<\/a> \"\"<\/a> \"\"<\/a><\/p>\n

CEGEDIM<\/a> es la compa\u00f1\u00eda, l\u00edder en su sector, que proporciona datos sobre los profesionales m\u00e9dicos a los principales fabricantes del sector farmac\u00e9utico.<\/p>\n

JUSTE S.A.Q.F.<\/a> es un laboratorio farmac\u00e1utico que investiga, desarrolla y distribuye productos tanto en Espa\u00f1a como M\u00e9jico, Brasil y Argentina.<\/p>\n

Este art\u00edculo describe la integraci\u00f3n entre la base de datos de CEGEDIM (OneKey)<\/a> y Microsoft Dynamics CRM<\/a> realizada para JUSTE S.A.Q.F.<\/a><\/p>\n

\n

\"\"<\/a><\/p>\n

<\/span>Los datos de origen CEGEDIM: OneKey<\/span><\/p>\n

CEGEDIM proporciona los datos a trav\u00e9s de su base de datos ‘sindicada’ denominada OneKey<\/a>.
\nPara ello, pone a disposici\u00f3n de sus clientes un acceso FTP para el intercambio de los archivos necesarios (Individuos, Centros, Afiliaciones…).<\/p>\n

Y unas especificaciones con el formato y operativa para el desarrollo de los procesos de integraci\u00f3n.<\/p>\n\n\n\n\n
\"\"<\/a><\/td>\n<\/tr>\n
Base de datos intermedia JUSTE<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/p>\n

La base de datos intermedia: OneKey<\/span><\/p>\n

Diferentes procesos diarios de sincronizaci\u00f3n intercambian ficheros entre JUSTE y OneKey.<\/p>\n

JUSTE env\u00eda las modificaciones realizadas en su sistema CRM a OneKey y recibe las modificaciones que OneKey proporciona a sus clientes.<\/p>\n

Dichos datos se decodifican e insertan en una base de datos intermedia ubicada ya en los servidores de JUSTE.<\/p>\n\n\n\n\n
\"\"<\/a><\/td>\n<\/tr>\n
Procesos de integraci\u00f3n XMLSynchro<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Los procesos de sincronizaci\u00f3n entre la base de datos intermedia OneKey y Microsoft Dynamics CRM<\/span><\/p>\n

Desde la base de datos intermedia, diferentes procesos desarrollados con la herramienta XMLSynchro<\/a> ejecutan la integraci\u00f3n de datos con Microsoft Dynamics CRM.<\/p>\n

El resultado<\/span><\/p>\n

Los profesionales m\u00e9dicos, centros y direcciones de visita de OneKey integrados en CRM.<\/p>\n

\"Microsoft<\/a>

Microsoft Dynamics CRM<\/p><\/div><\/p>\n

JUSTE obtiene datos, permanentemente actualizados, sobre los profesionales m\u00e9dicos que constituyen sus clientes potenciales a la vez que env\u00eda a OneKey las modificaciones que introduce en CRM.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

CEGEDIM es la compa\u00f1\u00eda, l\u00edder en su sector, que proporciona datos sobre los profesionales m\u00e9dicos a los principales fabricantes del sector farmac\u00e9utico. JUSTE S.A.Q.F. es un laboratorio farmac\u00e1utico que investiga, desarrolla y distribuye productos tanto en Espa\u00f1a como M\u00e9jico, Brasil … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[92,6,91,96,38,93],"tags":[79,81,98,82,100],"class_list":["post-91","post","type-post","status-publish","format-standard","hentry","category-architecture","category-automatizacion","category-consultancy","category-project-management","category-integration","category-methodology","tag-cegedim","tag-health","tag-integration","tag-juste","tag-xrm"],"yoast_head":"\nIntegraci\u00f3n de datos CEGEDIM - OneKey en Microsoft Dynamics CRM - M\u00e1s CRM<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Juan Ribes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/12\\\/12\\\/integracion-cegedim-onekey-microsoft-dynamics-crm\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/12\\\/12\\\/integracion-cegedim-onekey-microsoft-dynamics-crm\\\/\"},\"author\":{\"name\":\"Juan Ribes\",\"@id\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/#\\\/schema\\\/person\\\/148a37e227c5716102c71c3ab092d73b\"},\"headline\":\"Integraci\u00f3n de datos CEGEDIM – OneKey en Microsoft Dynamics CRM\",\"datePublished\":\"2011-12-12T08:39:06+00:00\",\"dateModified\":\"2015-06-12T06:48:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/12\\\/12\\\/integracion-cegedim-onekey-microsoft-dynamics-crm\\\/\"},\"wordCount\":312,\"commentCount\":2,\"image\":{\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/12\\\/12\\\/integracion-cegedim-onekey-microsoft-dynamics-crm\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/2.bp.blogspot.com\\\/-DxIbucefx-g\\\/TkOAu9UCV0I\\\/AAAAAAAAAXQ\\\/oEthlGOAdv0\\\/s200\\\/CEGEDIM.png\",\"keywords\":[\"CEGEDIM\",\"Health\",\"Integraci\u00f3n\",\"JUSTE\",\"XRM\"],\"articleSection\":[\"Arquitectura\",\"Automatizaci\u00f3n\",\"Consultor\u00eda\",\"Gesti\u00f3n de proyectos\",\"Integraci\u00f3n\",\"Metodolog\u00eda\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/12\\\/12\\\/integracion-cegedim-onekey-microsoft-dynamics-crm\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/12\\\/12\\\/integracion-cegedim-onekey-microsoft-dynamics-crm\\\/\",\"url\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/12\\\/12\\\/integracion-cegedim-onekey-microsoft-dynamics-crm\\\/\",\"name\":\"Integraci\u00f3n de datos CEGEDIM - OneKey en Microsoft Dynamics CRM - M\u00e1s CRM\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/12\\\/12\\\/integracion-cegedim-onekey-microsoft-dynamics-crm\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/12\\\/12\\\/integracion-cegedim-onekey-microsoft-dynamics-crm\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/2.bp.blogspot.com\\\/-DxIbucefx-g\\\/TkOAu9UCV0I\\\/AAAAAAAAAXQ\\\/oEthlGOAdv0\\\/s200\\\/CEGEDIM.png\",\"datePublished\":\"2011-12-12T08:39:06+00:00\",\"dateModified\":\"2015-06-12T06:48:16+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/#\\\/schema\\\/person\\\/148a37e227c5716102c71c3ab092d73b\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/12\\\/12\\\/integracion-cegedim-onekey-microsoft-dynamics-crm\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/12\\\/12\\\/integracion-cegedim-onekey-microsoft-dynamics-crm\\\/#primaryimage\",\"url\":\"http:\\\/\\\/2.bp.blogspot.com\\\/-DxIbucefx-g\\\/TkOAu9UCV0I\\\/AAAAAAAAAXQ\\\/oEthlGOAdv0\\\/s200\\\/CEGEDIM.png\",\"contentUrl\":\"http:\\\/\\\/2.bp.blogspot.com\\\/-DxIbucefx-g\\\/TkOAu9UCV0I\\\/AAAAAAAAAXQ\\\/oEthlGOAdv0\\\/s200\\\/CEGEDIM.png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/#website\",\"url\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/\",\"name\":\"M\u00e1s CRM\",\"description\":\"Reflexiones y apuntes sobre arquitectura, consultor\u00eda y gesti\u00f3n proyectos CRM\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/#\\\/schema\\\/person\\\/148a37e227c5716102c71c3ab092d73b\",\"name\":\"Juan Ribes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g\",\"caption\":\"Juan Ribes\"},\"description\":\"Director de Servicios CRM en ENCAMINA. Responsable de la implantaci\u00f3n los proyectos CRM en ENCAMINA desde 2005, principalmente con Microsoft Dynamics.\",\"sameAs\":[\"http:\\\/\\\/www.encamina.com\",\"http:\\\/\\\/www.facebook.com\\\/juan.ribes.andres\",\"http:\\\/\\\/es.linkedin.com\\\/in\\\/juanribes\",\"http:\\\/\\\/pinterest.com\\\/jribes\",\"https:\\\/\\\/x.com\\\/jribes\"],\"url\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/author\\\/jribes\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Integraci\u00f3n de datos CEGEDIM - OneKey en Microsoft Dynamics CRM - M\u00e1s CRM","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":"http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/","twitter_misc":{"Escrito por":"Juan Ribes","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/#article","isPartOf":{"@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/"},"author":{"name":"Juan Ribes","@id":"https:\/\/blogs.encamina.com\/mascrm\/#\/schema\/person\/148a37e227c5716102c71c3ab092d73b"},"headline":"Integraci\u00f3n de datos CEGEDIM – OneKey en Microsoft Dynamics CRM","datePublished":"2011-12-12T08:39:06+00:00","dateModified":"2015-06-12T06:48:16+00:00","mainEntityOfPage":{"@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/"},"wordCount":312,"commentCount":2,"image":{"@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/2.bp.blogspot.com\/-DxIbucefx-g\/TkOAu9UCV0I\/AAAAAAAAAXQ\/oEthlGOAdv0\/s200\/CEGEDIM.png","keywords":["CEGEDIM","Health","Integraci\u00f3n","JUSTE","XRM"],"articleSection":["Arquitectura","Automatizaci\u00f3n","Consultor\u00eda","Gesti\u00f3n de proyectos","Integraci\u00f3n","Metodolog\u00eda"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/","url":"http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/","name":"Integraci\u00f3n de datos CEGEDIM - OneKey en Microsoft Dynamics CRM - M\u00e1s CRM","isPartOf":{"@id":"https:\/\/blogs.encamina.com\/mascrm\/#website"},"primaryImageOfPage":{"@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/#primaryimage"},"image":{"@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/2.bp.blogspot.com\/-DxIbucefx-g\/TkOAu9UCV0I\/AAAAAAAAAXQ\/oEthlGOAdv0\/s200\/CEGEDIM.png","datePublished":"2011-12-12T08:39:06+00:00","dateModified":"2015-06-12T06:48:16+00:00","author":{"@id":"https:\/\/blogs.encamina.com\/mascrm\/#\/schema\/person\/148a37e227c5716102c71c3ab092d73b"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/12\/12\/integracion-cegedim-onekey-microsoft-dynamics-crm\/#primaryimage","url":"http:\/\/2.bp.blogspot.com\/-DxIbucefx-g\/TkOAu9UCV0I\/AAAAAAAAAXQ\/oEthlGOAdv0\/s200\/CEGEDIM.png","contentUrl":"http:\/\/2.bp.blogspot.com\/-DxIbucefx-g\/TkOAu9UCV0I\/AAAAAAAAAXQ\/oEthlGOAdv0\/s200\/CEGEDIM.png"},{"@type":"WebSite","@id":"https:\/\/blogs.encamina.com\/mascrm\/#website","url":"https:\/\/blogs.encamina.com\/mascrm\/","name":"M\u00e1s CRM","description":"Reflexiones y apuntes sobre arquitectura, consultor\u00eda y gesti\u00f3n proyectos CRM","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.encamina.com\/mascrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/blogs.encamina.com\/mascrm\/#\/schema\/person\/148a37e227c5716102c71c3ab092d73b","name":"Juan Ribes","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g","caption":"Juan Ribes"},"description":"Director de Servicios CRM en ENCAMINA. Responsable de la implantaci\u00f3n los proyectos CRM en ENCAMINA desde 2005, principalmente con Microsoft Dynamics.","sameAs":["http:\/\/www.encamina.com","http:\/\/www.facebook.com\/juan.ribes.andres","http:\/\/es.linkedin.com\/in\/juanribes","http:\/\/pinterest.com\/jribes","https:\/\/x.com\/jribes"],"url":"https:\/\/blogs.encamina.com\/mascrm\/author\/jribes\/"}]}},"_links":{"self":[{"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/posts\/91","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/comments?post=91"}],"version-history":[{"count":0,"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/posts\/91\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/media?parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/categories?post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/tags?post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}