[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Importing data to EPICOR accounting database

Posted on 2007-08-09
Medium Priority
Last Modified: 2012-06-22
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.

Question by:epicazo
  • 2
LVL 11

Accepted Solution

Swindle earned 1000 total points
ID: 19663552
It looks to me like Epicor built their product with this kind of situation in mind.  They have an import tool that they claim will do it "seamlessly"


Author Comment

ID: 19666228
do you know if biztalk is a similar product?
LVL 11

Expert Comment

ID: 19666301
I honestly couldn't tell you because I"m not familiar with Epicor, I just poked around their site to find that article.  I can tell you however that in almost every situation I've come across where a 3rd party software company sells an import tool, they expect you to use theirs and won't support you if you do anything else.

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question