{"id":60006,"date":"2008-11-21T03:34:22","date_gmt":"2008-11-21T00:34:22","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=60006"},"modified":"2021-02-01T05:16:55","modified_gmt":"2021-02-01T02:16:55","slug":"using-apatar-to-integrate-data-from-to-mysql","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/","title":{"rendered":"Using Apatar to Integrate Data from\/to MySQL"},"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-data-from-to-mysql\/#Why_MySQL\" >Why MySQL?<\/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-data-from-to-mysql\/#Extending_integration_options_with_open_source\" >Extending integration options with open source<\/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-data-from-to-mysql\/#Integrating_MySQL-like_systems_too\" >Integrating MySQL-like systems, too<\/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-data-from-to-mysql\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Why_MySQL\"><\/span>Why MySQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"https:\/\/web.archive.org\/web\/20090209071934\/https:\/\/www.mysql.com\/why-mysql\/marketshare\/\" rel=\"noopener noreferrer\" target=\"_blank\">For years<\/a>, MySQL has been the most popular open-source database on the market. Its success can be explained by numerous reasons.<\/p>\n<p>A comparative study by Meta Group showed that MySQL&#8217;s costs can be 90% less than license fees from other database vendors. That&#8217;s why companies such as Yahoo! and NASA use it to optimize <a href=\"https:\/\/en.wikipedia.org\/wiki\/Total_cost_of_ownership\" rel=\"noopener noreferrer\" target=\"_blank\">TCO<\/a>. In particular, NASA\u2019s Acquisition Internet Service (NAIS) <a href=\"https:\/\/web2.aabu.edu.jo\/tool\/cv\/1523.pdf\" rel=\"noopener noreferrer\" target=\"_blank\">saves<\/a> over $4 million per year by managing large acquisitions online with MySQL. In addition, according to Dwight Clark (Systems Analyst at NASA), &#8220;<i>MySQL averaged 28% faster than the existing proprietary database<\/i>.&#8221;<\/p>\n<p><a href=\"https:\/\/web2.aabu.edu.jo\/tool\/cv\/1523.pdf\" rel=\"noopener noreferrer\" target=\"_blank\">Similar studies<\/a> demonstrated that, on average, MySQL can cut systems downtime by 60%, lower hardware expenditure by 70%, as well as reducing administration, engineering, and support costs by up to 50%.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/11\/mysql-market-share-evans-data.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/11\/mysql-market-share-evans-data.png\" alt=\"\" width=\"507\" height=\"275\" class=\"aligncenter size-full wp-image-60026\" \/><\/a><small>The adoption of MySQL compared to other databases (<a href=\"https:\/\/web.archive.org\/web\/20090209071934\/https:\/\/www.mysql.com\/why-mysql\/marketshare\/\" rel=\"noopener noreferrer\" target=\"_blank\">Source<\/a>)<\/small><\/center><\/p>\n<blockquote><p>\u201cWhen I joined Yahoo!, the data-management part of that system was crude and written internally, and one of the first things I did was replace that with MySQL,\u201d <a href=\"https:\/\/www.linkedin.com\/in\/jzawodn\" rel=\"noopener noreferrer\" target=\"_blank\">Jeremy Zawodny<\/a>, Yahoo!<\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Extending_integration_options_with_open_source\"><\/span>Extending integration options with open source<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div id=\"attachment_60016\" style=\"width: 160px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/11\/nicolas-pujol-mysql.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-60016\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/11\/nicolas-pujol-mysql-150x150.jpg\" alt=\"\" width=\"150\" height=\"150\" class=\"size-thumbnail wp-image-60016\" \/><\/a><p id=\"caption-attachment-60016\" class=\"wp-caption-text\"><small>Nicolas Pujol<\/small><\/p><\/div>\n<p>While MySQL is known as an open-source and intuitive engine for data storage, that is what <a href=\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/\">Apatar<\/a> is all about, too. Open-source in its core, Apatar enables its users to easily link information between databases (such as MySQL, SQL Server, Oracle), files (MS Excel, CSV\/TXT files), applications (Salesforce.com, SugarCRM), and top Web 2.0 destinations (Flickr, Amazon S3, RSS).<\/p>\n<blockquote><p>\u201cWe are very pleased to have Apatar joined our MECA partner program,\u201d said <a href=\"https:\/\/www.linkedin.com\/in\/nicolaspujol\/\" rel=\"noopener noreferrer\" target=\"_blank\">Nicolas Pujol<\/a>, MySQL AB\u2019s Senior Director of Worldwide Alliances and Channels. \u201cApatar shares our belief that database access and management solutions should be easily affordable and available to all types of business users, not just high-end programmers.\u201d<\/p><\/blockquote>\n<p>We are delighted to give the MySQL community a way to get more business value out of integration jobs and projects. Now both developers and users have all the necessary tools to integrate MySQL-driven applications with a variety of data destinations.<\/p>\n<div id=\"attachment_15410\" style=\"width: 160px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2016\/08\/Renat-Khasanshyn.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-15410\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2016\/08\/Renat-Khasanshyn-150x150.jpg\" width=\"150\" height=\"150\" 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>\u201cThe truth is that in today\u2019s enterprises most data integration projects never get built,\u201d said <a href=\"https:\/\/www.linkedin.com\/in\/renatco\/\" rel=\"noopener noreferrer\" target=\"_blank\">Renat Khasanshyn<\/a>, Founder and CEO of Apatar, Inc. \u201cEven though the companies might use MySQL or another open-source database, the Return on Investment on small projects is simply too low to justify bringing in expensive middleware. Apatar entered this market as an open-source vendor bringing the ease of drag-and-drop data integration to the companies that previously found proprietary data integration, ETL, and EAI software tools expensive and difficult to implement.\u201d<\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Integrating_MySQL-like_systems_too\"><\/span>Integrating MySQL-like systems, too<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Earlier this May, the Apatar project announced connectivity to InnoDB, an ACID-compliant transactional storage engine for MySQL. Since then, Apatar\u2019s <a href=\"https:\/\/web.archive.org\/web\/20110613150017\/https:\/\/www.altoros.com\/blog\/tag\/data-integration\/wiki\/display\/GUI\/Connector+for+MySQL\" rel=\"noopener noreferrer\" target=\"_blank\">MySQL connector<\/a> enables DBAs, developers, and nontechnical users to migrate, read, and write data from\/to InnoDB tables. The same it true for other corporate systems (CRM\/ERP) or data warehouses using MySQL under the hood.<\/p>\n<blockquote><p>&#8220;I have successfully been able to create a relatively complex datamap, which involves inserting and updating records from MySQL into Salesforce CRM, pulling back the IDs generated from SF and then updating the original source MySQL table with the IDs. With the [recent] speed updates in Apatar, the entire datamap ran in less than 15 seconds for 2,000+ records. Wow!&#8221; \u2014Brad Howie, Integral IT Solutions<\/p><\/blockquote>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/11\/apatar_data_integration_ETL_mysql_connector_properties.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/11\/apatar_data_integration_ETL_mysql_connector_properties.png\" width=\"500\" height=\"500\" class=\"aligncenter size-full wp-image-60014\" \/><\/a><small>Configuring the MySQL connector within Apatar<\/small><\/center><\/p>\n<p>In January, 2008, Sun Microsystems <a href=\"https:\/\/www.infoworld.com\/article\/2642759\/update--sun-to-acquire-mysql-for--1-billion.html\" rel=\"noopener noreferrer\" target=\"_blank\">revealed<\/a> that it acquired MySQL for $1 billion. According to <a href=\"https:\/\/www.linkedin.com\/in\/richlgreen\/\" rel=\"noopener noreferrer\" target=\"_blank\">Rich Green<\/a>, Sun&#8217;s Executive VP of Software, &#8220;one of the major deciding factors in acquiring MySQL was its use of pluggable components, which allows it to be customized for network operators and developers of embedded database applications.&#8221;<\/p>\n<p>For more about integrating MySQL instances with Apatar, check out the connector&#8217;s brief <a href=\"https:\/\/web.archive.org\/web\/20110613150017\/https:\/\/www.altoros.com\/blog\/tag\/data-integration\/wiki\/display\/GUI\/Connector+for+MySQL\" rel=\"noopener noreferrer\" target=\"_blank\">documentation<\/a>. You can also read <a href=\"https:\/\/www.altoros.com\/blog\/5-steps-to-integrate-sugarcrm-with-third-party-systems-and-avoid-mistakes\/\">this tutorial<\/a> to learn how to integrate SugarCRM with 3rd-party systems, using MySQL as a staging database.<\/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\/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\/guide-to-reducing-etl-and-data-integration-costs-by-80-percent\/\">Reducing ETL and Data Integration Costs by 80% with Open Source<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Why MySQL?<\/p>\n<p>For years, MySQL has been the most popular open-source database on the market. Its success can be explained by numerous reasons.<\/p>\n<p>A comparative study by Meta Group showed that MySQL&#8217;s costs can be 90% less than license fees from other database vendors. That&#8217;s why companies such as Yahoo! and NASA [&#8230;]<\/p>\n","protected":false},"author":5,"featured_media":58848,"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-60006","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>Using Apatar to Integrate Data from\/to MySQL | Altoros<\/title>\n<meta name=\"description\" content=\"Today, the Apatar team is proud to announce that it has joined the MySQL Enterprise Connection Alliance (MECA), a partnership program led by MySQL AB.\" \/>\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-data-from-to-mysql\/\" \/>\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 Data from\/to MySQL | Altoros\" \/>\n<meta property=\"og:description\" content=\"Why MySQL? For years, MySQL has been the most popular open-source database on the market. Its success can be explained by numerous reasons. A comparative study by Meta Group showed that MySQL&#8217;s costs can be 90% less than license fees from other database vendors. That&#8217;s why companies such as Yahoo! and NASA [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2008-11-21T00:34:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-01T02:16:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/12\/staging-mysql-database-usage.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"637\" \/>\n\t<meta property=\"og:image:height\" content=\"495\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"3 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-data-from-to-mysql\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/\",\"name\":\"Using Apatar to Integrate Data from\/to MySQL | Altoros\",\"isPartOf\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/12\/staging-mysql-database-usage.jpg\",\"datePublished\":\"2008-11-21T00:34:22+00:00\",\"dateModified\":\"2021-02-01T02:16:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/#primaryimage\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/12\/staging-mysql-database-usage.jpg\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/12\/staging-mysql-database-usage.jpg\",\"width\":637,\"height\":495},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.altoros.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Apatar to Integrate Data from\/to MySQL\"}]},{\"@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 Data from\/to MySQL | Altoros","description":"Today, the Apatar team is proud to announce that it has joined the MySQL Enterprise Connection Alliance (MECA), a partnership program led by MySQL AB.","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-data-from-to-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Using Apatar to Integrate Data from\/to MySQL | Altoros","og_description":"Why MySQL? For years, MySQL has been the most popular open-source database on the market. Its success can be explained by numerous reasons. A comparative study by Meta Group showed that MySQL&#8217;s costs can be 90% less than license fees from other database vendors. That&#8217;s why companies such as Yahoo! and NASA [...]","og_url":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/","og_site_name":"Altoros","article_published_time":"2008-11-21T00:34:22+00:00","article_modified_time":"2021-02-01T02:16:55+00:00","og_image":[{"width":637,"height":495,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/12\/staging-mysql-database-usage.jpg","type":"image\/jpeg"}],"author":"Alex Khizhniak","twitter_misc":{"Written by":"Alex Khizhniak","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/","url":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/","name":"Using Apatar to Integrate Data from\/to MySQL | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/12\/staging-mysql-database-usage.jpg","datePublished":"2008-11-21T00:34:22+00:00","dateModified":"2021-02-01T02:16:55+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/3d914db6ad1b2908c32c0dc5dcabc420"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/12\/staging-mysql-database-usage.jpg","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/12\/staging-mysql-database-usage.jpg","width":637,"height":495},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/using-apatar-to-integrate-data-from-to-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using Apatar to Integrate Data from\/to MySQL"}]},{"@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\/60006","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=60006"}],"version-history":[{"count":25,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/60006\/revisions"}],"predecessor-version":[{"id":60034,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/60006\/revisions\/60034"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/58848"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=60006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=60006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=60006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}