Eric Lehti
VIP Member
Seeking to replace the following with a great solution. Any recommendations?
World A7.3 Cume 9 - Manufacturing, Distribution and Financials. We also developed a custom CRM (customer relationship management) system written by contract Java programmers with web browser interface. 80 percent of CRM data resides on Windows SQL server database that is populated from JDE data files (e.g. F42119 and others). Why? Developer did not feel comfortable reading the JDE data files directly so he cloned JDE sales history to SQL database.
20 percent of CRM data resides on System i in DB2 tables (customer master, etc.) On a daily basis, our JDE address book refreshes Address Book information as needed. And because Java developer did not realize the flexibility and configurability of the JDE Address Book, he unnecessarily created numerous tag-along tables of Customer-specific data that actually should be stored in the JDE Address Book category codes, etc.
We seek a solution, hopefully from Oracle and its business partners, to continue with JDE software, either World A9.1 or EnterpriseOne, and link to an excellent CRM system that is accessible via web browser. (We could, of course, hire a Java programmer and continue with our current data model).
And because I am an RPG programmer on System i, I have a vested interest in recommending World software A9.1, and complement A9.1 with something CRM-ish that is browser-accessible.
What do you recommend?
Earnestly, EricL 918-879-6036
World A7.3 Cume 9 - Manufacturing, Distribution and Financials. We also developed a custom CRM (customer relationship management) system written by contract Java programmers with web browser interface. 80 percent of CRM data resides on Windows SQL server database that is populated from JDE data files (e.g. F42119 and others). Why? Developer did not feel comfortable reading the JDE data files directly so he cloned JDE sales history to SQL database.
20 percent of CRM data resides on System i in DB2 tables (customer master, etc.) On a daily basis, our JDE address book refreshes Address Book information as needed. And because Java developer did not realize the flexibility and configurability of the JDE Address Book, he unnecessarily created numerous tag-along tables of Customer-specific data that actually should be stored in the JDE Address Book category codes, etc.
We seek a solution, hopefully from Oracle and its business partners, to continue with JDE software, either World A9.1 or EnterpriseOne, and link to an excellent CRM system that is accessible via web browser. (We could, of course, hire a Java programmer and continue with our current data model).
And because I am an RPG programmer on System i, I have a vested interest in recommending World software A9.1, and complement A9.1 with something CRM-ish that is browser-accessible.
What do you recommend?
Earnestly, EricL 918-879-6036