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

x
?
Solved

Importing data to EPICOR accounting database

Posted on 2007-08-09
3
Medium Priority
?
640 Views
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.

0
Comment
Question by:epicazo
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
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"

http://www.epicor.com/www/products/enterprise/financials/im.htm
0
 

Author Comment

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

Expert Comment

by:Swindle
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.
0

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