Sunday, June 14, 2009

Microsoft CRM Custom Design & Development

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

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.

  • 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.
  • 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
  • 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.
  • 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.
  • 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.
  • 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
  • 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 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, based in Chicago, Boston, San Francisco, Seattle, Minneapolis, Los Angeles, Houston, Dallas, Atlanta, Miami, Canada, UK, Australia 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.


    MORE RESOURCES:
    Microsoft to unveil new mobile services and software - MarketWatch


    Computing News
    Microsoft to unveil new mobile services and software
    MarketWatch - 2 hours ago
    The services will be announced at the 3GSM World Congress in Barcelona, where Microsoft will show off Windows Mobile 6, a new version of its software for ...
    Microsoft unveils new mobile software The Age
    Microsoft Reveals New Windows Mobile 6 Smartphone Software ... FinanzNachrichten.de
    Microsoft reveals new Windows Mobile 6 Smartphone software Wireless Design & Development Asia
    Prdomain Business Register (press release) - I4U
    all 124 news articles

    IBM Wants to Wipe Out Microsoft’s Software from Business Desktops - Playfuls.com


    Playfuls.com
    IBM Wants to Wipe Out Microsoft’s Software from Business Desktops
    Playfuls.com, Romania - 1 hour ago
    Yesterday, IT giant IBM unveiled its plans to reduce costs of managing Apple or Linux desktops, by offering a new open source software system for business ...
    IBM software makes mixed networks viable Macworld UK
    IBM aims to lower cost of using Linux, Apple PCs Playfuls.com
    IBM aims to lower cost of using Linux, Apple PCs Expressindia.com
    all 22 news articles

    Atex, the World's Leading Developer of Software Solutions for the ... - Canada NewsWire (press release)

    Atex, the World's Leading Developer of Software Solutions for the ...
    Canada NewsWire (press release), Canada - 5 hours ago
    12 /CNW/ - Atex (www.atex.com), the world's leading developer of software solutions for the media industry, has today announced that it has acquired Mactive ...
    Atex, the World's Leading Developer of Software Solutions for the ... Yahoo! News (press release)
    Atex, the World's Leading Developer of Software Solutions for the ... PR Newswire (press release)
    all 10 news articles

    New models replacing 'box' software delivery - The News Journal

    New models replacing 'box' software delivery
    The News Journal, DE - 1 hour ago
    30 launch of the consumer versions of Microsoft's flagship software may be among the last of its kind -- a product sold for a flat fee in a shrink-wrapped ...

    Japan's Renesas to work with Nokia on software for cell phones ... - Forbes

    Japan's Renesas to work with Nokia on software for cell phones ...
    Forbes, NY - 9 hours ago
    The Finnish firm will make its S60 platform software compatible with the Japanese semiconductor manufacturer's SH-Mobile system chips, which are currently ...
    Nokia Builds on Vision of Mobilizing the Internet to Transform ... Yahoo! News (press release)
    all 14 news articles

    Global Demand for New Leadership & Organizational Development ... - PR Web (press release)

    Global Demand for New Leadership & Organizational Development ...
    PR Web (press release), WA - 4 hours ago
    The animation software combines the GROW coaching process with four animated video movies. Instead of traditional coaching techniques the process combines ...

    Cranes Software net rises 67.94% in Dec`06 qtr - Myiris.com

    Cranes Software net rises 67.94% in Dec`06 qtr
    Myiris.com, India - 1 hour ago
    Cranes Software (Q, N,C,F)* International has reported a rise of 67.94% in net profits to Rs 264.61 million for the quarter ended December 2006 as compared ...
    Cranes Software to utilise Rs 2172.60 mn Myiris.com
    all 2 news articles

    CSR Launches Superior GPS Software for Seamless Mobile Positioning ... - DMN Newswire (press release)

    CSR Launches Superior GPS Software for Seamless Mobile Positioning ...
    DMN Newswire (press release), CA - 2 hours ago
    CSR's GPS solution is software-based and requires no further hardware beyond a RF front-end, hence the E5000 requires less than half the power and ...

    • Planner's software helps cut big events down to size - Indianapolis Star

    • Planner's software helps cut big events down to size
    Indianapolis Star, IN - 4 hours ago
    The Registration System is Web-based software that helps corporations and specialized event-planning firms coordinate tours and events of all sizes. ...

    Software industry grows by 30% - Nhan Dan

    Software industry grows by 30%
    Nhan Dan, Vietnam - 3 hours ago
    The software industry in 2006 generated US $300 million in revenue, up 30% year-on-year, in which exports accounted for US $90 million , reported the ...


    RELATED ARTICLES
    Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights
    Microsoft Great Plains is one of the Microsoft Business Solutions family ERP products: Great Plains, Navision, Axapta, Solomon, Small Business Manager. MBS also has Microsoft CRM - Client Relation Management software and Microsoft Retail Management System (Microsoft RMS)Microsoft Great Plains 8.
    Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware
    Spyware and malware are large problems for Internet users today and can be both annoying and a real threat to you and your computer. There exist a number of different spy and malware of which some are relatively friendly and only spies on your surfing habits, while others like the Trojans can be used to corrupt your hard drive or steal your usernames and passwords.
    How to Choose the Right Accounting Software for Your Business
    With any good luck and a good amount of hard work, you're having the same problem many business owners today are facing. Your business is growing rapidly and you're having problems controlling your finances.
    How to Choose the BEST Charting Software
    I suggest that you do not spend a lot of money on charting software as most perform very similar functions. Often the price is inflated to capitalize on the mentality that expensive is better.
    C++ Tutorial 1, Introduction to C++
    Introduction to C++Why Learn C++?C++ may at first seem like a boring, confusing programming language that you can only program command prompt applications with. Well, that is what it is like in the [b]begining[/b].
    Microsoft Great Plains Implementation in Russia - Overview for Consultant
    Microsoft Business Solutions Great Plains is very popular ERP platform in the USA, Canada (including French speaking Quebec/Montreal), U.K.
    Can You Calculate Complex Financial Calculations?
    Are you a whiz at calculating financial information? Not the easy personal stuff, like figuring out your monthly mortgage based on a fixed interest rate for x number of years, or how much money you have available each month after all your bills are paid. (You can probably use your fingers to figure that one out!)But the hard stuff, you know, the things you need to know when you're running a small business.
    Corporate ERP: Standard vs. Rich functionality - Microsoft Great Plains
    Traditionally we were considering functionally rich systems, such as SAP, Oracle Financials, PeopleSoft, JDEdwards as the fit for large publicly traded corporation. There might be multiple opinions for the future corporate ERP/MRP systems.
    Linux vs Windows Operating Systems
    With so many Microsoft Windows related viruses, errors, and other software problems, many average computer users are looking at alternative operating system platforms, such as Linux. It is important that users, frustrated with Windows, don't simply install a version of Llinux without knowing what they are in for.
    Microsoft Great Plains Partner Selection: Overview
    Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business Solutions ERP applications, serving to the whole spectrum of vertical and horizontal markets. Assuming that you already have one of these systems installed and implemented we would like to give you - IT director, Database Administrator, Programmer, Software Developer, Controller your options in supporting/upgrading Microsoft Great Plains for your companyIt is always good idea to install everything on your own - however Great Plains requires combination of computer networking, some programming, good accounting/distribution/logistics/reporting background - so it is not a surprise that Microsoft Business Solutions requires their customers to have specially assigner Microsoft Great Plains Partner/VAR/Reseller to serve the account.
    Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management
    Let's first look at your ERP system selection (without Retail Solution). Your options are:Microsoft Great Plains.
    The XP Firewall Isnt Enough
    You might think you don't need a firewall because windows XP has one built in, but read on for a plain-english explanation why this isn't enough. Before broadband and cable connections were common most people didn't need a personal firewall because they weren't connected to the Internet for extended periods of time.
    Cisco Certification: Introduction To ISDN, Part III
    Configuring PPP PAP AuthenticationNow we know how the ISDN link comes up (interesting traffic), and some scenarios that might cause the link to stay up, we need to look at ISDN authentication schemes. The two methods Cisco certification candidates must be familiar with are PAP and CHAP.
    Great Plains Dexterity History and Programming Overview
    As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into Microsoft Great Plains and Microsoft Business Solutions is in process of merging all its accounting applications: Great Plains, Solomon, Navision and Axapta into somewhat granular: Microsoft Financials, Microsoft HR, Microsoft Distributions, Microsoft Project Accounting, etc. So the original design of Great Plains should be deemphasized.
    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. In this small article we will try to give you highlights on how to implement Microsoft Business Solutions CRM for worldwide operations with restricted internet connection.
    Review on QuarkXpress 6.0
    After almost two decades of existence, Quark has become the basic building block of any print designer's toolkit. It has deservedly gained a reputation for reliable printing, offering consistent and dependable output that prevents costly mistakes.
    Microsoft CRM Customization - Processing In/Out-Going Email Messages
    We would like to give you several situations, when you may need custom development and programming to improve Microsoft CRM functionality. This overview is for programmer, software developer, IT specialist, database administrator.
    The End of Spyware?
    The US House of Representatives has recently passed the "Spy Act" - or to give it its full title - the Securely Protect Yourself Against Cyber Trespass Act. This aims to prevent software companies from installing spyware on users PCs without their knowledge, and anyone found guilty of breaching the act faces a fine of up to $3 million.
    Spyware, Adware, etc. -- Terms and Common Sense
    When reading an article where some term is used often, it is useful to make sure the author of the article and you mean the same. Not surprisingly for those who still remember English lessons at school, every noun ending with "ware" is a mixture of objects having something in common--usually used for similar purposes.
    How Do I Get Rid Of That Darn Spyware?
    Ad-Aware and Spybot are probably the two most well known antispyware solutions. However, they frequently fail to catch the more crafty spyware.


  • No comments: