Importing data to EPICOR accounting database

Posted on 2007-08-09
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
    LVL 11

    Accepted Solution

    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

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

    Expert Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Creating and Managing Databases with phpMyAdmin in cPanel.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now