Microsoft Business Solutions CRM

review prepared by Andrew Karasev

1-630-961-5918 or 1-866-528-0577 help@albaspectrum.com

Microsoft CRM is new player on the CRM software market.  The whole conception behind CRM seems to be different.  In case of traditional CRM software (Siebel, Oracle) - the application was designed with platform independence in mind.  Microsoft CRM is dedicated to Microsoft technology and so deploys all the Microsoft tools: Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explorer, Microsoft Great Plains as backend, etc.

If you are software developer, database administrator or web designer who is asked: how do we customize Microsoft CRM – we are giving you directions in this article.

1. Microsoft CRM SDK – this is software development kit with C# and partly VB.net code samples – it is supported by Microsoft Business Solutions technical support.  It is based on web service calls, if you are C# .NET developer – you are excellently positioned to do this type of customizations.  This is the preferred modification scenario and this should be easily upgradeable customization.  VB.Net examples will be available soon.
2. Legacy SQL Data integration.  This is also easy and safe.  If you have SQL database, sitting on the same or linked SQL Server – you can create ASPX .Net application and simply integrate it into CRM.  You can place it on the navigation bar or menu in isv.config – please refer to MS CRM SDK
3. Legacy ASP integration – this is somewhat more sophisticated.  You have to deploy HTTP handler to be a middle party between CRM which is .Net based and ASP which is legacy IIS.  The trick is – you have to have INI file with security settings to penetrate into MS CRM with proper credentials, calling web service.
4. Microsoft Exchange Programming.  Microsoft CRM has Exchange connector – which moves CRM incoming email to MS if it has GUID in its subject.  You can alter this logic (for instance - move email to CRM if it doesn’t have GUID but it is from the sender who is contact or account in MS CRM).  Refer to MS Exchange SDK onsyncsave event handling.  Then simply apply some MS CRM SDK programming - you need some COM+ objects creation and VB programming experience.
5. Direct SQL touch – in #4 above I described you the scenario with MS Exchange handlers – this would be ideal world if MS CRM SDK does the job.  But – in real world this is not always true – you have to do direct flags correction in CRM database (like making Activity closed, moving email attachments/octet streams, etc).  This is not supported by MBS technical support – but you can rescue to this technique if you have to get job done.
6. MS CRM Customization tool –  this is rather end-user tool and we don’t describe it here – read the manual.  We’ve described above the options to use when this tool doesn’t do the job
7. Crystal Reports - feel free to create Crystal report - tables and views structure is self explanatory.  Try to avoid the temptation to create your own SQL view or stored procedure in MS CRM database, instead - create custom database and place your view and stored proc in it.

Happy implementing, customizing and modifying! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving clients in Chicago, Boston, San Francisco, Seattle, Minneapolis, Los Angeles, Houston, Dallas, Atlanta, Miami, Denver, New York, San Diego, Canada, Australia, Europe, Russia and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, VB/C#.Net, Crystal Reports and Microsoft CRM SDK developer.

Microsoft CRM messaging through Lotus Domino email server - balanced solution

Alba Spectrum Technologies

Microsoft Dynamics CRM integration & data conversion: ACT! Connector – Alba Spectrum

Using the ACT! Connector you will be able to integrate your legacy customer database into your Microsoft Dynamics CRM 1.2 or 3.0

Microsoft Dynamics CRM enhancements: Service Tickets – Alba Spectrum

This press release is dedicated to Online Ticket Trouble Tracking System (OTTTS)

Microsoft Dynamics CRM Customization or Third Party Product – overview for Consultant

With version 3.0 MS CRM will be more exposed to end-user tuning, software development, customizations.  Microsoft CRM SDK is becoming more sophisticated with reconsidering of post-call-out technology

Microsoft CRM Integration with Great Plains – overview for consultant

Initially this integration was created for Microsoft Great Plains 7.5 (now Microsoft Dynamics GP), later on Microsoft releasedthe patch

Microsoft CRM Implementation in São Paulo – notes for Consultant

Contrary to Navision, Axapta, Great Plains, Solomon – Microsoft CRM or Microsoft Dynamics CRM is CRM product, which Microsoft promotes in all the countries worldwide

Microsoft CRM Implementation: Employee Time & Billing – notes for Consultant

Assuming that you as business owner have IT department or even Microsoft savvy consultant – you are ready to launch employee timelog process right away

Microsoft Dynamics CRM 3.0 vs. 1.2 – notes for IT specialist

Based on our experience working with MS CRM 1.0, 1.2 and 3.0 – we will give you technical highlights

Microsoft CRM implementation – Sales & Service Modules for Consulting Business

Microsoft CRM 1.2 or Microsoft Dynamics CRM 3.0 could be considered as excellent platform for automating consulting business.  In this small article we will give you some directions

Microsoft Dynamics CRM 3.0 Implementation – leveraging MS Office & Outlook user experience

Microsoft Dynamics CRM 3.0, as well as Microsoft CRM 1.2 has so-called MS Outlook client snap-ins.  Also it uses MSDE installed on local machine (usually meaning laptop of the traveling MS CRM user)

Microsoft Dynamics CRM 3.0 Customization, Reporting Integration highlights

In this small article we would like to share our impression and as we see Microsoft messages to potential and existing customers with this new version of Microsoft CRM.

Microsoft Dynamics CRM customization & integration tools review

Microsoft Dynamics CRM is the new name for Microsoft Business Solutions CRM.  Other Microsoft ERP product were renamed as well: Microsoft Great Plains into Microsoft Dynamics GP, Microsoft Navision into Microsoft Dynamics NAV...

Microsoft Dynamics CRM Implementation - São Paulo ERP Market review

