{"id":49410,"date":"2008-07-30T05:36:27","date_gmt":"2008-07-30T02:36:27","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=49410"},"modified":"2021-02-19T05:40:36","modified_gmt":"2021-02-19T02:40:36","slug":"using-apatar-to-integrate-salesforce-com-with-legacy-apps","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/","title":{"rendered":"Using Apatar to Integrate Salesforce.com with Legacy Apps"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#Helping_to_achieve_CRM_implementation_goals\" >Helping to achieve CRM implementation goals<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#Plays_well_with_Sandbox\" >Plays well with Sandbox<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#Unify_data_with_regular_expressions\" >Unify data with regular expressions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#Streamline_e-mails_and_backups\" >Streamline e-mails and backups<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Helping_to_achieve_CRM_implementation_goals\"><\/span>Helping to achieve CRM implementation goals<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>According to <a href=\"https:\/\/www.sdcexec.com\/sourcing-procurement\/news\/10357588\/crm-moving-beyond-technology-to-realize-real-returns\" rel=\"noopener noreferrer\" target=\"_blank\">a study<\/a> by Best Practices, LLC, 70% of CRM projects fail to meet business requirements defined before CRM implementation. Proper data integration is one of the obstacles on the way. Gartner estimates that Global 2000 companies will spend an average of $1.2 million on Customer Data Integration (CDI) in 2006\u20132008.<\/p>\n<p>In response to this challenge, the Apatar team heavily focused on building a <a href=\"https:\/\/web.archive.org\/web\/20100706140753\/https:\/\/www.altoros.com\/blog\/tag\/data-integration\/wiki\/display\/GUI\/Apatar+Connector+for+SalesForce.com\" rel=\"noopener noreferrer\" target=\"_blank\">connector for Salesforce CRM<\/a> and get hosted on SFDC&#8217;s AppExchange.<\/p>\n<div id=\"attachment_60348\" style=\"width: 145px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/07\/Andrew_Leigh_Salesforce.com_Force.com_.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-60348\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/07\/Andrew_Leigh_Salesforce.com_Force.com_.jpg\" width=\"135\" height=\"186\" class=\"size-thumbnail wp-image-60348\" \/><\/a><p id=\"caption-attachment-60348\" class=\"wp-caption-text\"><small>Andrew Leigh<\/small><\/p><\/div>\n<blockquote><p>&#8220;As the momentum for on-demand solutions continues to grow, Salesforce.com customers are looking to the AppExchange for solutions that can integrate customer data with a variety of internal systems, including ERP and other custom applications. Salesforce.com customers can use the AppExchange to find dozens of different integration solutions that are right for their unique businesses needs. Apatar brings open-source data integration to companies that previously found proprietary solutions expensive and difficult to implement.&#8221;<\/p>\n<p>\u2014<a href=\"https:\/\/www.linkedin.com\/in\/andrewmleigh\/\" rel=\"noopener noreferrer\" target=\"_blank\">Andrew Leigh<\/a>, Director, Product Marketing, Salesforce.com<\/p><\/blockquote>\n<p>Since 2007, we also created a number of premapped Salesforce.com integration solutions linking data between SFDC and <a href=\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/\">GoldMine<\/a>, <a href=\"https:\/\/www.altoros.com\/blog\/5-steps-to-integrate-sugarcrm-with-third-party-systems-and-avoid-mistakes\/\">SugarCRM<\/a>, <a href=\"https:\/\/www.altoros.com\/blog\/building-a-bridge-between-salesforce-crm-and-quickbooks-connectors-do-not-matter\/\">QuickBooks<\/a>, MS Office tools (<a href=\"https:\/\/www.altoros.com\/blog\/unstructured-data-a-challenge-for-it-decision-makers\/\">Excel\/Word<\/a>), etc.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Plays_well_with_Sandbox\"><\/span>Plays well with Sandbox<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Today, Apatar announces connectivity to Force.com Sandbox, a separate on-demand environment where developers can build, test, and deploy Salesforce CRM\u2013related applications. The core engineering team has confirmed that Apatar Data Integration can now successfully process Sandbox\u2019s data using the connector for Salesforce.com.<\/p>\n<p>Sandbox is commonly used by Salesforce.com customers for testing new customizations or features before rolling them out to users, trying out applications from the AppExchange directory, creating a development environment for building applications, and providing a training environment for employees.<\/p>\n<p>The new functionality contributes to other integration and data quality capabilities of Apatar appreciated by Salesforce CRM users.<\/p>\n<div id=\"attachment_60353\" style=\"width: 160px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/07\/javier-heitz-ceo-s4g-consulting.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-60353\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/07\/javier-heitz-ceo-s4g-consulting-150x150.jpg\" alt=\"\" width=\"150\" height=\"150\" class=\"size-thumbnail wp-image-60353\" \/><\/a><p id=\"caption-attachment-60353\" class=\"wp-caption-text\"><small>Javier Heitz<\/small><\/p><\/div>\n<blockquote><p>&#8220;S4G Consulting is a Salesforce.com Consulting Partner. We came across Apatar while evaluating integration tools for Salesforce CRM, the system we specialize on. Apatar is a powerful, easy-to-use, open-source and, what is best, free integration tool. We decided to use it in a project for a nonprofit that had no budget for such a tool. (The alternatives cost anything from $1,300 to $20,000 per year!) We managed to get it to work quite quickly\u2014thanks to the help from the support, which is simply outstanding. We will definitely keep using this product in the future and highly recommend it.&#8221; \u2014<a href=\"https:\/\/www.linkedin.com\/in\/javierheitz\/\" rel=\"noopener noreferrer\" target=\"_blank\">Javier Heitz<\/a>, CEO, S4G Consulting<\/p><\/blockquote>\n<p>Let&#8217;s take a look at a couple of basic transformation scenarios you can try out and experiment with during Salesforce.com integration.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Unify_data_with_regular_expressions\"><\/span>Unify data with regular expressions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The use of <a href=\"https:\/\/en.wikipedia.org\/wiki\/Regular_expression\" rel=\"noopener noreferrer\" target=\"_blank\">regular expressions<\/a> in data integration has become quite a common thing, shortening time spent on data unification (but not limited to that). Working with text strings, regular expressions can help you to find and transform information\u2014based on specified rules or patterns. Regular expressions (RegEx) comprise different constants and symbols that define various mass operations over strings. This is especially useful when you need to find some values according to certain criteria and transform, migrate, or change this data.<\/p>\n<p>Combining Apatar&#8217;s connector for Salesforce.com and the built-in <a href=\"https:\/\/web.archive.org\/web\/20101118072516\/https:\/\/www.altoros.com\/blog\/tag\/data-integration\/wiki\/display\/FUN\/Match+RegExp+Function\" rel=\"noopener noreferrer\" target=\"_blank\">Match RegExp<\/a> function in the Transform module, you can create flexible integrations, cleansing data or improving its quality in another way. The function can be used for validating e-mails, grouping and identifying pieces of the matching substring, and more.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/07\/migrating-salesforce-crm-to-sugarcrm-accounts-and-contacts-with-apatar.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/07\/migrating-salesforce-crm-to-sugarcrm-accounts-and-contacts-with-apatar.png\" alt=\"\" width=\"574\" height=\"219\" class=\"aligncenter size-full wp-image-60331\" \/><\/a><small>A prebuilt solution for migrating Salesforce.com&#8217;s Accounts and Contacts to SugarCRM<\/small><\/center><\/p>\n<p>Here&#8217;s a simple example. Imagine you need to integrate contact data from Salesforce.com with an accounting system (or another CRM). Let&#8217;s assume that, in Salesforce CRM, the first name and last name are entered in a single field, while the accounting system has two separate fields for that. Using regular expressions, we may find and choose the first name in Salesforce.com&#8217;s \u201cName\u201d field as something that stands before the blank space and integrate it into accounting system\u2019s \u201cFirst name\u201d field. The same thing with the last name, which may be defined as some text standing after a blank space in the \u201cName\u201d field in Salesforce CRM.<\/p>\n<p>Though the example is very basic, a lot more can be done by using RegEx to examine or parse some text that matches specific rules. The process can be designed the other way round, as well. For instance, a multiple-field address in Salesforce CRM can be synchronized with a single-field item in another system, such as QuickBooks.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/01\/Salesforce.com-and-QuickBooks-synchronization-address-fields-comparison.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/01\/Salesforce.com-and-QuickBooks-synchronization-address-fields-comparison.png\" alt=\"\" width=\"640\" class=\"aligncenter size-full wp-image-57195\" \/><\/a><small>Merging address data from Salesforce CRM for QuickBooks integration<\/small><\/center><\/p>\n<p>Of course, RegEx operations may slow down the integration pipeline when it comes to dealing with large amounts of data, but this still eases data integration a lot, anyway. Check out <a href=\"https:\/\/web.archive.org\/web\/20101118054446\/http:\/\/apatarforge.org\/wiki\/display\/AUG\/Sample+Regular+Expressions\" rel=\"noopener noreferrer\" target=\"_blank\">our tutorial<\/a> to learn how to create sample regular expressions.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Streamline_e-mails_and_backups\"><\/span>Streamline e-mails and backups<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Whether you are implementing ongoing synchronization or one-time <a href=\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/\">data migration<\/a>, you may need to integrate or update information hosted within customer e-mails. In some cases, due to import issues, messages can be truncated by the system or contain other problems, such as broken links. If so, you may consider extracting an HTML code of a message&#8217;s body by using Apatar&#8217;s <a href=\"https:\/\/web.archive.org\/web\/20120119053439\/https:\/\/www.altoros.com\/blog\/tag\/data-integration\/wiki\/display\/FUN\/Parse+E-mail+Body+Function\" rel=\"noopener noreferrer\" target=\"_blank\">connector for e-mail<\/a> and then sending this code to a CRM after required transformations (such as fixing broken links, address typos, etc.).<\/p>\n<p>Starting with the next builds, the connector for e-mail will also allow for setting up an encrypted connection. This improvement will enable you to use secure connections while reading or sending e-mails. Another new feature will enable to filter out messages on the mail-server level. E-mail filtration will be helpful if you need to receive, for example, important messages from a certain customer, or need to find a letter with a certain subject. Finally, you will be able to retrieve either all, or unread mail from an IMAP server. This feature will be helpful if you need, for instance, to move your mail from an inbox to a CRM system.<\/p>\n<p>One more scenario for experiments is backing up noncritical Salesforce.com data to a cloud to explore its capabilities. By using Apatar&#8217;s <a href=\"https:\/\/web.archive.org\/web\/20110112075823\/http:\/\/apatarforge.org\/wiki\/display\/GUI\/Connector+for+Amazon+S3\" rel=\"noopener noreferrer\" target=\"_blank\">Amazon S3 connector<\/a>, DBAs can upload selected nonsecure files (objects) to a web storage (bucket) at a specified time on a regular basis. If the information is stored in a semi-structured form or as a plain text (such as notes), it can be copied to a local file, which can then be uploaded to the cloud. Make sure you follow the internal security initiatives, as well as introduce privacy policies, logging, etc., for this kind of activity.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/07\/backup.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/07\/backup.png\" width=\"572\" height=\"454\" class=\"aligncenter size-full wp-image-60372\" \/><\/a><small>Backing up documents from Salesforce.com to Amazon S3<\/small><\/center><\/p>\n<p>For more on integrating Salesforce CRM with third-party systems, read <a href=\"https:\/\/www.techrepublic.com\/blog\/the-enterprise-cloud\/step-by-step-integrating-salesforcecom-with-on-premises-databases-and-applications\/\" rel=\"noopener noreferrer\" target=\"_blank\">this tutorial<\/a> on TechRepublic, browse through <a href=\"https:\/\/www.networkworld.com\/article\/2288221\/dump-your-legacy-crm-system-for-salesforce-com-using-open-source-tools.html\" rel=\"noopener noreferrer\" target=\"_blank\">the article<\/a> on NetworkWorld, check out the <a href=\"https:\/\/web.archive.org\/web\/20100706140753\/https:\/\/www.altoros.com\/blog\/tag\/data-integration\/wiki\/display\/GUI\/Apatar+Connector+for+SalesForce.com\" rel=\"noopener noreferrer\" target=\"_blank\">documentation<\/a>, or watch the <a href=\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-web-demos\/\">demos<\/a>. Finally, take a look at the <a href=\"https:\/\/www.altoros.com\/blog\/salesforcecom-sms-mashup-using-strikeiron-sms-web-service\/\">Salesforce.com SMS mashup<\/a> that won the StrikeIron Business Mashup contest last year.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Further_reading\"><\/span>Further reading<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/salesforcecom-sms-mashup-using-strikeiron-sms-web-service\/\">Building a Salesforce.com Mashup Using the StrikeIron SMS Web Service<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/5-steps-to-integrate-sugarcrm-with-third-party-systems-and-avoid-mistakes\/\">5 Steps to Integrate SugarCRM with Third-Party Systems and Avoid Mistakes<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/\">The Three Most Common Problems Faced During Data Migration<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/building-a-bridge-between-salesforce-crm-and-quickbooks-connectors-do-not-matter\/\">Building a Bridge Between Salesforce CRM and QuickBooks<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<hr\/>\n<p><center><small>The post is written by <a href=\"https:\/\/www.altoros.com\/blog\/author\/alex\/\">Alex Khizhniak<\/a><br \/>\nwith contributions from <a href=\"https:\/\/www.altoros.com\/blog\/author\/olga\/\">Olga Belokurskaya<\/a> and <a href=\"https:\/\/www.altoros.com\/blog\/author\/alena-semeshko\/\">Alena Semeshko<\/a>.<\/small><\/center><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Helping to achieve CRM implementation goals<\/p>\n<p>According to a study by Best Practices, LLC, 70% of CRM projects fail to meet business requirements defined before CRM implementation. Proper data integration is one of the obstacles on the way. Gartner estimates that Global 2000 companies will spend an average of $1.2 million [&#8230;]<\/p>\n","protected":false},"author":5,"featured_media":60318,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":"","_links_to":"","_links_to_target":""},"categories":[7],"tags":[960,895],"class_list":["post-49410","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news-and-opinion","tag-data-integration","tag-research-and-development"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using Apatar to Integrate Salesforce.com with Legacy Apps | Altoros<\/title>\n<meta name=\"description\" content=\"The connector to Salesforce CRM enables the migration of customer data between legacy apps and SFDC, improving the quality of contact information on the go.\" \/>\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.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Apatar to Integrate Salesforce.com with Legacy Apps | Altoros\" \/>\n<meta property=\"og:description\" content=\"Helping to achieve CRM implementation goals According to a study by Best Practices, LLC, 70% of CRM projects fail to meet business requirements defined before CRM implementation. Proper data integration is one of the obstacles on the way. Gartner estimates that Global 2000 companies will spend an average of $1.2 million [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2008-07-30T02:36:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-19T02:40:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/09\/apatar_salesforce_com_integration_mysql_staging_database.png\" \/>\n\t<meta property=\"og:image:width\" content=\"647\" \/>\n\t<meta property=\"og:image:height\" content=\"454\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alex Khizhniak\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alex Khizhniak\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/\",\"name\":\"Using Apatar to Integrate Salesforce.com with Legacy Apps | Altoros\",\"isPartOf\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/09\/apatar_salesforce_com_integration_mysql_staging_database.png\",\"datePublished\":\"2008-07-30T02:36:27+00:00\",\"dateModified\":\"2021-02-19T02:40:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#primaryimage\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/09\/apatar_salesforce_com_integration_mysql_staging_database.png\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/09\/apatar_salesforce_com_integration_mysql_staging_database.png\",\"width\":647,\"height\":454},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.altoros.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Apatar to Integrate Salesforce.com with Legacy Apps\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\",\"url\":\"https:\/\/www.altoros.com\/blog\/\",\"name\":\"Altoros\",\"description\":\"Insight\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.altoros.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420\",\"name\":\"Alex Khizhniak\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2017\/06\/druzya-edit1-150x150.jpg\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2017\/06\/druzya-edit1-150x150.jpg\",\"caption\":\"Alex Khizhniak\"},\"description\":\"Alex Khizhniak is Director of Technical Content Strategy at Altoros and a cofounder of a local Java User Group. Managing distributed teams since 2004, he has gained experience as a journalist, an editor-in-chief, a technical writer, a technology evangelist, a project manager, and a product owner. Alex is obsessed with AI\/ML, data science, data integration, ETL\/DWH, data quality, databases (SQL\/NoSQL), big data, IoT, and BI. The articles and industry reports he created or helped to publish reached out to 3,000,000+ tech-savvy readers. Some of the pieces were covered on TechRepublic, ebizQ, NetworkWorld, CIO.com, etc. Find him on Twitter at @alxkh.\",\"sameAs\":[\"https:\/\/x.com\/https:\/\/twitter.com\/alxkh\"],\"url\":\"https:\/\/www.altoros.com\/blog\/author\/alex\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Apatar to Integrate Salesforce.com with Legacy Apps | Altoros","description":"The connector to Salesforce CRM enables the migration of customer data between legacy apps and SFDC, improving the quality of contact information on the go.","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.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/","og_locale":"en_US","og_type":"article","og_title":"Using Apatar to Integrate Salesforce.com with Legacy Apps | Altoros","og_description":"Helping to achieve CRM implementation goals According to a study by Best Practices, LLC, 70% of CRM projects fail to meet business requirements defined before CRM implementation. Proper data integration is one of the obstacles on the way. Gartner estimates that Global 2000 companies will spend an average of $1.2 million [...]","og_url":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/","og_site_name":"Altoros","article_published_time":"2008-07-30T02:36:27+00:00","article_modified_time":"2021-02-19T02:40:36+00:00","og_image":[{"width":647,"height":454,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/09\/apatar_salesforce_com_integration_mysql_staging_database.png","type":"image\/png"}],"author":"Alex Khizhniak","twitter_misc":{"Written by":"Alex Khizhniak","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/","url":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/","name":"Using Apatar to Integrate Salesforce.com with Legacy Apps | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/09\/apatar_salesforce_com_integration_mysql_staging_database.png","datePublished":"2008-07-30T02:36:27+00:00","dateModified":"2021-02-19T02:40:36+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/09\/apatar_salesforce_com_integration_mysql_staging_database.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/09\/apatar_salesforce_com_integration_mysql_staging_database.png","width":647,"height":454},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-salesforce-com-with-legacy-apps\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using Apatar to Integrate Salesforce.com with Legacy Apps"}]},{"@type":"WebSite","@id":"https:\/\/www.altoros.com\/blog\/#website","url":"https:\/\/www.altoros.com\/blog\/","name":"Altoros","description":"Insight","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.altoros.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420","name":"Alex Khizhniak","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2017\/06\/druzya-edit1-150x150.jpg","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2017\/06\/druzya-edit1-150x150.jpg","caption":"Alex Khizhniak"},"description":"Alex Khizhniak is Director of Technical Content Strategy at Altoros and a cofounder of a local Java User Group. Managing distributed teams since 2004, he has gained experience as a journalist, an editor-in-chief, a technical writer, a technology evangelist, a project manager, and a product owner. Alex is obsessed with AI\/ML, data science, data integration, ETL\/DWH, data quality, databases (SQL\/NoSQL), big data, IoT, and BI. The articles and industry reports he created or helped to publish reached out to 3,000,000+ tech-savvy readers. Some of the pieces were covered on TechRepublic, ebizQ, NetworkWorld, CIO.com, etc. Find him on Twitter at @alxkh.","sameAs":["https:\/\/x.com\/https:\/\/twitter.com\/alxkh"],"url":"https:\/\/www.altoros.com\/blog\/author\/alex\/"}]}},"_links":{"self":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/comments?post=49410"}],"version-history":[{"count":52,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49410\/revisions"}],"predecessor-version":[{"id":60381,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49410\/revisions\/60381"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/60318"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=49410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=49410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=49410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}