Post reply

How to get Real Time updates from ERP

  • November 17, 2006 at 7:19 am

    #95010

    I am starting a project where order data will be coming from an ERP system

    This data will be placed on a SQL 2000 Server for a intranet site to view current order data. Data will be added to the order information on the intranet and passed back to the ERP system

    The format of the data coming from the ERP system or going to the ERP system has not been determined. csv, txt, xml? Direct connection to ERP is not an option.

    The request to make this as real-time as possible has been made.(Updates occuring < 1 minute)

    I am looking for the right direction to go. I have read MERGER REPLICATION and ANALYSIS SERVER, DAEMONS, LISTENERS

    Recommendations are appreciated.

    Thanks,

    Tom

  • November 17, 2006 at 8:10 am

    #672623

    Your description is not clear enough. In order to determine which approach to use, we need to know what kind of data (partial or all) you would like to transfer.

    For all, you may use log shipping;

    For partial, you may use replicaiton.

  • November 17, 2006 at 8:34 am

    #672637

    The applicaiton will bascially mirror the ERP system, since an ODBC connection directly to ERP is no an option at this point.

    So, as records are added/deleted/update in the ERP system a daemon will send a file to a directory. (This is how the client wants it done) Pending  the location of the file, I need to added/deleted/update data in the SQL Server.  I could recieve 1 file with 1 record or X files with X records.  

    I can recieve the file in almost any format I need.

    Hopefully this clears things up abit.

    I appreciate your time to reply to my post.

    Thanks you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply