{"id":223,"date":"2010-05-03T08:41:00","date_gmt":"2010-05-03T08:41:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=223"},"modified":"2010-05-03T08:41:00","modified_gmt":"2010-05-03T08:41:00","slug":"external-database-connectivity","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/","title":{"rendered":"External database connectivity"},"content":{"rendered":"

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 <\/strong>table. That means we need a table similar to that of communication <\/strong>table to archive data in the similar fashion as that of the main table. This table being used for storing archived data may reside on different database on different server.<\/p>\n

In Standard CRM we can connect an external database as below.
1. Go to Administration<\/strong> –> Advanced Customization<\/strong>.
2. Click on the button named \u201cTables and databases<\/strong>\u201d.
3. Click \u201cNew database connection<\/strong>\u201d.
4. Enter the database connection parameters as displayed. (User credentials being used here for connecting to database must have proper rights to read or write data to database tables.).
5. Click on the Save<\/strong> button to Save the settings.<\/p>\n

After connecting External database, we can connect to table in that database as follows.
1. Go to Administration <\/strong>–>Advanced Customization<\/strong>.
2. Click on the button named \u201cTables and databases<\/strong>\u201d.
3. Click \u201cNew table connection<\/strong>\u201d.
4. Enter the details of the table from Archive database. Select Archive database under Database field.
5. Click on the Save<\/strong> button to save table connection details.<\/p>\n

What\u2019s the hitch?<\/strong>

<\/strong>Before moving ahead with connecting external database and tables, we must first ensure the structural resemblance in both the tables. Now what do we mean by structural resemblance? Is it like having similar tables with the same field names in both the databases? No, they are quite not required. We just need to ensure that the table structure remains same like every field in source table must have same type and sized equivalent field in destination table. Name constraints are not required.<\/p>\n

What will be the preferable approach?<\/strong><\/p>\n

The preferable option will always be having different table and field names in archive database for the clone table. This needs to be done in order to avoid the discrepancies in CRM<\/strong>. What kind of discrepancies we can face in CRM<\/strong> if we do not follow this approach?<\/p>\n

Suppose we have created a table for archiving purpose in external database for communication<\/strong> with the same name. Now suppose we are attaching this table in CRM through the external database connectivity provided by standard CRM as explained above. This creates an extra translation entry for external table in CRM.
Now when we go to the lists and screen objects designed with standard communication entity we will see the new translation entry over there also which is logically wrong and it may even lead to screen crashing and report generation errors in CRM.<\/p>\n

If we do not wish to move forward with this approach, we may have to end up using column name aliases for all the queries being written on external tables no matter how long they are!!….:-)…<\/p>\n

If you find this content useful, Please drop us an email at crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"

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 »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[571,921],"class_list":["post-223","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-archive","tag-database"],"yoast_head":"\nExternal database connectivity - Sage CRM \u2013 Tips, Tricks and Components<\/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.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"External database connectivity - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"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 »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2010-05-03T08:41:00+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/\",\"name\":\"External database connectivity - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2010-05-03T08:41:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"External database connectivity\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"External database connectivity - Sage CRM \u2013 Tips, Tricks and Components","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.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/","og_locale":"en_US","og_type":"article","og_title":"External database connectivity - Sage CRM \u2013 Tips, Tricks and Components","og_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 »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2010-05-03T08:41:00+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/","name":"External database connectivity - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2010-05-03T08:41:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/03\/external-database-connectivity\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"External database connectivity"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=223"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/223\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}