With the release of Microsoft CRM version 3.0 you can expect increased interest to its implementations, plus upgrades from earlier version 1.2 and 1.0.  Microsoft Dynamics CRM has integration tool, which allows integration with Microsoft Dynamics GP

Microsoft CRM Integration with Lotus Notes Domino: messaging connector – future directions

IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management) from now on can work in tandem.  Microsoft CRM Lotus Notes Domino connector from Alba Spectrum Technologies provides seamless messaging...

Microsoft CRM Integration with IBM Lotus Notes Domino – machinery dealership example

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

Microsoft CRM Lotus Notes Domino Connector FAQ

The need to synchronize MS CRM and Lotus Notes Domino databases is dictated by the ERP market and the connector is available.  In this small article we’ll answer on the frequently asked questions.

Microsoft CRM Data Import FAQ

If data import is critical and you have reasonable budget for the migration – you can appeal to MS CRM customization partner who specializes in the complex data import

Microsoft CRM USA Nationwide Remote Support

In this small article we’ll take a look at Microsoft CRM remote support, customization, reporting, implementation and integration.

Microsoft CRM for Corporate Business – working offline

If your company has regional and worldwide operations, you might already realized that it is very hard to get decent internet connection in your remote locations.

Microsoft Great Plains & CRM in Transportation & Logistics – overview

In previous article we described Microsoft Great Plains implementation for transportation & logistics company.  Having more material, we would like to share with you how you can leverage Microsoft Business Solutions products to automate your business. 

Microsoft CRM for Large Corporation – Security

Microsoft Business Solutions CRM proved to be reliable solution in the whole spectrum of industries and market niches: transportation & logistics, education, recruiting & placement, supply chain management, pharmaceutical..

Microsoft CRM Data Conversion FAQ

Even if it seems as a trivial task, we would suggest you to think about these possible scenarios: objects mapping between your legacy CRM: GoldMine, ACT, Siebel, Lotus Notes Domino

Microsoft CRM Implementation for Large Corporation – overview

Microsoft Business Solutions CRM is now approaching the phase of being mature product and the CRM solution you may consider for large publicly traded company.

IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM

Midsize business or non-profit organization should decide if one-vendor solution would be appropriate and the associated risk acceptable.  In our opinion, balancing the risk of one-vendor-approach is not economically feasible and should be avoided

Microsoft CRM implementation & customization: MS CRM Fax Gateway

Microsoft CRM at this moment doesn’t have advanced fax automation – you can register the fact of fax receiving or sending, but it is not sufficient for your daily work with your clients.

Microsoft CRM: data conversion – import from Act!

Best Software Act! Is very popular CRM for small and mid-size organization.   This system attracts business owner by its low price, plus system is very easy to use.

Microsoft CRM Integration & Customization: SharePoint Document Gateway

MS CRM is very close to document workflow automation, including Microsoft Office documents: Words, Excel, etc.  The document workflow was perfectly automated about 10 years ago in Lotus Notes Domino.

Microsoft CRM Conversation Gateway: VoIP - implementation & customization

Skype, AOL, MSN Messenger, ICQ

Microsoft CRM Implementation – fundamental CRM principles revision

Microsoft CRM is committed to Windows and Microsoft components: Exchange, Active Directory, SQL Server, etc (while traditional CRM applications, such as Siebel were biased toward multiplatform compatibility: Unix, Oracle, Windows, SQL Server)...

IT & ERP Consulting: Industry Trends

IT/ERP/MRP consulting industry is currently under the transformation.  This process is usually happening and comes in parallel with new economic recovery and change in the business paradigm.

Microsoft CRM Integration with Microsoft Office documents – overview for system integrator

There is market demand on the efficient integration of MS Office documents into Microsoft CRM.  Let’s take a look at the options

Implementing Microsoft CRM: setup and configuration – notes for IT specialist

We’ll try to analyze different needs and implementation scenarios attributed to specific industries and business types, based on our experience.

ERP Role in selling your mid-size business – Microsoft Great Plains and CRM example

If you own the mid-size business and actively work in it as executive manager or lead, say marketing, – you probably know exactly what needs to be done on the daily basis to keep it running. ..

Cross-Platform Custom Software Development & Integration – IT strategy for large corporation

Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta, MS RMS integration with UNIX/Java based platforms & non-Microsoft applications: Oracle, Lotus Notes/Domino, DBII, PeopleSoft, SAP

Corporate ERP of the next decade: Microsoft/Unix/Java – coexistence & harmony?

While in 1990^th we saw very fierce fight of Microsoft Windows and Apple Computer PowerMac for the workstations market, when two systems were practically not compatible and didn’t have plans to understand each other..

ERP Consulting 2010: future business model and alternatives

This might be attributable to the whole industry: Oracle Financials, Accpac, MAS500, PeopleSoft, SAP for mid-size business and Microsoft Navision, Axapta and Solomon.  We are talking about mid-size ERP systems implementation

ERP Remote Support: Microsoft Great Plains analysis – pluses & minuses

Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions Great Plains serves midsize and corporate clients as ERP system in the following countries and regions: USA, Canada, Mexico and Latin America...

ERP Implementation: Success Factors

As seeing large number of implementation – in our case these are Microsoft Business Solutions Products: Great Plains, MS CRM, Navision – we would like to give you our opinion on what should you consider to do to secure implementation success.

Lotus Notes Domino and Microsoft CRM Integration

Well, even if  the combination might look very unusual, we see the coexistence of these two systems, especially in large corporations, non-profit organizations.

ERP for Large Corporation – new selling strategy

Our opinion is based on our Microsoft Business Solutions Great Plains, Microsoft CRM sales and marketing campaign to large businesses in the following industries: Aerospace, Furniture, Beverages, Placement...