Is this even feasable? I am development a database using SQL SERVER 2005, and Access Front end. Our company is using EPICOR accounting software. I need to for my DB and the EPICOR system to communicate. In other words, when in my database the product is distrubuted, I want to update the epicor system so that accounting go continue to do there job. Is that such a program or vendor that will allow me to map my fields and those of EPICOR and in a way (sorta like a trigger) update the EPICOR accounting software.
I am not sure if I am explaning myself, but in simple terms, I just want to know if I create a database, would I be able to import my data to that of epicor in a cost effective way -- we are non-profit organization.