Apatar Community Forums

RE: Are Mobile CRM provides people for up-to-date information?

pKircher — Thu, 24 Jul 2008 12:02:52 GMT

Blackberry is a mobile -> www.blackberry.com

and yes if its for blackberrys its java

goldmine have a mobile crm solution as well

iam just waiting on a mobile solution for SugarCrm *hehe*

regards Pierre

Are Mobile CRM provides people for up-to-date information?

relavis — Thu, 24 Jul 2008 04:53:05 GMT

Mobile CRM provides sales people with up-to-date information about accounts, contacts as well as helps to mange the sales
opportunities and sales related activates. Is it true?

I was reading some article about [url="http://www.relavis.com/customers.htm"]mobile Customer Relationship[/url] Management (CRM) solutions. They are mentioned
Blackberry device what is this??? Is this a java program? I have no idea about this. Anyone can u give any idea about this??????

KID Delivers Apatar OS Data Integration to South Africa

AlecP — Wed, 23 Jul 2008 12:57:47 GMT

July 23, 2008, Chicopee, MA – Knowledge Integration Dynamics (KID), a Johannesburg-based company that delivers high-performance business intelligence, data warehousing, data integration, and data management solutions, has concluded a system integrator partnership agreement with U.S.-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 Mac OS, Windows, and Linux using an open source architecture and modular applications that deliver flexible deployment options.

The growing need for data integration across corporate South Africa

“South Africa is a quickly developing region and it is very important for us to fill the open source data integration niche,” 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 parties. The companies reveal their main target is small and mid-sized companies in South Africa that 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 the smallest to the largest companies, necessitates an open source tool that operates in a number of environments and offers customers the greatest flexibility,” said 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 South African 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,” said Mr. 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. It can also: 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 with 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 optimize performance levels,” said Mr. 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 Mr. Lobanov, the metadata-centric approach means that it’s easy to adapt to changes in the external environment and promotes reuse at every level. Reusing connectivity settings, transformation, and mapping delivers projects more quickly and cost-effectively.

About Apatar

Apatar is the leading provider of open source software tools for the data integration market. With powerful Extract, Transform, and Load (ETL) capabilities, Apatar enables its users to easily link information between databases (such as MySQL, Microsoft SQL, Oracle), applications (Salesforce.com, SugarCRM), and the top Web 2.0 destinations (Flickr, Amazon S3). Apatar provides support, training, and consulting services for its integration solutions. Headquartered in Western Massachusetts, Apatar operates a development center in Minsk, Belarus. Apatar is currently used by 4200+ organizations and individuals worldwide. For more on Apatar, please visit www.apatar.com and www.apatarforge.org.

About Knowledge Integration Dynamics (Pty) Ltd.

Knowledge Integration Dynamics (KID) offers comprehensive professional consulting and resource services, specializing in business intelligence solutions, data warehousing, data integration, and data management. KID's expertise and skills provide leading-edge business and data solutions, ensuring a consistent and cohesive view of your business. KID uses established and proven methodologies to deploy appropriate technologies, ensuring successful implementations. For more: www.kid.co.za.

New Connector

itsmaheshp — Wed, 23 Jul 2008 04:20:58 GMT

I am having a database with the BLOB data (documents are stored in it) and I need to pull these documents and store it in the File System.

Any idea how this can be done?

Also I am planning to write a new connector.. appreciate if you can give me some inputs or any documentation to start with..

Thanks,
Mahesh

[OP]:Mathematical Functions

maddin — Tue, 22 Jul 2008 14:05:52 GMT

It would be really nice to have, if we could do basic math, like adding number or decimal values and so on.

(or is there a way already? didn�t find any...)

[UI]:Copy & Paste for Connectors & Operators

maddin — Tue, 22 Jul 2008 13:02:01 GMT

I find myself very often creating very similar mappings and would love to be able to just copy & paste �em within a project.

Furthermore it would be an interesting option to change the type of the Operation, so that one could turn an Aggregate into a Join without losing the mapping.

Just some ideas...

RE: JOIN Operator "join on" Condition

maddin — Tue, 22 Jul 2008 11:23:08 GMT

Ok.
Putting it into a custom table first helps.

XML->Transform->Custom Table->Join->MySQL

JOIN Operator "join on" Condition

maddin — Tue, 22 Jul 2008 09:14:01 GMT

Hi apatar folks,

currently I�m trying to join two tables, based on an ID like "ID0012313".
Output:none.

The error log tells me:

Quote:

Caused by: ERROR 42818: Comparisons between 'LONG VARCHAR (UCS_BASIC)' and 'LONG VARCHAR (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation

It reads like string comparisons ARE possible, as long as their collation matches?

I read the data from an XML stream - how could I explicitly convert it to "string" before the JOIN operator?

Version:1.1.12

Run php or shell script/ monitor folders?

anba — Tue, 22 Jul 2008 04:36:47 GMT

Hi all,

Sorry, I could not find any information in the forum on this.

Two quick questions:

Is it possible to run (start) a php or shell script from Apatar?

Can I monitor a folder in the file system and execute actions on incoming files?

Thanks for your help!

A.

RE: Developing ur own Connector Resources?

NinoJose — Tue, 22 Jul 2008 01:05:41 GMT

Hi Arny,

Thanks a lot I'll be checking this.