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 connected 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 connected 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 not have long-lasting connection to your MS CRM web server. Instead, you use Microsoft CRM Outlook client, where your customization should be incorporated and included into MS CRM Outlook client replication. In MS CRM 3.0 you can unprotected to Outlook replication virtually any custom MS CRM object/table
o MS CRM SDK Programming. MS CRM Software Development Kit is a tool for specialized MS CRM developer. You need intermediate or progressive level of .Net C# or VB programming experience, server side plus excellent XML and XML Web sets
o Heterogeneous Integrations. MS CRM may integrate interfacing pages to such popular in Brazil ERP as Oracle EBusiness
Suite/Financials/Applications, Microsiga, Navision (C/SIDE and MS SQL Server databases), MS Axapta/Dynamics AX, SAP B1 Business One, mySAP/R/3 to name a few.