Knowledge Integration Dynamics (KID), one of South Africa's leading data management companies, has concluded a system integrator partnership agreement with US-headquartered Apatar to distribute its open source data integration suite in South Africa.
KID will use, consult, train, and offer support services for the Apatar integration package that offers a single interface into all integration projects across Apple, Windows, Linux, SuSE, and Sun Microsystems using an open source architecture and modular applications that deliver flexible deployment options.
"South Africa is a rapidly developing region, and it is very important for us to fill the open source data integration niche in this territory," says Sergei Lobanov, alliance enabler at Apatar.
"With its presence in the South African market, KID, with the help of Apatar, will be able to satisfy customer requirements to integrate legacy and modern systems, applications and databases through a proven track record of data quality services."
Apatar already has in excess of 100 users in South Africa and expects KID to rapidly expand its penetration of the local market. KID is Apatar's first South African partner, opening new opportunities and advantages for both companies. The companies' main target is small and mid-sized companies in South Africa which have a need for a free, easy-to-use extract, transform, and load (ETL) tool. "The growing need for data integration across corporate South Africa, from small to the largest companies, necessitates an open source tool that operates in a number of environments and offers customers the greatest flexibility," says Julian Field, business development director at KID.
"Apatar is at the forefront of the open source wave with an impressive international track record and a number of successful and highly recommended implementations."
Benefits to SA business users
Two of the major benefits of Apatar are its visual job designer and visual transformation mapper, which are 100% Java-based. They obviate the need for coding of any kind. That capability greatly reduces the need for technical skills and makes it appropriate for businesses without a depth of technical skill.
"Apatar reduces the time and cost usually associated with data integration projects through wide connectivity - including connectivity to various data quality services - provided through the tool's intuitive interface," says Field. "It allows data transformation jobs to be built without writing a single line of code."
The suite allows data integration across businesses; users to populate databases and data marts; cross systems such as source systems, flat files, FTP logic, queue-to-queue, and application-to-application; cross time zones and currency barriers; overcome brittle mainframe or legacy code uplinks that, sometimes unreliably, transfer data; and schedule and maintain no-code or little-code in connections to many different systems.
Apatar enables connectivity into Salesforce.com, SugarCRM, MySQL, Oracle, MS SQL, Microsoft Excel, Microsoft Access, GoldMine, DB2, Sybase, PostgreSQL, dBase, EnterpriseDB, vTiger, InnoDB, Openbravo ERP, Compiere ERP, CSV, XML, RSS, ATOM, HTTP queries, POP3, LDAP, FTP, WebDav, Autodesk Buzzsaw, any JDBC data sources, Amazon S3, Flickr, StrikeIron and CDYNE Web services, and more.
"Apatar also runs in a multi-threaded fashion to optimise performance levels," says Lobanov. "It generates XML metadata files that store information captured by the Apatar designer and mapping graphical interfaces. The engine manages, executes, and controls the project execution plan described in XML metadata files and, in addition, for every executed job, it generates detailed reporting or logs."
According to Lobanov, the metadata-centric approach means that it's easy to adapt to changes in the external environment, promoting reuse at every level. Re-using connectivity settings, transformation, and mapping delivers projects more quickly and cost-effectively.
Share