---------Integration: ODBC to ERP (AS/400)-------- RRS feed

  • Question


    Integration: ODBC to ERP (AS/400)

    Hi all,
    Can anyone recommend best practices of integrating CRM Server
    with ODBC DSN to AS/400 using client Access?

    There is some mystry about what the CRM server is capable to do
    in terms of communicating with a non-Microsoft ERP...

    Does an ODBC DSN offer a smooth entrance to and from CRM Server?

    What is the best way to have the two Servers (CRM & AS/400) synchronized?

    We considered a C# "server background" program that will communicate between the two
    servers so when a write is done on the CRM server a flag will be '1' and then
    the ODBC that awaits the flag will commit the write on the  AS/400 and vice versa.

    Is there any metodology that can replace this communicating background program so the
    write operations are done automatically between the CRM server to the AS/400 server and vice versa?

    Based on the account number and GUID of the account(Customer) in the CRM -
    how to integrate the CRM to enter the ERP given an Account or GUID number?
    I don't think there is a need to import data from Server to Server, but
    only to have a "gate" based on a a customer identifier, so the user moves
    from CRM to ERP and vice versa as if these two software were one.

    Thank you very much

    Monday, June 2, 2008 10:23 AM

All replies

  • I did one integration through ODBC, the best practices I read is to use the own written webservices which will use ms crm webservices.


    That user written webservices should be use for odbc connection to other database  or system.







    Monday, June 2, 2008 4:37 PM