ERP and domino - lotus notes client /Browser client

Hi there,

If all my business data resides on an ERP system, what could be the best way/methods to pull this data out so that It can be displayed and manipulated in the lotus notes client? Or domino web client?

I hope that my question is not so confusing.

Thank you in advance.
varvouraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sjef BosmanGroupware ConsultantCommented:
ERP? There are at least 10 major ERP systems in the world, so which one? There is a SAP/3 connector for DECS, and there must be others e.g. for JDE. Usually, one Google-search with the word DECS and some other keywords for your search will be enough. If you need two-way replication of data, you'll need LEI (formerly called NotesPump).
0
SysExpertCommented:
LEI basic comes with the DOmino Enterprose Server version, but specialized connectors for SAP and other ERP systems can simplify connectivity.

FOr more info check the IBM site. Search LEI

you might want to start here

http://www-128.ibm.com/developerworks/lotus/community/

I hope this helps !

0
varvouraAuthor Commented:
Hi there,

I heard from a colleague that LEI is quite problematic? So problematic that they had to give up using it. Is this true?
0
Sjef BosmanGroupware ConsultantCommented:
Whether it is true that they gave up I can't possible tell... ;)

LEI isn't easy, but the whole subject is very difficult. In that respect, LEI is dead easy. The problem is that not every database is LEI-able, it depends on size, structure, complexity etc.. If that's the case, you might have to use ODBC, or other means of data transfer. There are many Connectors available.

From the Designer Help db:
LEI and DECS provides the following standard Lotus Connectors for the associated data sources:
DB2
Notes
File System (not used with Virtual Documents or Virtual Agents Activities)
ODBC
Oracle 7
Oracle 8
OLE DB
Sybase
Text (not used with Advanced RealTime or DECS Activities)
Additional Lotus Connectors are available and can be purchased separately.

For more information about Lotus Connectors, visit http://www.lotus.com/ei.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.