Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

IBM Lotus Notes with Domino email server is traditional document workflow management solution for large corporate business, where you need audit trail on approval cycle and decision making. Microsoft Business Solutions CRM is very cost efficient solution to automate sales process. It might be surprising, but we see good strata of clients who are willing to deploy and integrate both systems: MS CRM and Lotus Domino. In our opinion these clients are balancing ERP platform risks and trying to protect and deploy investments into Lotus licenses, while deploying new and already leading CRM solution ? Microsoft CRM. In this small article we'll give you the integration example ? European division of one of the well known machinery manufacturer dealership network.

? Custom Lotus Database. In our case client had custom database, which was designed back in the beginning of 1990th. Some dealers had Lotus Notes Domino 4.0 and some of them had 6.0 and 6.5. Technical excurse ? in Lotus Notes Domino 6.0 you can use Java 2 agents, and it seems to be platform independent (Microsoft Windows Server, IBM AS/400). To synch all the dealerships ? the decision was made to upgrade across the network to Lotus Notes Domino 6.0 (to be a bit conservative)

? Domino Messaging. Obviously you have to have just one email server assigned to your url domain, and as traditionally Lotus Domino was the email server ? the replacement with Microsoft Exchange 2003 (which is natural choice if you purchase Microsoft CRM) was not an option. With Alba Spectrum Technologies MS CMR Lotus Notes Domino connector you can switch email messaging to Lotus Domino

? Lotus & MS CRM events synchronization. IBM and Microsoft software designers designed CRM & Lotus events differently. Second phase of the project implementation will synchronize appointments, calendar events, etc. between Lotus and MS CRM.

? MS CRM ODBC lookups to Lotus database. As the second phase we plan to implement lookups from MS CRM Account to cases with custom fields and Lotus notes lookup tab. This tab will be realized as web .net application, integrated into MS CRM web interface. This web application will have machine serial number, warranty & service info. As you probably know in MS CRM 3.0 you can deploy custom table in link it to MS CRM object as one-to-many. The most important is that it will be synchronized by MS Outlook and will allow you as a salesperson to work offline.

You can always have us help you with MS CRM customization, implementation, support & MS CRM SDK data conversion. Give us a call: 866.528.0577 or 1.630.961.598, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com ) - Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.

In The News:


pen paper and inkwell


cat break through


Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

RFID: Strengthen the Position for SAP; United States

SAP Inc., a global leader in client/server enterprise application software... Read More

Microsoft CRM in Latin America: Implementation, Customization, Support ? Overview for Consultant

Microsoft Business Solutions CRM is present several years on the... Read More

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

Looks like Microsoft Great Plains becomes more... Read More

What is Software Piracy?

There are several kinds of software piracy. The bottom line... Read More

Four Desktop Tools To Drastically Increase Your Productivity

Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More

Great Plains Dexterity Programming ? Overview For Developer

Looks like Microsoft Great Plains becomes more and more popular,... Read More

COSMIC: A Small Improvement on the Symons Method

The COSMIC FP (function point) software quality metric, is no... Read More

Examining the Substance of Studio MX

To all web designers out there, this article is for... Read More

Anti-Spyware Protection ? Holes in the Shining Armor

Looking at all the ads which promise to get rid... Read More

Microsoft Great Plains Customization: Project Organization ? International Business Example

Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

Microsoft Great Plains: Customization Upgrade & Recovery ? Visual Studio VB 6.0

Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

Who Is Minding Your Sensitive Data?

Stealing company information used to be the specialty of spies... Read More

Microsoft CRM Customization: Integration with Third Party SQL Application/Database

Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More

HelpDesk & Asset Management Software - Choosing The Right One

If you are to buy a HelpDesk & Asset Management... Read More

Beware of Spyware

One day, you suddenly realize that your computer started to... Read More

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Groupware Finds Home in American Business: Collaboration Tool Analysis

What is Groupware?Have you ever had to manage document collaboration... Read More

ERP Remote Support: Microsoft Great Plains Analysis ? Pluses & Minuses

Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More

Partitioning, Formatting and Reinstalling in Windows 98

Formatting and reinstalling windows 98 is very easy if you... Read More

Programming Environments And The Software Production Process

Introduction: The creating of a computer program involves a number... Read More

Four Easy Ways To Prevent Spyware

How would you like to prevent spyware and adware from... Read More

Performance Tuning of a Daffodil DB / One$DB -JDBC Application

This article illustrates the best practices to improve the performance... Read More

How to Make Attractive and Effective PowerPoint Presentations

Microsoft PowerPoint has dramatically changed the way in which academic... Read More

Can You Calculate Complex Financial Calculations?

Are you a whiz at calculating financial information? Not the... Read More

Software Engineering: An Introduction

Software Engineering is the Systematic Approach for analysis design implementation... Read More

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

How to Make Own CMS

Every day millions of new web documents emerge on the... Read More

Microsoft Great Plains: If You are Orphan Client ? What to Do and FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More

Spyware: What It Is and How to Combat It

Spyware is software or hardware installed on a computer without... Read More

eConnect: eCommerce Development for Microsoft Great Plains

Microsoft Business Solutions Great Plains has several options to enable... Read More