{"version":"1.0","provider_name":"Sage CRM \u2013 Tips, Tricks and Components","provider_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm","title":"External database connectivity - Sage CRM \u2013 Tips, Tricks and Components","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"ZdJEFm9Cos\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/\">External database connectivity<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/embed\/#?secret=ZdJEFm9Cos\" width=\"600\" height=\"338\" title=\"&#8220;External database connectivity&#8221; &#8212; Sage CRM \u2013 Tips, Tricks and Components\" data-secret=\"ZdJEFm9Cos\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/* ]]> *\/\n<\/script>\n","description":"In my previous post I have discussed the methodology for data archival process in CRM. The part of the process also includes connecting an External Database. Suppose we are archiving communication table. That means we need a table similar to that of communication table to archive data in the similar fashion as that of the\u2026 Read More &raquo;"}