{"id":57194,"date":"2009-09-08T16:08:42","date_gmt":"2009-09-08T13:08:42","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=57194"},"modified":"2021-06-03T06:07:29","modified_gmt":"2021-06-03T03:07:29","slug":"apatar-data-integration-quick-start-guide","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/","title":{"rendered":"Apatar Data Integration: A Quick-Start Guide"},"content":{"rendered":"<p><center><small><a href=\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/\" rel=\"noopener noreferrer\" target=\"_blank\">What is Apatar?<\/a> | <a href=\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-web-demos\/\" rel=\"noopener noreferrer\" target=\"_blank\">Demo<\/a><\/small><\/center><\/p>\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\" \/><\/p>\n<p><a href=\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/\">Apatar<\/a> is an open-source cross-platform data integration tool. It can be installed and run on any machine that has some sort of user interface. The tool is designed to enable batch data integration and provide a simple user interface, so that anyone\u2014not just technical experts\u2014can set up data integrations.<\/p>\n<p>In this blog post, we explore how to set up, configure, and operate Apatar. The tutorial also provides some tips on how to handle the most typical errors.<\/p>\n<p>&nbsp;<\/p>\n<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\/apatar-data-integration-quick-start-guide\/#Installation\" >Installation<\/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\/apatar-data-integration-quick-start-guide\/#Registration\" >Registration<\/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\/apatar-data-integration-quick-start-guide\/#Application_components\" >Application components<\/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\/apatar-data-integration-quick-start-guide\/#Supported_data_sources_connectors\" >Supported data sources (connectors)<\/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\/apatar-data-integration-quick-start-guide\/#Supported_operations\" >Supported operations<\/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\/apatar-data-integration-quick-start-guide\/#Functions\" >Functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#Building_a_data_integration_job_datamap\" >Building a data integration job (datamap)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#Running_a_data_integration_job_datamap\" >Running a data integration job (datamap)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#Error_handling\" >Error handling<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#Warnings_and_notifications\" >Warnings and notifications<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Installation\"><\/span>Installation<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><i>Note<\/i>: If this is <b>not<\/b> the first time you install Apatar and you are installing Apatar to the same folder as previously, before you start the installation process, make sure you do not have any datamaps in the folder you are installing Apatar to, because the folder will be cleared when installation begins and you will lose your datamaps.<\/p>\n<p>&nbsp;<br \/>\n<strong>Windows<\/strong><\/p>\n<p style=\"margin-bottom: 10px;\">1. Run the .exe file you have downloaded.<\/p>\n<p style=\"margin-bottom: 10px;\">2. At the first screen of the installer, select the components to be installed.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/apatar-setup.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/apatar-setup.png\" alt=\"\" width=\"503\" height=\"386\" class=\"alignnone size-full wp-image-57206\" \/><\/a><br \/>\n<small>Installing Apatar<\/small><\/center><br \/>\n<\/p>\n<p style=\"margin-bottom: 10px;\">If you already have Java version 1.6x installed, uncheck &#8216;Java installer.&#8217; If you do not want to see some connectors, data quality services, or operations displayed in the application, open the related list and uncheck the related components.<\/p>\n<p style=\"margin-bottom: 10px;\">3. Once you have selected the components you want to have installed, click &#8216;Next.&#8217;<\/p>\n<p style=\"margin-bottom: 10px;\">4. At the next screen, you get to select the folder that Apatar will be installed to and click &#8216;Next.&#8217; By default, the application is installed to C:\\Program Files\\Apatar. You can have several instances of Apatar installed and running at the same time if you install them to different directories.<\/p>\n<p style=\"margin-bottom: 10px;\"><i>Note:<\/i> If you have Vista or Windows 7, it is recommended that you install Apatar to a folder other than C:\\Program Files\\.<\/p>\n<p style=\"margin-bottom: 10px;\">5. At the last screen, you get to select the name under which the application will appear on the list of programs in the &#8216;Start>Programs&#8217; menu. Again, if you would like to have a number of Apatar instances installed (different versions, for example) make sure each instance is called differently.<\/p>\n<p style=\"margin-bottom: 10px;\">6. Once the application is installed, you can launch it by clicking \u2018Application\u2019 or \u2018Application no Apex\u2019 in Start>Programs>Apatar or \u2018Scheduling\u2019 if you want to start Apatar\u2019s scheduling application. Alternatively, you can double click application.bat, application_noApex.bat, or scheduling.bat in the folder that Apatar is installed to.<\/p>\n<p>&nbsp;<br \/>\n<strong>Linux<\/strong><\/p>\n<p>To install Apatar for Linux, do the following steps:<\/p>\n<p style=\"margin-bottom: 10px;\">1. Unpack the <code style=\"color: black; background-color: #e6e6e6;\">apatar_&lt;version_number&gt;.tar.gz<\/code> archive into any directory (e.g., <code style=\"color: black; background-color: #e6e6e6;\">&lt;apatar_folder&gt;<\/code>).<\/p>\n<p style=\"margin-bottom: 10px;\">2. Change system parameters for all files with the .sh extension in the <code style=\"color: black; background-color: #e6e6e6;\">&lt;apatar_folder&gt;<\/code> directory.<\/p>\n<p><b>Example:<\/b><\/p>\n<p><i>Run this command from consol: <code style=\"color: black; background-color: #e6e6e6;\">#chmod 777 application.sh<\/code>.<\/i><\/p>\n<p style=\"margin-bottom: 10px;\">3. To start using Apatar, run any file that has the .sh extension. If you would like to run Apatar as a regular application (default), you need to launch the application.sh file. If you would like to run Apatar as a scheduling application (scheduling), you need to launch the scheduling.sh file (for example, #.\/application.sh).<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Registration\"><\/span>Registration<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>When you start Apatar for the first time, the registration form opens up.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-apatar-registration-form.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-apatar-registration-form.png\" alt=\"\" width=\"500\" height=\"600\" class=\"alignnone size-full wp-image-57214\" \/><\/a><br \/>\n<small>The Apatar registration form<\/small><\/center><br \/>\n<\/p>\n<p>If you have previously registered a user with Apatar (via Apatar application), keep the \u2018Existing User\u2019 selection and enter your username and password. If you do not yet have your username and password, select \u2018New User\u2019 and fill in the registration form. You can check whether the username you entered is taken or available before submitting the form by clicking \u2018Check Availability\u2019 next to the \u2018User Name\u2019 field. While creating your password, keep in mind that you can only use letters and digits.<\/p>\n<p>If you are using a proxy server, tick the \u2018Set up Proxy Server\u2019 checkbox and enter your proxy details.<\/p>\n<p><i>Note:<\/i> You have to be connected to the Internet during the registration, as Apatar will need to send the data you entered to the server to verify your username and password or create a new user.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Application_components\"><\/span>Application components<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>&nbsp;<br \/>\n<strong>Application vs. Application no Apex<\/strong><\/p>\n<p>There are two applications available after installation: Application and Application no Apex. The only difference between them is that Application no Apex saves Salesforce.com access credentials. So if you are working with Salesforce CRM and especially if you are scheduling Salesforce CRM integrations, use Application no Apex.<\/p>\n<p><i>Note:<\/i> If you open a datamap by double clicking it, it appears in the Application.<\/p>\n<p>If you opened your Salesforce CRM integration datamap in Application, exit Apatar without saving the datamap. This way, your Salesforce.com access credentials will not be lost.<\/p>\n<p>&nbsp;<br \/>\n<strong>Top menu<\/strong><\/p>\n<p>This is the list of the top menu items and the functions they perform.<\/p>\n<p>1. FILE<\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\"><b>New<\/b> creates a new datamap file.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Open<\/b> opens an existing datamap.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Save<\/b> saves the datamap.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Save As<\/b> saves the datamap under a different name\/to a different location.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Publish to Apatar<\/b> posts your datamap to www.apatarforge.org if you would like to share it with other Apatar users.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Scheduling<\/b> opens Apatar\u2019s scheduling application.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Run<\/b> starts the transformation.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Options:<\/b><\/li>\n<ul>\n<li style=\"margin-bottom: 6px;\"><b>Proxy<\/b> enables you to enter\/modify your proxy server settings. Details entered here will be applied throughout the Apatar application.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Date and Time<\/b> allows you to set the date and time format that is convenient for you. This allowed Apatar to simplify the process of filtering, validating, and processing data by date and\/or time. You will not need to know the exact format of date\/time, as it is stored in you database. Instead, if there is a need to validate data by date, you will enter the date in the format that is default for your instance of the application.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Debug Options<\/b> if checked, debug and error logs will be cleared each time you click &#8216;File>Run&#8217; or &#8216;Run and Preview Results.&#8217; This way, if an error occurs during the transformations, you can be sure that the logs contain all up-to-date information.<\/li>\n<\/ul>\n<li style=\"margin-bottom: 6px;\"><b>Exit<\/b> closes Apatar application<\/li>\n<\/ul>\n<p>2. EDIT<\/p>\n<p><i>Note:<\/i> Not available in Apatar version 1.12.13 and older<\/p>\n<ul>\n<li><b>Cut<\/b><\/li>\n<li><b>Copy<\/b><\/li>\n<li><b>Paste<\/b><\/li>\n<li><b>Delete<\/b><\/li>\n<\/ul>\n<p>These menu items let you copy\/cut and paste or delete parts of your datamaps within the same datamap file or from one datamap file to another. You can copy the configured connectors and\/or operations, field mappings, and functions<\/p>\n<p>3. VIEW<\/p>\n<p>Changes the application layout.<\/p>\n<p>4. DEBUG<\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\"><b>Show Output (The \u2018Debug Console\u2019 window)<\/b> shows information on successful and unsuccessful actions performed by the application.\n<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Show Error (The \u2018Error Console\u2019 window)<\/b>\tshows information related to errors.<\/li>\n<\/ul>\n<p>The same information is written to debug_output.txt and error_output.txt files respectively. (The files are located in the folder that you have Apatar installed to.)<\/p>\n<p>If you click \u2018Clear\u2019 in the Debug Console, debug information will be deleted from this window and the debug_output.txt file. If you click \u2018Clear\u2019 in the Error Console, debug information will be deleted from this window and the error_output.txt file.<\/p>\n<p>If you have \u2018Clear debug and error outputs before each run\u2019 checked in File>Options>Debug Options, information will be deleted from both consoles and output files each time you click &#8216;File>Run&#8217; or &#8216;Run and Preview Results.&#8217;<\/p>\n<p>5. COMMUNITY<\/p>\n<ul>\n<li>Catalog of Datamaps<\/li>\n<li>Demos<\/li>\n<li>Forums<\/li>\n<li>Wiki<\/li>\n<\/ul>\n<p>6. HELP<\/p>\n<ul>\n<li><b>About<\/b> contains product information<\/li>\n<li><b>Feature Request<\/b> opens a feature request form<\/li>\n<li><b>Submit Bugs<\/b>\topens a bug submit form<\/li>\n<li><b>Tutorials<\/b> opens the community documentation web page<\/li>\n<\/ul>\n<p>&nbsp;<br \/>\n<strong>Context menu<\/strong><\/p>\n<p>This is the list of the context menu items and the functions they perform.<\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\"><b>Configure<\/b> opens a connector, operation, or function for configuration.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Cut, Copy, Paste, and Delete<\/b> enable you to copy\/cut and paste or delete parts of your datamaps within the same datamap file or from one datamap file to another. You can copy the configured connectors and\/or operations, field mappings, and functions.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Change Name<\/b> renames a component.<\/li>\n<li style=\"margin-bottom: 6px;\"><b>Run and Preview Results<\/b> processes the selected node and previous nodes (connectors and operations). If clicked on a connector or there is a connector preceding the selected node, the data will be written to the connector(s), and the records resulting from this node processing will be displayed.<\/li>\n<\/ul>\n<p>&nbsp;<br \/>\n<strong>List of nodes<\/strong><\/p>\n<p>On the left, there is a tree with nodes grouped by type.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-list-of-nodes.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-list-of-nodes.png\" alt=\"\" width=\"550\" height=\"280\" class=\"alignnone size-full wp-image-57220\" \/><\/a><br \/>\n<small>The list of nodes<\/small><\/center><br \/>\n<\/p>\n<ul>\n<li><b>Connectors<\/b> represent data sources that you can access.<\/li>\n<li><b>Data Quality Services<\/b> are connectors to some CDYNE and StrikeIron\u2019s Web services (you must have an account with the related Web service to use it).<\/li>\n<li><b>Operations<\/b><\/b> are actions that you can perform with your data.<\/li>\n<\/ul>\n<p>&nbsp;<br \/>\n<strong>Work area<\/strong><\/p>\n<p>Most of the application window is taken up by the work area where you design your data integrations (datamaps).<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-work-area.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-work-area.png\" alt=\"\" width=\"550\" height=\"280\" class=\"alignnone size-full wp-image-57228\" \/><\/a><br \/>\n<small>The work area<\/small><\/center><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Supported_data_sources_connectors\"><\/span>Supported data sources (connectors)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Having over 30 connectors, Apatar works with the data sources shown in the table.<\/p>\n<table cellspacing=\"1\" cellpadding=\"0\" border=\"1\">\n<tr style=\"background-color:#f2f2f2;\">\n<td valign=\"top\" style=\"width:25%\"><small><center><b>Applications<\/b><\/center><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><center><b>Databases<\/b><\/center><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><center><b>Files<\/b><\/center><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><center><b>File exchange<\/b><\/center><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><center><b>Protocols<\/b><\/center><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><center><b>Other<\/b><\/center><\/small><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" style=\"width:25%\"><small>Centric CRM<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>DBase<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>.CSV<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>Amazon S3<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>HTTP<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>Custom table<\/small><\/td>\n<\/tr>\n<tr>\n<tr style=\"background-color:#f2f2f2;\">\n<td valign=\"top\" style=\"width:25%\"><small>Compiere<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>IBM DB2<\/td>\n<td valign=\"top\" style=\"width:25%\"><small>.TXT<\/td>\n<td valign=\"top\" style=\"width:25%\"><small>BuzzSaw<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>LDAP<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>E-mail<\/small><\/td>\n<\/tr>\n<\/tr>\n<tr>\n<td valign=\"top\" style=\"width:25%\"><small>Eloqua<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>IBM AS\/400<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>EditGrid<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>File System<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>ODBC<\/small><\/td>\n<\/tr>\n<tr>\n<tr style=\"background-color:#f2f2f2;\">\n<td valign=\"top\" style=\"width:25%\"><small>EnterpriseDB <\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>MySQL<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>MS Excel<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>Flickr<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>RSS<\/small><\/td>\n<\/tr>\n<\/tr>\n<tr>\n<td valign=\"top\" style=\"width:25%\"><small>GoldMine<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>OpenEdge<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>XML<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>FTP<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<\/tr>\n<tr>\n<tr style=\"background-color:#f2f2f2;\">\n<td valign=\"top\" style=\"width:25%\"><small>OpenBravo ERP<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>Oracle<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>WebDav<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<\/tr>\n<\/tr>\n<tr>\n<td valign=\"top\" style=\"width:25%\"><small>Salesforce CRM<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>PostgreSQL<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<\/tr>\n<tr>\n<tr style=\"background-color:#f2f2f2;\">\n<td valign=\"top\" style=\"width:25%\"><small>SugarCRM<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>SQL Server<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<\/tr>\n<\/tr>\n<tr>\n<td valign=\"top\" style=\"width:25%\"><small>vTiger CRM<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>Sybase<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<\/tr>\n<tr>\n<tr style=\"background-color:#f2f2f2;\">\n<td valign=\"top\" style=\"width:25%\"><small>other systems<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>SyBASE<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<\/tr>\n<\/tr>\n<tr>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>Vertica<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<\/tr>\n<tr>\n<tr style=\"background-color:#f2f2f2;\">\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small>Firebird<\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<td valign=\"top\" style=\"width:25%\"><small><\/small><\/td>\n<\/tr>\n<\/tr>\n<\/table>\n<p>Applications data can be accessed via a particular connector for that system, a relevant database connector, or the ODBC Generic connector if a system provides the ODBC driver.<\/p>\n<p>Using Apatar\u2019s connectors, you can insert or update (upsert) data (except for LDAP connector, which is read-only). Some connectors also support the delete mode, and the connector for Salesforce CRM can synchronize data.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Supported_operations\"><\/span>Supported operations<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>With Apatar, you can do the following operations:<\/p>\n<ul>\n<li><b>transform<\/b> data from one system to another preserving links between linked tables\/objects<\/li>\n<li><b>aggregate<\/b> data from multiple sources<\/li>\n<li><b>perform<\/b> inner, left, or right join of data from different tables within one source or different data sources<\/li>\n<li><b>distinct<\/b> data<\/li>\n<li><b>validate<\/b> data using certain conditions and break it down into several streams based on the validation results<\/li>\n<li><b>filter<\/b> data that cannot be filtered by a query at the connector level by a condition or a set of conditions<\/li>\n<li><b>perform<\/b> bi-directional update of data between JDBC sources or a JDBC source and Salesforce<\/li>\n<\/ul>\n<p>Each operation (except for Distinct) has at least one Inputs tab with the fields from your data source, the Functions tab, and the Edit Output button.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-edit-output-button.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-edit-output-button.png\" alt=\"\" width=\"217\" height=\"105\" class=\"alignnone size-full wp-image-57238\" \/><\/a><br \/>\n<small>The Edit Output button<\/small><\/center><br \/>\n<\/p>\n<p>Use \u2018Edit Output\u2019 when you have one operation linked to another one to create output fields in that first operation.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-add-from-inputs-button.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-add-from-inputs-button.png\" alt=\"\" width=\"228\" height=\"119\" class=\"alignnone size-full wp-image-57239\" \/><\/a><br \/>\n<small>The Add from Inputs button<\/small><\/center><br \/>\n<\/p>\n<p>If you click &#8216;Add from Inputs,&#8217; Apatar will copy output fields from input fields. If you have two inputs (in Join or Aggregate operation) and they have fields with the same names, Apatar will add the \u2018_2\u2019 suffix to the second field name. Alternatively, you can use the \u2018+\u2019 and \u2018-\u2019 buttons to create fields (set field name and select data types).<\/p>\n<p><i>Note:<\/i> \u2018Edit Output\u2019 only creates fields in Apatar\u2019s temporary table. It cannot be used to create a new table in your data target.<\/p>\n<p>Some operations also have the \u2018Automap\u2019 button.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-automap-button.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-automap-button.png\" alt=\"\" width=\"216\" height=\"116\" class=\"alignnone size-full wp-image-57241\" \/><\/a><br \/>\n<small>The Automap button<\/small><\/center><br \/>\n<\/p>\n<p>It allows you to link input and output fields that are 100% identical (in terms of field properties, such as name, type, size, etc.) automatically.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Functions\"><\/span>Functions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>All operations have the \u2018Functions\u2019 tab located either on the right (in Filter and Validate) or on the left of the screen along with input tab(s). It contains a set of functions that you can use to handle your data.<\/p>\n<p>There are a number of data type conversion functions (which start with the \u2018To\u2019 prefix) that should be used between the fields that have different data types. <\/p>\n<p><b>Example:<\/b><\/p>\n<p><i>Use the <code style=\"color: black; background-color: #e6e6e6;\">To String<\/code> function if you are writing from a Date, Boolean, LongText, etc., field to a Text field. Use <code style=\"color: black; background-color: #e6e6e6;\">To Date<\/code> if you write from a text field to a Date field.<\/i><\/p>\n<p>Constants (Text Constant, Boolean Constant, Current Date Constant, etc.) enable you to write the same value to a field for all records being processed. Functions, such as <code style=\"color: black; background-color: #e6e6e6;\">Greater Than<\/code>, <code style=\"color: black; background-color: #e6e6e6;\">Contains<\/code>, <code style=\"color: black; background-color: #e6e6e6;\">Is Empty<\/code>, <code style=\"color: black; background-color: #e6e6e6;\">Match RegExp<\/code>, etc., return Boolean <code style=\"color: black; background-color: #e6e6e6;\">true<\/code> or <code style=\"color: black; background-color: #e6e6e6;\">false<\/code> values and can be used to generate a Boolean based on the incoming records field values or to set up conditions in Filter, Validate, or Update operations.<\/p>\n<p>Examples of other functions:<\/p>\n<ul>\n<li><code style=\"color: black; background-color: #e6e6e6;\">RegExp<\/code> applies a Regular Expression to input field values.<\/li>\n<li><code style=\"color: black; background-color: #e6e6e6;\">Concatenate\t<\/code> merges two strings into a single one using this function.<\/li>\n<li><code style=\"color: black; background-color: #e6e6e6;\">Replace With Function<\/code> replaces multiple field values with new ones using this function.<\/li>\n<li> The <code style=\"color: black; background-color: #e6e6e6;\">And<\/code> and <code style=\"color: black; background-color: #e6e6e6;\">Or<\/code> functions can be used to set up complex conditions.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Building_a_data_integration_job_datamap\"><\/span>Building a data integration job (datamap)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Here are some recommendations on how to create a data integration job.<\/p>\n<p>&nbsp;<br \/>\n<strong>Connectors configuration<\/strong><\/p>\n<p>Drag and drop connectors to the data sources you need to work with to the work area. To configure a connector, either double click it or right click it and select \u2018Configure.\u2019<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/configuring-a-connector.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/configuring-a-connector.png\" alt=\"\" width=\"188\" height=\"150\" class=\"alignnone size-full wp-image-57242\" \/><\/a><br \/>\n<small>Configuring a connector<\/small><\/center><br \/>\n<\/p>\n<p>At the first screen, enter your data source access details. Here, you can also select the connection to be used or create a new one.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/creating-a-new-connection.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/creating-a-new-connection.png\" alt=\"\" width=\"500\" height=\"381\" class=\"alignnone size-full wp-image-57243\" \/><\/a><br \/>\n<small>Creating a new connection<\/small><\/center><br \/>\n<\/p>\n<p>A connection includes data source access details, table selection, query (where supported), and mode. So, if you need to work with different tables within the same data source, it is not recommended to use the same connection as in the connector that is already working with that data source, because the changing connection settings within one connector (selecting a different table or changing a query, for example) will apply these changes to the rest of the connectors using the same connection.<\/p>\n<p>For most connectors, the second screen normally contains the list of tables\/data objects. The JDBC-based connectors and the connectors for Salesforce CRM also have a query box at this screen. This is where you can enter custom queries to filter records before they are retrieved to Apatar\u2019s temporary table, limit the selection of columns, or read data from multiple tables if your data source supports the JOIN queries. Select the table you want to work with and click &#8216;Next.&#8217;<\/p>\n<p><i>Note:<\/i> One connector can only work with one table, unless you are reading from a data source that supports the JOIN queries. If you need to write to the related tables, use the Join operation.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/09\/adding-custom-queries.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2013\/09\/adding-custom-queries.png\" alt=\"\" width=\"502\" height=\"291\" class=\"alignnone size-full wp-image-57621\" \/><\/a><small>Customizing queries<\/small><\/center><br \/>\n<\/br><\/p>\n<p>The next screen shows the list of fields retrieved from the table selected. If you are writing data via a connector, at this screen you also select the mode in which the integration should run and if the table should be cleared if any data is written to it.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/selecting-the-mode.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/selecting-the-mode.png\" alt=\"\" width=\"500\" height=\"313\" class=\"alignnone size-full wp-image-57259\" \/><\/a><br \/>\n<small>The list of fields<\/small><\/center><br \/>\n<\/br><\/p>\n<p>If you select the Update, Synchronization, or Delete mode, you have to select a field or set of fields that will be used as a primary key to match incoming and existing records.<\/p>\n<p>&nbsp;<br \/>\n<strong>Operations configuration<\/strong><\/p>\n<p>Once you are done with configuring connectors, drag and drop the operation(s) needed.<\/p>\n<p><i>Note:<\/i> If your source and target tables structures are 100% identical (in terms of field number and properties), you can link data sources directly.<\/p>\n<p>To link connectors and operations, click on the output (red) point of your source connector, hold your mouse key, move the cursor to operation\u2019s input (green) point, and release the key.<\/p>\n<p>Just like with connectors, double-click or left-click an operation and select \u2018Configure\u2019 to start setting up actual fields mapping or validation\/filtering condition. Drag and drop input and output fields and link them in the same way as you linked connectors and operations. Use functions where needed. You can use multiple functions between input and output fields.<\/p>\n<p>If you selected the Update, Synchronization, or Delete mode, make sure you use the field(s) selected as the primary key in your fields mapping. Keep in mind that you can copy elements of your datamap.<\/p>\n<p>Fields mapped can be copied and pasted between operations of the same type (from one &#8216;Transform&#8217; to another, but not from &#8216;Transform&#8217; to &#8216;Join,&#8217; for example). Functions (<code style=\"color: black; background-color: #e6e6e6;\">RegExp<\/code>, <code style=\"color: black; background-color: #e6e6e6;\">Replace With<\/code>, etc.) can be copied from an operation of one type to an operation of another type (from &#8216;Filter&#8217; to &#8216;Validate,&#8217; for example). You can use the \u2018Edit\u2019 menu to copy elements of your datamap. Alternatively, once you select the elements to be copied, you can right-click them and select the right edit operation. Ctrl+C and Ctrl+V key combinations are also enabled.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Running_a_data_integration_job_datamap\"><\/span>Running a data integration job (datamap)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Here are some recommendations on how to run a data integration job.<\/p>\n<p>&nbsp;<br \/>\n<strong>Datamap testing<\/strong><\/p>\n<p>Once you have your datamap configured, you can start testing it.<\/p>\n<p>To make sure that you see relevant error and debug logs, it is recommended that you either clear logs in Debug> Show Output and Debug Show error before every run\/previewing result or tick \u2018Clear debug and error logs before each run\u2019 in the File>Options>Debug Options menu.<\/p>\n<p>Start with previewing the results (Run and Preview Results on the context menu) on your source connector to make sure the right data will be retrieved. If everything is Ok, move to the next component. Previewing the results at each step (as opposed to running the entire datamap right away) will help you understand where the problem might be if an error occurs.<\/p>\n<p><b>Example:<\/b><\/p>\n<p><i>Let\u2019s say you are retrieving records from SugarCRM, filtering and writing them to a MySQL database.<\/i><\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/filtering-and-writing-records-mysql.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/filtering-and-writing-records-mysql.png\" width=\"357\" height=\"105\" class=\"alignnone size-full wp-image-57260\" \/><\/a><br \/>\n<small>Filtering and writing records to MySQL<\/small><\/center><br \/>\n<\/p>\n<p><i>Preview on the connector for SugarCRM shows the right records, preview on Filter shows you only the records that should be passed further, but preview on Transform does not return anything. This means there is an issue with fields mapping and you could take a closer look at the Transform\u2019s configuration.<\/i><\/p>\n<p><i>Note:<\/i> Keep in mind that \u2018Run and Preview Results\u2019 will write data to a connector.<\/p>\n<p>&nbsp;<br \/>\n<strong>Manual run<\/strong><\/p>\n<p>There are two ways to run a datamap:<\/p>\n<ul>\n<li><b>File>Run<\/b> on the top application menu<\/li>\n<li><b>Run and Preview Results<\/b> on the context menu<\/li>\n<\/ul>\n<p>The difference between the two is that \u2018File>Run\u2019 will show the Progress window, which will then close once a datamap is processed. It is recommended for datamaps that have multiple targets or independent datamaps within one file.<\/p>\n<p>Datamaps that are not linked to each other will be processed in the order in which they have been created.<\/p>\n<p><i>In the screenshot below, Datamap 2 was created after Datamap 1, so even though it is located above Datamap 1, Datamap 2 will be processed only after Datamap 1 has been completed (regardless of whether the transformation has been successful or not).<\/i><\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/processing-datamap1-datamap2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/processing-datamap1-datamap2.png\" alt=\"\" width=\"323\" height=\"226\" class=\"alignnone size-full wp-image-57261\" \/><\/a><br \/>\n<small>Processing Datamap 1 and Datamap 2<\/small><\/center><br \/>\n<\/p>\n<p>If you select to run your datamap using \u2018Run and Preview Results,\u2019 the data will be written to the target connector that you clicked on. Once writing is completed (regardless of the result), the data will be written from this connector.<\/p>\n<p><i>Note:<\/i> Apatar will retrieve all records from the selected table or matching the Select query entered in the connector, not just the records that have been inserted\/updated.<\/p>\n<p>If you have a datamap with multiple targets, you will have to click \u2018Run and Preview Results\u2019 at each target to get data written to all of them. Each time the datamap will be processed from the start. This approach is not recommended for datamaps that have auto-generated values (<code style=\"color: black; background-color: #e6e6e6;\">Generate UUID<\/code>, <code style=\"color: black; background-color: #e6e6e6;\">CurrentTimeStamp<\/code>, and some other functions) written to an intermediate connector.<\/p>\n<p><b>Example:<\/b><\/p>\n<p><i>Let\u2019s say you are writing to a database that has a table storing company profiles (accounts), a table for contacts, a table where relationships between contacts and accounts, and a separate table with customer e-mail addresses that does have a field holding the related contact id.<\/i><\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/database-with-multiple-targets.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/database-with-multiple-targets.png\" alt=\"\" width=\"465\" height=\"271\" class=\"alignnone size-full wp-image-57262\" \/><\/a><br \/>\n<small>A database with multiple targets<\/small><\/center><br \/>\n<\/p>\n<p><i>As the database does not record ids automatically, the <code style=\"color: black; background-color: #e6e6e6;\">GenerateUUID<\/code> function is used in both \u2018Transform\u2019 operations to generate ids. The <code style=\"color: black; background-color: #e6e6e6;\">accounts<\/code> and <code style=\"color: black; background-color: #e6e6e6;\">contacts<\/code> connectors are configured to run in the Update mode in case such account or contact already exists in the system.<\/i><\/p>\n<p><i>You will first click \u2018Run and Preview Results\u2019 on <code style=\"color: black; background-color: #e6e6e6;\">accounts_contacts<\/code>. This will create an account record in <code style=\"color: black; background-color: #e6e6e6;\">accounts<\/code>, a contact record in <code style=\"color: black; background-color: #e6e6e6;\">contacts<\/code>, and then a record in <code style=\"color: black; background-color: #e6e6e6;\">accounts_contacts<\/code> that stores ids of prospects and ids of the related accounts.<\/i><\/p>\n<p><i>Now when you click \u2018Run and Preview Results\u2019 on <code style=\"color: black; background-color: #e6e6e6;\">email_addresses<\/code> without modifying your datamap, the processing will start from both target tables; both \u2018Transforms\u2019 will get processed again, new ids will be generated and written to the records that were created during the previous run. When e-mails get written to <code style=\"color: black; background-color: #e6e6e6;\">email_addresses<\/code>, they will be related to the right contacts using new ids. However, the account and contact records updated with the new ids will no longer be related because the <code style=\"color: black; background-color: #e6e6e6;\">accounts_contacts<\/code> table has not been updated and it still holds old ids\u2014the ids that no longer exist in the system.<\/i><\/p>\n<p>When your datamap is being processed, you can see the &#8216;Progress&#8217; window.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/a-progess-window.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/a-progess-window.png\" alt=\"\" width=\"500\" height=\"264\" class=\"alignnone size-full wp-image-57263\" \/><\/a><br \/>\n<small>The &#8216;Progress&#8217; window<\/small><\/center><br \/>\n<\/p>\n<p>It shows the steps being completed and the number of records processed. Some types of errors are also shown here. If an error occurs and you would like to stop the transformation, click &#8216;Cancel.&#8217; Make sure \u2018Finish\u2019 is shown at the end of the log in the progress window. This will mean that the transformation stopped.<\/p>\n<p><i>Note:<\/i> During processing, Apatar creates a temporary table where data is stored. So, you need to have enough free space on the disk where Apatar is installed\u2014at least, the amount that equals the size of data you are working with.<\/p>\n<p>&nbsp;<br \/>\n<strong>Scheduled run<\/strong><\/p>\n<p>There are two ways to run Apatar datamaps based on a specific schedule:<\/p>\n<ul>\n<li>Apatar\u2019s own scheduling application<\/li>\n<li>system\u2019s scheduled tasks<\/li>\n<\/ul>\n<p>The scheduling application has the functionality to set up data integrations to run daily or on certain days during a week\/month\/year, run once or several times during a day, run until it is deleted from the list of jobs or stopped or expire after a certain date or number of runs.<\/p>\n<p>The specific feature of the Apatar\u2019s Scheduling app is that it does not run as a service. If you log off, shut down, or re-boot the machine it is running at, it will get closed, too, and your scheduled integrations will not be launched. So, you will have to open it manually next time you log in.<\/p>\n<p>If you use the Apatar\u2019s Scheduling application, you can check logs in the error_output2.txt and debug_output2.txt files in the folder Apatar\u2019s installed to. As an alternative to the Scheduling application, you can use the system\u2019s own scheduled tasks using the command line parameters.<\/p>\n<p>If you are using Windows Vista or Windows 7, you can enter command line parameters to the scheduled task itself. For Windows XP, you will need to create a .bat file (ordinary text file saved with the .bat extension) that would contain the correct command to be executed and schedule this .bat file.<\/p>\n<p>When you set up scheduled tasks in the system, remember to enter the username and password of the user under which tasks should be run. If you schedule Apatar datamaps this way, logs will be written to the error_output.txt and debug_output.txt files in the folder Apatar\u2019s installed to.<\/p>\n<p>As Apatar does not have any native functionality to be triggered by certain events in other systems and applications, these command line parameters can also be used as a part of the script that will make Apatar to be involved in a more complex process and start a datamap processing upon a certain event.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Error_handling\"><\/span>Error handling<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Here are some typical errors returned by Apatar. They appear either in the &#8216;Progress&#8217; window, in &#8216;Debug>Show Error,&#8217; or in both locations.<\/p>\n<p style=\"margin-bottom: 6px;\">1. <code style=\"color: black; background-color: #e6e6e6;\">\u2018ArrayIndexOutOfBoundsException: 0\u2019<\/code>, <code style=\"color: black; background-color: #e6e6e6;\">\u2018StringIndexOutOfBoundsException: String index out of range: -1\u2019<\/code><\/p>\n<ul>\n<li>Visual signs of the error: None.<\/li>\n<li>Problem: Clicks on components that are not clickable.<\/li>\n<li>Solution: None. These are errors related to UI and not influencing actual data transformations. Should be ignored.<\/li>\n<\/ul>\n<p style=\"margin-bottom: 6px;\">2. <code style=\"color: black; background-color: #e6e6e6;\">\u2018Table\/View 'TEMP1285164176545' does not exist\u2019<\/code><\/li>\n<ul>\n<p style=\"margin-bottom: 6px;\">Visual signs of the error: An empty preview screen with no fields.<\/p>\n<\/ul>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/an-empty-preview-screen-with-no-fields.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/an-empty-preview-screen-with-no-fields.png\" alt=\"\" width=\"500\" height=\"147\" class=\"alignnone size-full wp-image-57266\" \/><\/a><br \/>\n<small>An empty preview screen with no fields<\/small><\/center><br \/>\n<\/p>\n<p>There are several reasons for this error.<\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\">Problem 1: If you are reading from a database using a join query, you are probably selecting fields with the same name\u2014RECID, for example. In this case, the error will be most likely accompanied by another error like: Column name &#8216;RECID&#8217; appears more than once in the CREATE TABLE statement.<\/li>\n<li style=\"margin-bottom: 6px;\">Solution 1: If you need both of the fields, select one of them under a different name.<\/li>\n<li style=\"margin-bottom: 6px;\">Problem 2: While creating a temporary table, the Derby database malfunctioned and could not build a table.<\/li>\n<li style=\"margin-bottom: 6px;\">Solution 2: Go to Apatar\u2019s folder, delete the \u2018tempdb\u2019 folder, and start Apatar again.<\/li>\n<\/ul>\n<p style=\"margin-bottom: 6px;\">3. <code style=\"color: black; background-color: #e6e6e6;\">\u2018Invalid character string format for type SMALLINT\u2019 and similar errors<\/code><\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\">Visual signs of the error: Window with no or only existing records shown on preview.<\/li>\n<li style=\"margin-bottom: 6px;\">Problem: Fields of incompatible types are linked directly.<\/li>\n<li style=\"margin-bottom: 6px;\">Solution: Insert proper data type conversion function (To String, To Int16, To Date, etc.) between the input and output fields of different types.<\/li>\n<\/ul>\n<p style=\"margin-bottom: 6px;\">4. <code style=\"color: black; background-color: #e6e6e6;\">\u2018A truncation error was encountered trying to shrink VARCHAR 'sometestvaluehere' to length 2.\u2019<\/code><\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\">Visual signs of the error: The preview window shows no records (if the error occurred on all records) or just records where this error did not occur.<\/li>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/A-preview-window-with-no-records.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/A-preview-window-with-no-records.png\" alt=\"\" width=\"500\" height=\"104\" class=\"alignnone size-full wp-image-57281\" \/><\/a><br \/>\n<small>A preview window with no records<\/small><\/center><br \/>\n<\/p>\n<li style=\"margin-bottom: 6px;\">Problem: An input field contained more characters than a related output field allows.<\/li>\n<li style=\"margin-bottom: 6px;\">Solution: Either change output field size to allow the same number of characters as the input field, or, if this is not possible, utilize the Crop Right function. (If applied to fields other than text fields, To String should be used before it.)<\/li>\n<\/ul>\n<p style=\"margin-bottom: 6px;\">5. <code style=\"color: black; background-color: #e6e6e6;\">\u2018Column 'Company' specified twice\u2019<\/code><\/li>\n<ul>\n<li style=\"margin-bottom: 6px;\">Visual signs of the error: The preview window shows no records.<\/li>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/A-preview-window-with-no-records.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/A-preview-window-with-no-records.png\" alt=\"\" width=\"500\" height=\"104\" class=\"alignnone size-full wp-image-57281\" \/><\/a><br \/>\n<small>A preview window with no records<\/small><\/center><br \/>\n<\/p>\n<li style=\"margin-bottom: 6px;\">Problem: An output field is used twice in fields mapping within the same operation.<\/li>\n<li style=\"margin-bottom: 6px;\">Solution: Review your fields mapping and make sure each output field is only used once.<\/li>\n<\/ul>\n<p style=\"margin-bottom: 6px;\">6. <code style=\"color: black; background-color: #e6e6e6;\">\u2018Comparisons between 'VARCHAR (UCS_BASIC)' and 'LONG VARCHAR (UCS_BASIC)' are not supported.\u2019<\/code><\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\">Visual signs of the error: The preview window shows no records.<\/li>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/A-preview-window-with-no-records.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/A-preview-window-with-no-records.png\" alt=\"\" width=\"500\" height=\"104\" class=\"alignnone size-full wp-image-57281\" \/><\/a><br \/>\n<small>A preview window with no records<\/small><\/center><br \/>\n<\/p>\n<li style=\"margin-bottom: 6px;\">Problem: The &#8216;Join&#8217; operation uses fields of different types in the \u2018Join on\u2019 tab to match records from different tables.<\/li>\n<li style=\"margin-bottom: 6px;\">Solution: If you are working with a database as one of the sources, you can cast the field(s) used in \u2018Join on\u2019 to transform it to the same type as the related field of the second data source. Alternatively, use &#8216;Transform&#8217; between a data source and &#8216;Join&#8217;. In &#8216;Transform&#8217;, use \u2018Edit Output\u2019>\u2019Add from Inputs\u2019 to create output fields, find the field you are going to join on, and change its data type to the data type of the other data source field you will be relating it to. In the work area, link all the fields you are going to be working with. In \u2018Join,\u2019 go to \u2018Join on\u2019 and re-select the field with changed data type so that it is updated in Apatar\u2019s temporary database. If you also used this field in fields mapping in Join, make sure to replace it with the new field.<\/li>\n<\/ul>\n<p style=\"margin-bottom: 6px;\">7. Each node processed several times<\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\">Visual signs of the error: Progress log shows that each connector and operation is processed several times, though they are only linked to one other component from their output points.<\/li>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/progress-log.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/progress-log.png\" alt=\"\" width=\"500\" height=\"330\" class=\"alignnone size-full wp-image-57282\" \/><\/a><br \/>\n<small>Progress log<\/small><\/center><br \/>\n<\/p>\n<li style=\"margin-bottom: 6px;\">Problem: Apache Derby database malfunction.<\/li>\n<li style=\"margin-bottom: 6px;\">Solution: Close Apatar, delete the \u2018temdb\u2019 folder from the folder you have Apatar installed to, and launch Apatar again.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Warnings_and_notifications\"><\/span>Warnings and notifications<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This is the list of the most common warning and notification messages.<\/p>\n<p style=\"margin-bottom: 6px;\">1. <code style=\"color: black; background-color: #e6e6e6;\">\u2018An error occurred while opening the Datamap: Uninitialized properties were found.\u2019<\/code><\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\">Problem: A datamap was created using an older version of Apatar. The newer version of the application that the datamap is opened with has some important modifications in one of the connectors or operations used. The modification might not influence the overall datamap performance though.<\/li>\n<li style=\"margin-bottom: 6px;\">Solution: Click through the connectors and operations to make sure they are configured properly.<\/li>\n<\/ul>\n<p style=\"margin-bottom: 6px;\">2. <code style=\"color: black; background-color: #e6e6e6;\">\u2018Current DataMap\u2019 date and time settings differ from your default applications configuration.\u2019<\/code><\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\">Problem: The instance of Apatar that the datamap was created in has date and time settings that differ from default date and time settings used in your Apatar application.<\/li>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-error-message.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/09\/the-error-message.png\" alt=\"\" width=\"523\" height=\"144\" class=\"alignnone size-full wp-image-57283\" \/><\/a><br \/>\n<small>The error message<\/small><\/center><br \/>\n<\/p>\n<li style=\"margin-bottom: 6px;\">Solution: Follow the steps mentioned in the warning. If you decided not to change your applications date and time settings, check operation(s) configuration. If there are date or time contacts or date and\/or time are used in comparison functions, such as Greater Than, Equals, etc., their format should be the same as the default date and time format set in Apatar (in File>Options>Date and Time).<\/li>\n<\/ul>\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\/what-is-apatar-open-source-data-integration\/\">What Is Apatar Open Source Data Integration?<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-web-demos\/\">Apatar Data Integration Web Demos<\/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<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>What is Apatar? | Demo<\/p>\n<\/p>\n<p>Apatar is an open-source cross-platform data integration tool. It can be installed and run on any machine that has some sort of user interface. The tool is designed to enable batch data integration and provide a simple user interface, so that anyone\u2014not just technical experts\u2014can set [&#8230;]<\/p>\n","protected":false},"author":190,"featured_media":57796,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":"","_links_to":"","_links_to_target":""},"categories":[214],"tags":[966,960,895],"class_list":["post-57194","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","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>Apatar Data Integration: A Quick-Start Guide | Altoros<\/title>\n<meta name=\"description\" content=\"This step-by-step tutorial exemplifies how to install and operate Apatar, as well as provides recommendations to address the most common errors.\" \/>\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\/apatar-data-integration-quick-start-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apatar Data Integration: A Quick-Start Guide | Altoros\" \/>\n<meta property=\"og:description\" content=\"What is Apatar? | Demo Apatar is an open-source cross-platform data integration tool. It can be installed and run on any machine that has some sort of user interface. The tool is designed to enable batch data integration and provide a simple user interface, so that anyone\u2014not just technical experts\u2014can set [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2009-09-08T13:08:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-03T03:07:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/09\/apatar-quick-start-data-integration-featured-image.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"503\" \/>\n\t<meta property=\"og:image:height\" content=\"386\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"author\" content=\"Ludmila Radzevich\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ludmila Radzevich\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"24 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/\",\"name\":\"Apatar Data Integration: A Quick-Start Guide | Altoros\",\"isPartOf\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/09\/apatar-quick-start-data-integration-featured-image.gif\",\"datePublished\":\"2009-09-08T13:08:42+00:00\",\"dateModified\":\"2021-06-03T03:07:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/bd58746c6a5bc0d374f8fc1aa663687b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#primaryimage\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/09\/apatar-quick-start-data-integration-featured-image.gif\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/09\/apatar-quick-start-data-integration-featured-image.gif\",\"width\":503,\"height\":386},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.altoros.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apatar Data Integration: A Quick-Start Guide\"}]},{\"@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\/bd58746c6a5bc0d374f8fc1aa663687b\",\"name\":\"Ludmila Radzevich\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Ludmila-Radzevich-96x96.png\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Ludmila-Radzevich-96x96.png\",\"caption\":\"Ludmila Radzevich\"},\"description\":\"Ludmila Radzevich is VP of Business Development at Apatar. She manages the creation of Apatar\u2019s core and the delivery of connectors to various corporate systems and databases. Ludmila is also responsible for interacting with independent contributors to the project, ensuring that their commits seamlessly integrate with Apatar. She is a frequent speaker and participant at international conferences (such as CeBIT in Hannover, Germany).\",\"url\":\"https:\/\/www.altoros.com\/blog\/author\/ludmila\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Apatar Data Integration: A Quick-Start Guide | Altoros","description":"This step-by-step tutorial exemplifies how to install and operate Apatar, as well as provides recommendations to address the most common errors.","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\/apatar-data-integration-quick-start-guide\/","og_locale":"en_US","og_type":"article","og_title":"Apatar Data Integration: A Quick-Start Guide | Altoros","og_description":"What is Apatar? | Demo Apatar is an open-source cross-platform data integration tool. It can be installed and run on any machine that has some sort of user interface. The tool is designed to enable batch data integration and provide a simple user interface, so that anyone\u2014not just technical experts\u2014can set [...]","og_url":"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/","og_site_name":"Altoros","article_published_time":"2009-09-08T13:08:42+00:00","article_modified_time":"2021-06-03T03:07:29+00:00","og_image":[{"width":503,"height":386,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/09\/apatar-quick-start-data-integration-featured-image.gif","type":"image\/gif"}],"author":"Ludmila Radzevich","twitter_misc":{"Written by":"Ludmila Radzevich","Est. reading time":"24 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/","url":"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/","name":"Apatar Data Integration: A Quick-Start Guide | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/09\/apatar-quick-start-data-integration-featured-image.gif","datePublished":"2009-09-08T13:08:42+00:00","dateModified":"2021-06-03T03:07:29+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/bd58746c6a5bc0d374f8fc1aa663687b"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/09\/apatar-quick-start-data-integration-featured-image.gif","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/09\/apatar-quick-start-data-integration-featured-image.gif","width":503,"height":386},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/apatar-data-integration-quick-start-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Apatar Data Integration: A Quick-Start Guide"}]},{"@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\/bd58746c6a5bc0d374f8fc1aa663687b","name":"Ludmila Radzevich","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Ludmila-Radzevich-96x96.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/06\/Ludmila-Radzevich-96x96.png","caption":"Ludmila Radzevich"},"description":"Ludmila Radzevich is VP of Business Development at Apatar. She manages the creation of Apatar\u2019s core and the delivery of connectors to various corporate systems and databases. Ludmila is also responsible for interacting with independent contributors to the project, ensuring that their commits seamlessly integrate with Apatar. She is a frequent speaker and participant at international conferences (such as CeBIT in Hannover, Germany).","url":"https:\/\/www.altoros.com\/blog\/author\/ludmila\/"}]}},"_links":{"self":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/57194","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\/190"}],"replies":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/comments?post=57194"}],"version-history":[{"count":73,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/57194\/revisions"}],"predecessor-version":[{"id":61917,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/57194\/revisions\/61917"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/57796"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=57194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=57194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=57194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}