Salesforce and QuickBooks integration

data integration best practices


Licensing FAQ can be found here

What is Apatar?

Apatar is an innovative and powerful suite of software tools designed to provide extraordinary productivity benefits to those organizations that need to move data in and out of different sources. Applications include data warehousing, data migration, synchronization and application integration.

Apatar can be utilized to:

Integrate data across the enterprise
Populate data warehouses and data marts
Cross systems such as: source systems; flat files; FTP logic; queue-to-queue; and application-to-application
Cross time-zones, currency barriers efficiently
Overcome brittle "mainframe" or legacy code uplinks that transfer data, sometimes unreliably
Schedule, maintain no-code or little code in connections to many different systems

Not only does it make data migration easier and quicker, but it also ensures the quality of the data being integrated.

Where can Apatar be used?

Anywhere that you have data in diverse databases or applications that needs to be captured in a new application, data warehouse, or presented with a single front end.

Is Apatar easy to use?

Apatar is user-friendly and, even for a non-technical user, it would take just a couple of hours to get trained; most users will find it intuitive, with on-line help to guide them if required.

Some business users with limited technical skills may need to have some of the basic techniques explained to them. This can take anywhere from two to five hours depending on what they wish to do. Training to perform complex transformations may take up to three to five days. The training can be delivered either on site or over the web.

What are the advantages of Apatar ?

Apatar has developed sophisticated techniques to ensure that the data integration achieved during "drag and drop" is 100% accurate. The typical custom coding approach requires significant testing after the code has been developed, adding further time and cost (and potential inaccuracy) to a project. The investment to be typically recovered in a few days. Where data integration is required on a regular basis, Apatar will benefit from re-usable connectors and mappings, with a further quantum leap in productivity. The SugarCRM connector provided as a module of Apatar is a good example of this.

Does Apatar provide data quality tools?

Apatar has most popular data quality tools built in to it. Cleansing and de-duplication become easy tasks with Apatar. The application is capable to dramatically reduce costs, time-to-results. Apatar improves productivity for many data quality initiatives.

Can Apatar handle multilingual data?

Apatar is Unicode-compliant, which means that it can handle any language, including languages such as Chinese, Japanese, and Arabic that use multibyte character sets.

Does Apatar support client-server deployments?

Apatar has been designed with a server component and repository that can be shared across multiple clients.

Can Apatar's server run in a multi-threaded fashion optimizing performance levels?

Apatar generates XML metadata files that store all the information captured by the Apatar designer and mapping graphical user interfaces. Apatar's engine manages, executes, and controls the total project execution plan described in XML metadata files. In addition, for each executed job, Apatar generates a detailed report/log. This metadata-centric approach makes it easy to adapt to changes in the external environment and also promote reuse at every level. Users can share XML metadata files to re-use connectivity settings, transformation, and mapping. You can send XML metadata files to another user with the Apatar desktop application or feed XML metadata files to the Apatar server engine to save time and money while integrating data.

Can I develop a connector for my data source (target)?

Open source code of Apatar allows easy building of add-on connectors for any data integration applications, be it legacy, APIs, or semi-structured data sources (targets).