| Home | Free Articles for Your Site | Submit an Article | Advertise | Link to Us | Search | Contact Us |
This site is an archive of old articles

    SEARCH ARTICLES
    Custom Search


vertical line

Article Surfing Archive



Microsoft CRM Integration with Navision * overview for programmer - Articles Surfing

Microsoft Business Solutions CRM is very good budget alternative to Siebel and actually be-loved by Microsoft-oriented IT department system. Considering the fact that in many cases Microsoft CRM should somehow fit into and cooperate with existing legacy business applications, integration question maybe the first to place. It is probably good to mention that Microsoft Navision has its own CRM module (and Navision will probably have MS CRM Navision integration tool for MS CRM 2.0 * at this moment we do not know when). We would like to give you, software developer highlight on how you allow Navision data lookup from Microsoft CRM screens: Account (which is customer), contact, lead.

We suppose that Navision is installed with native C/SIDE database, because in the case of MS SQL Server this topic doesn*t make sense

Microsoft CRM web interface is built on .Net architecture and Microsoft CRM SDK is married with .Net. We suggest you to use Microsoft tools to connect to Navision database via ODBC.

  • Native C/SIDE Database. If Navision sits in C/SIDE database, then create ODBC linked server to Navision via C/ODBC

  • Configure web.config to enable Microsoft CRM customization

  • Configure isv.config to place the button or navigation bar on one of your MS CRM customizable forms: Lead, Account, Contact, etc.

  • Use MS CRM SDK sample code to come into Microsoft CRM Security realm

  • Create separate Database on the same SQL server where Microsoft CRM is hosted and place heterogeneous stored procedures or views * which will be pulling data from Navision C/SIDE linked server

  • Program ADO.Net calls and returned dataset processing in Visual Sudio.Net (preferably C#.Net, because Microsoft CRM SDK is C# oriented)

  • We probably should mention that isv.config buttons allow you to transfer GUID of the Contact, Lead or Account to your integrated web application

  • Crystal Reports caution * MS CRM has built-in Crystal Reports Enterprise, licensed for MS CRM data access only. So, if you like to integrate web Crystal report into your application * you should resolve licensing issue and check with Microsoft on purchasing full version of Crystal Enterprise. The other way is to separate your Crystal web application and MS CRM by placing them on separate hardware

  • Additional tip * in your stored procedure use this directive: DBCC TRACEON(8765), which allows working with the data results of variable length returned by C/ODBC driver

Good luck with integration! If you want us to do the job - give us a call 1-630-961-5918 or 1-866-528-0577! help@albaspectrum.com

Submitted by:

Andrew Karasev

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies * USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, Houston, Atlanta, Phoenix, New York, Los Angeles, San Francisco, San Diego, Miami, Denver, UK, Australia, Canada, Europe and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: akarasev@albaspectrum.com



        RELATED SITES






https://articlesurfing.org/computers_and_internet/microsoft_crm_integration_with_navision___overview_for_programmer.html

Copyright © 1995 - Photius Coutsoukis (All Rights Reserved).










ARTICLE CATEGORIES

Aging
Arts and Crafts
Auto and Trucks
Automotive
Business
Business and Finance
Cancer Survival
Career
Classifieds
Computers and Internet
Computers and Technology
Cooking
Culture
Education
Education #2
Entertainment
Etiquette
Family
Finances
Food and Drink
Food and Drink B
Gadgets and Gizmos
Gardening
Health
Hobbies
Home Improvement
Home Management
Humor
Internet
Jobs
Kids and Teens
Learning Languages
Leadership
Legal
Legal B
Marketing
Marketing B
Medical Business
Medicines and Remedies
Music and Movies
Online Business
Opinions
Parenting
Parenting B
Pets
Pets and Animals
Poetry
Politics
Politics and Government
Real Estate
Recreation
Recreation and Sports
Science
Self Help
Self Improvement
Short Stories
Site Promotion
Society
Sports
Travel and Leisure
Travel Part B
Web Development
Wellness, Fitness and Diet
World Affairs
Writing
Writing B