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

• Monday, June 02, 2008 10:23 AM

   

   
  

  0

   

  *****************************************
  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
  --------------------------------

  • Reply
  • Quote