Is it safe to Update and/or Insert records into an accounting software's database? (Pastel Evolution)
Posted
by
user1020317
on Server Fault
See other posts from Server Fault
or by user1020317
Published on 2014-08-22T09:47:02Z
Indexed on
2014/08/22
10:21 UTC
Read the original article
Hit count: 158
Our CRM system can post transactions to our accounts software (Pastel Evolution), but it doesn't perform the required currency conversion. Both systems have different "base" currencies (because of our location), so the figure thats sent to Pastel evolution is right, but it is reflected in the wrong currency. The CRM uses an ODBC connection to post figures to Evolution.
I can make a tool which sits between the two systems which can update and/or insert the transactions into Pastel, by mimicking what the CRM would have done if it was doing the POST.
Is it safe for me to mimic and/or update these transactions directly in the Pastel database? Is it common for important validation to be performed in the ODBC layer, and if so, can I tap into an applications ODBC, or is there a custom driver built by the CRM to communicate with the DB?
© Server Fault or respective owner