Hi Alan,<br><br>I would suggest going with Webservice API.<br><br>Regards,<br>Prasad<br>vtiger Team<br><br><div><span class="gmail_quote">On 2/18/09, <b class="gmail_sendername">Alan Lord (News)</b> <<a href="mailto:alanslists@gmail.com">alanslists@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Guys,<br> <br> I have a small idea that I want to try out. It came following a roadshow<br> I went to yesterday looking at the Talend Open Studio Data Integration<br> tool.<br> <br> I have another app that I would like to "connect" to vtiger.<br>
<br> There is already a connector in Talend OS for vtiger which seems to be<br> built for 5.0.3 and uses the interfaces set up for the external plugins<br> (i.e. Outlook, TB, Word, firefox etc).<br> <br> There doesn't appear to be a more "generic" interface into vtiger. I am<br>
wanting to synchronise some common data between vtiger and this other<br> app (which I'd rather keep to myself for now) and I am wondering what<br> the best solution is:<br> <br> 1. Access the MySQL db directly<br> 2. Use one of the existing module interfaces (but each has it's<br>
limitations such as one only handles leads and not contacts...)<br> 3. Use the webservices library/API?<br> <br> Both apps may well reside on the same host (for me at any rate) and use<br> the same db so I am wondering about even using triggers and some stored<br>
procedures, but this would limit it's usefulness to just me.<br> <br> On a related but more general question, when one of the applications'<br> databases changes, what is the usual method used to maintain<br> synchronisation? MySQL triggers do not appear (easily at least) to be<br>
able to fire of external apps or scripts so I am thinking that syncing<br> might need to be run automatically on a periodic basis.<br> <br> <br> Sorry I'm a bit vague but I've only just started thinking about this.<br>
<br> Al<br> <br> _______________________________________________<br> Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com">http://jobs.vtiger.com</a><br> </blockquote></div><br>