{"id":53756,"date":"2013-04-27T04:05:20","date_gmt":"2013-04-27T01:05:20","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=53756"},"modified":"2021-02-10T07:36:56","modified_gmt":"2021-02-10T04:36:56","slug":"what-is-apatar-open-source-data-integration","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/","title":{"rendered":"What Is Apatar Open Source Data Integration?"},"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\/what-is-apatar-open-source-data-integration\/#Overview\" >Overview<\/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\/what-is-apatar-open-source-data-integration\/#Popular_scenarios\" >Popular scenarios<\/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\/what-is-apatar-open-source-data-integration\/#Community_and_collaboration\" >Community and collaboration<\/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\/what-is-apatar-open-source-data-integration\/#Licensing_model\" >Licensing model<\/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\/what-is-apatar-open-source-data-integration\/#Afterword\" >Afterword<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Overview\"><\/span>Overview<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/12\/Apatar_logo_1.gif\" alt=\"\" width=\"150\" height=\"44\" class=\"alignright size-full wp-image-53762\" \/>The Gartner Group estimates that corporate developers spend 65% of their effort building bridges between applications. Altoros understands users&#8217; need to complete their integration initiatives quickly and easily without the involvement of costly programming and coding efforts. That&#8217;s why in 2007 we delivered <a href=\"https:\/\/www.altoros.com\/blog\/apatar-press-coverage-2007-2010\/\" rel=\"noopener noreferrer\" target=\"_blank\">Apatar<\/a>, an open-source data integration tool designed to help both business users and developers move their data in and out of numerous sources and formats.<\/p>\n<p>No programming was required to accomplish even a complex integration when using Apatar\u2014one needed to just &#8220;drag-and-drop&#8221; data between databases and apps by using a visual mapping interface. Community members could also benefit from reusing mapping schemas built by other developers and DBAs.<\/p>\n<p><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2007\/02\/apatar-technology-architecture.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2007\/02\/apatar-technology-architecture.jpg\" alt=\"\" width=\"514\" height=\"385\" class=\"aligncenter size-full wp-image-38159\" \/><\/a><\/p>\n<p>The tool provided connectivity to Oracle, MS SQL, <a href=\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/\">MySQL<\/a>, Sybase, DB2, MS Access, PostgreSQL, XML, CSV, MS Excel, Compiere ERP, Salesforce.com, <a href=\"https:\/\/www.altoros.com\/blog\/5-steps-to-integrate-sugarcrm-with-third-party-systems-and-avoid-mistakes\/\">SugarCRM<\/a>, GoldMine, InstantDB, any JDBC data sources, and many more. Apatar was 100% Java-based and platform-independent, running on Windows, Linux, and MacOS. The product was developed using Eclipse.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Popular_scenarios\"><\/span>Popular scenarios<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A robust, scalable Apatar architecture enabled end-users and developers to successfully solve a broad spectrum of integration needs\u2014from extracting, transforming, and loading (ETL) for data warehousing, to migration, <a href=\"https:\/\/www.altoros.com\/blog\/building-a-bridge-between-salesforce-crm-and-quickbooks-connectors-do-not-matter\/\">synchronization<\/a>, and app integration.<\/p>\n<p>Apatar could be used in diverse data-driven systems where you have information that needs to be captured and transferred to a new app, data warehouse, or a single front end. Popular integration scenarios:<\/p>\n<ul>\n<li>Move data from one location to another<\/li>\n<li>Synchronize data between two or more data sources<\/li>\n<li>Integrate data across an enterprise<\/li>\n<li>Consolidate data from two or more data sources into a <a href=\"https:\/\/www.altoros.com\/blog\/why-data-warehousing-why-business-intelligence\/\">data warehouse<\/a><\/li>\n<li>Populate a data warehouse or a data mart<\/li>\n<li>Validate and correct key data<\/li>\n<li>Schedule backups<\/li>\n<\/ul>\n<p>Apatar had a user-friendly UI and, even for a nontechnical user, it would take just a couple of hours to get trained. Most users found it intuitive. Apatar had a number of built-in <a href=\"https:\/\/www.altoros.com\/blog\/wrong-approach-to-data-quality-right-approach-to-data-quality\/\">data quality<\/a> tools, enabling <a href=\"https:\/\/www.altoros.com\/blog\/data-cleansing-and-validation-using-strikeiron-services-and-apatar\/\">data cleansing<\/a>, de-duplication, etc.<\/p>\n<p><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2007\/02\/apatar-solutions-sync.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2007\/02\/apatar-solutions-sync.jpg\" alt=\"\" width=\"412\" height=\"398\" class=\"aligncenter size-full wp-image-38161\" \/><\/a><\/p>\n<p>We also promoted the concept of reusable DataMaps. Working with data sources, the tool generates XML metadata files (&#8220;DataMaps&#8221;) that store all the information captured by the Apatar designer and mapping graphical UIs. Apatar&#8217;s engine then manages, executes, and controls the total project execution plan described in the XML metadata files. In addition, for each executed job, Apatar generates a detailed report \/ log.<\/p>\n<p>By adopting and following this metadata-centric approach, users can share the XML metadata files to reuse connectivity settings, transformation, and mapping. These XML metadata files can be sent to another user having the Apatar desktop app or to feed pre-built DataMaps to the Apatar server engine, saving time and money while integration.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Community_and_collaboration\"><\/span>Community and collaboration<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Though Altoros was a major contributor, the project had an active community behind it, helping to improve the product and develop new connectors, as well as other functionality. The open-source code of Apatar allowed for building add-on connectors for any data integration applications, be it legacy, APIs, or <a href=\"https:\/\/www.altoros.com\/blog\/unstructured-data-a-challenge-for-it-decision-makers\/\">semi-structured<\/a> data sources \/ targets.<\/p>\n<p>The Apatar manifesto stated:<\/p>\n<p><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/12\/why_apatar.jpg\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/12\/why_apatar-377x1024.jpg\" width=\"200\" class=\"alignright size-large wp-image-53768\" \/><\/a><\/p>\n<ul>\n<li><b>Source Code<\/b>. We believe that the quality of the core code base determines how easy or hard it is for all of us to work together and push Apatar forward.<\/li>\n<li><b>Responsibility<\/b>. We feel responsible for the success of the project, including the support of new contributors and facilitating communication across e-mail, mailing lists, and forums.<\/li>\n<li><b>Presence<\/b>. We strive\u2014and encourage those who commit to the project\u2014to be present in the mailing list and chat room so as to help fellow developers and new contributors  feel less alone.<\/li>\n<li><b>Helpfulness<\/b>. Often, there just isn&#8217;t enough documentation available yet for new features and connectors. Sometimes there are questions to be answered. It is our goal to address every question in order to quickly solve the bottleneck standing between you and successful usage of Apatar.<\/li>\n<li><b>Openness<\/b>. We share our short- and long-term goals with you in order to leverage all benefits of a joint community effort to build a truly open, great piece of software.<\/li>\n<li><b>Founders commitment<\/b>. We strive to be dedicated to work on the project, investing time for the further development of the software and the community.<\/li>\n<li><b>Patience<\/b>. We understand that every community is different and lives by its own rules. We believe that all of us should be patient with each other and support new members so that they can  become  vibrant community leaders.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Licensing_model\"><\/span>Licensing model<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Apatar used a &#8220;dual-licensing&#8221; business model. Under this model, users could choose to use the product either under the free software\/open-source GNU General Public License (known as the GPL) or under a commercial license. Apatar&#8217;s dual-licensing was focused on promoting freedom in two ways: first, it encouraged the growth of free software by licensing Apatar under the GPL; second, it made it possible to use our software in situations where the GPL was not applicable.<\/p>\n<p>Apatar&#8217;s dual-license model supported the company&#8217;s mission: to make data integration affordable to all, including those users who traditionally could not afford expensive proprietary data integration tools. (This kind of software has traditionally been expensive, with a typical license costing $25,000 to $500,000.)<\/p>\n<blockquote><p>&#8220;The open-source community provides business users with an option to avoid vendor &#8216;lock-in.&#8217; What users of open-source software really like is the total cost of ownership. When you don\u2019t have to pay license fees for database software, data integration, and business intelligence software, this alone makes a healthy difference to your bottom line.&#8221; \u2014<a href=\"https:\/\/www.linkedin.com\/in\/renatco\/\" rel=\"noopener noreferrer\" target=\"_blank\">Renat Khasanshyn<\/a>, Founder, Apatar<\/p><\/blockquote>\n<p>The dual-licensing also created an opportunity for Apatar to give back to the community. The Apatar team believed that the open-source model of development and distribution is the most efficient way to produce high-quality software.<\/p>\n<div id=\"attachment_15410\" style=\"width: 150px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2016\/08\/Renat-Khasanshyn.jpg\"><img decoding=\"async\" aria-describedby=\"caption-attachment-15410\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2016\/08\/Renat-Khasanshyn-150x150.jpg\" width=\"140\" class=\"size-thumbnail wp-image-15410\" \/><\/a><p id=\"caption-attachment-15410\" class=\"wp-caption-text\"><small>Renat Khasanshyn<\/small><\/p><\/div>\n<blockquote><p>&#8220;Open source is driven by real people like you and me, helping each other make our day-to-day work easier and more productive. Every contribution to the Apatar project extends the way companies manage their information, perhaps, one of the most valuable assets in the global economy. We value and appreciate each and every contribution you are making to the project.&#8221;<\/p>\n<p>\u2014<a href=\"https:\/\/www.linkedin.com\/in\/renatco\/\" rel=\"noopener noreferrer\" target=\"_blank\">Renat Khasanshyn<\/a>, Founder, Apatar<\/p><\/blockquote>\n<p>The dual-licensing business model was becoming increasingly popular among open-source companies at that time, paving the way for long-term financial viability. Other companies that offered dual-licensing included Alfresco, MySQL, SugarCRM, Trolltech, Zimbra, and others.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Afterword\"><\/span>Afterword<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>By 2012, the tool was mostly deprecated, only the latest <a href=\"https:\/\/sourceforge.net\/projects\/apatar\/files\/Apatar%20Data%20Integration_ETL\/Apatar%20v1.12.23\/\" rel=\"noopener noreferrer\" target=\"_blank\">stable release<\/a> (v1.12.*) was supported for some time. It still can be downloaded from SourceForge. We do grateful to everyone who helped our core team to made this awesome project thrive.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/04\/apatar-contributors-recognitions.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/04\/apatar-contributors-recognitions-1024x538.png\" width=\"640\" class=\"aligncenter size-large wp-image-53860\" \/><\/a><small>Some of the most active Apatar contributors outside the core team<\/small><\/center><\/p>\n<p>In addition to code contributions, many thanks to <a href=\"https:\/\/scobleizer.blog\/2007\/06\/15\/going-to-kytetv-today\/\" rel=\"noopener noreferrer\" target=\"_blank\">Robert Scoble<\/a>, <a href=\"https:\/\/connected.typepad.com\/connected\/2007\/09\/apatar.html\" rel=\"noopener noreferrer\" target=\"_blank\">Jason Pratt<\/a>, <a href=\"http:\/\/blog.componentoriented.com\/2007\/09\/open_source_customer_service\/\" rel=\"noopener noreferrer\" target=\"_blank\">D.Lambert<\/a>, <a href=\"https:\/\/marcrussel.wordpress.com\/2007\/08\/24\/open-source-data-integration-in-network-world\/\" rel=\"noopener noreferrer\" target=\"_blank\">Marc Russel<\/a>, <a href=\"http:\/\/web.archive.org\/web\/20090820073445\/http:\/\/blog.interop.com\/blog\/2009\/08\/14\/lightweight-middleware\/\" rel=\"noopener noreferrer\" target=\"_blank\">Brian Chee<\/a>, <a href=\"http:\/\/web.archive.org\/web\/20130227052605\/http:\/\/www.dailycupoftech.com\/2007\/08\/02\/schedule-running-apatar-projects\/\" rel=\"noopener noreferrer\" target=\"_blank\">Tim Fehlman<\/a>, <a href=\"http:\/\/web.archive.org\/web\/20070626072040\/http:\/\/www.techbizmedia.com\/startups\/2007\/06\/18\/apatar-yahoo-pipes-like-open-source-app-for-enterprises\/\" rel=\"noopener noreferrer\" target=\"_blank\">Krishnan Subramanian<\/a>, and other awesome professionals who mentioned Apatar on their blogs, spreading the word across communities.<\/p>\n<blockquote><p>&#8220;Apatar is creating a shift in the way we look at data. With its on-demand data integration tools working together with complimentary RSS aggregation services Apatar will go a long way towards commoditizing information integration between applications, databases across the enterprise traditionally suffering from information integration issues among heterogeneous systems.&#8221; \u2014Deepak Singh, Blogger-in-Residence, TechBizMedia.com<\/p>\n<p>&#8220;Before Apatar, there were many proprietary vendors offering data integration solutions to the enterprise marketplace. In many cases they were not cost effective. Apatar entered this market as an open source vendor offering on-demand data integration coupled with product support and services at a much lower cost. Even though Apatar software is designed as a toolset for developers, it does not require manual coding and may receive adoption among business users.&#8221; \u2014Krishnan Subramanian, Blogger-in-Residence, TechBizMedia.com<\/p><\/blockquote>\n<p>We do appreciate the contribution of everyone who was involved into Apatar&#8217;s ecosystem! Check out <a href=\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-web-demos\/\">these video tutorials<\/a> or read exhaustive <a href=\"https:\/\/www.altoros.com\/blog\/apatar-press-coverage-2007-2010\/\">media coverage<\/a> to learn more about this great product.<\/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\/apatar-press-coverage-2007-2010\/\">Apatar Press Coverage, 2007\u20132010<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/etl-vs-esb\/\">ETL vs. ESB from Apatar\u2019s Point of View<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/\">Apatar Data Integration: A Quick-Start Guide<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<hr\/>\n<p><center><small>Updated in April 2020.<\/small><\/center><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview<\/p>\n<p>The Gartner Group estimates that corporate developers spend 65% of their effort building bridges between applications. Altoros understands users&#8217; need to complete their integration initiatives quickly and easily without the involvement of costly programming and coding efforts. That&#8217;s why in 2007 we delivered Apatar, an open-source data integration tool designed [&#8230;]<\/p>\n","protected":false},"author":5,"featured_media":53783,"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":[966,960,895],"class_list":["post-53756","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news-and-opinion","tag-apatar","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>What Is Apatar Open Source Data Integration? | Altoros<\/title>\n<meta name=\"description\" content=\"Learn about a great open-source ETL project we supported from 2006 to 2011.\" \/>\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\/what-is-apatar-open-source-data-integration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What Is Apatar Open Source Data Integration? | Altoros\" \/>\n<meta property=\"og:description\" content=\"Overview The Gartner Group estimates that corporate developers spend 65% of their effort building bridges between applications. Altoros understands users&#8217; need to complete their integration initiatives quickly and easily without the involvement of costly programming and coding efforts. That&#8217;s why in 2007 we delivered Apatar, an open-source data integration tool designed [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2013-04-27T01:05:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-10T04:36:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/04\/Aapatar-GoldMine-to-SFDC-Salesforce-History-Migration.png\" \/>\n\t<meta property=\"og:image:width\" content=\"554\" \/>\n\t<meta property=\"og:image:height\" content=\"447\" \/>\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=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/\",\"name\":\"What Is Apatar Open Source Data Integration? | Altoros\",\"isPartOf\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/04\/Aapatar-GoldMine-to-SFDC-Salesforce-History-Migration.png\",\"datePublished\":\"2013-04-27T01:05:20+00:00\",\"dateModified\":\"2021-02-10T04:36:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/#primaryimage\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/04\/Aapatar-GoldMine-to-SFDC-Salesforce-History-Migration.png\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/04\/Aapatar-GoldMine-to-SFDC-Salesforce-History-Migration.png\",\"width\":554,\"height\":447},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.altoros.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What Is Apatar Open Source Data Integration?\"}]},{\"@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":"What Is Apatar Open Source Data Integration? | Altoros","description":"Learn about a great open-source ETL project we supported from 2006 to 2011.","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\/what-is-apatar-open-source-data-integration\/","og_locale":"en_US","og_type":"article","og_title":"What Is Apatar Open Source Data Integration? | Altoros","og_description":"Overview The Gartner Group estimates that corporate developers spend 65% of their effort building bridges between applications. Altoros understands users&#8217; need to complete their integration initiatives quickly and easily without the involvement of costly programming and coding efforts. That&#8217;s why in 2007 we delivered Apatar, an open-source data integration tool designed [...]","og_url":"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/","og_site_name":"Altoros","article_published_time":"2013-04-27T01:05:20+00:00","article_modified_time":"2021-02-10T04:36:56+00:00","og_image":[{"width":554,"height":447,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/04\/Aapatar-GoldMine-to-SFDC-Salesforce-History-Migration.png","type":"image\/png"}],"author":"Alex Khizhniak","twitter_misc":{"Written by":"Alex Khizhniak","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/","url":"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/","name":"What Is Apatar Open Source Data Integration? | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/04\/Aapatar-GoldMine-to-SFDC-Salesforce-History-Migration.png","datePublished":"2013-04-27T01:05:20+00:00","dateModified":"2021-02-10T04:36:56+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/04\/Aapatar-GoldMine-to-SFDC-Salesforce-History-Migration.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/04\/Aapatar-GoldMine-to-SFDC-Salesforce-History-Migration.png","width":554,"height":447},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What Is Apatar Open Source Data Integration?"}]},{"@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\/53756","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=53756"}],"version-history":[{"count":69,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/53756\/revisions"}],"predecessor-version":[{"id":60179,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/53756\/revisions\/60179"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/53783"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=53756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=53756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=53756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}