Brazil: Microsoft CRM Integration Scenarios
Microsoft Dynamics CRM 3.0 should be considered as very flexible, programmable and customizable CRM application, really it is a heaven for Microsoft .Net and SQL developers. In this small article we will give you highlights on the integration techniques. Special credits should be given Microsoft SQL Server cross-platform integration options, such as Linked Server. o Scenario. Your company has good-old-days Oracle-based business management system, such as cargo tracking in transportation industry. Now you want your sales people to be moved to MS CRM and from MS CRM you need the lookup screen to shipment tracking o Technique. You create linked server to Oracle database from your MS SQL Server, hosting Microsoft Dynamics CRM. Then you create distributed SQL query and insert it in your MS CRM SDK custom form. You integrate this custom form as MS CRM tab or menu for one of your MS CRM objects: Order, Quote, Invoice o Working Off-line. When your sales people are traveling, they can n...