Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explorer, Microsoft Great Plains as backend, etc.
Microsoft CRM SDK - this is software development kit with C# and partly VB.
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. Microsoft CRM is new player on the CRM software market. Net, Crystal Reports and Microsoft CRM SDK developer.
PHP (PHP Hypertext Preprocessor) is an open source server-side scripting language that is particularly suited for web development and can be used to generate dynamic web content. PHP scripts are embedded within web pages along with HTML, similar to other web scripting languages such as Microsoft's ASP or Sun Microsystems's JSP. PHP lets you insert instructions into your Web pages that your Web server software (be it Apache, Personal Web Server, or whatever) will execute before sending those pages to a browser that requests them. PHP is one of the fastest growing server side scripting languages around and you need to add it to your current arsenal of Perl, ASP, JSP, JavaScript, VBScript, Java. Daffodil DB is a J2EE-certified, SQL-99 and JDBC standards compliant Java RDBMS.
PL/SQL stored procedures development and testing, plus integration with major database platforms - Oracle, Sybase, MS SQL Server etc. Cross-platform (works under main Unix/Linux platforms and in Microsoft Windows environment) friendly development environment with high level of integration and third party plug-ins switching on. Deployment capability for all major application servers - Oracle Application Server, IBM WebSphere, BEA WebLogic, JBoss. You can get production and developer preview for Oracle JDeveloper 10G here http. The new features of this new version will be completely redesigned user interface, additional re-factoring capabilities, advanced UML diagrams features, web services simplified creation, support for the web application building on Java Server Faces base, complete support for J2EE 1.
Database platform independence - initially Great Plains used Ctree (available for both PC and Mac) and Btrieve, later on with Microsoft SQL Server 6. Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures. If you need cross dictionaries customization - consider using SQL Stored Procs for crossing dictionary borders and pulling data/making changes in the other dictionary. Engine, supporting graphical interface, which is computer platform independent - if you remember those days - the main competition was between Macintosh and Microsoft Windows. 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.
SQL Linked Servers - you can do direct SQL queries to other ODBC compliant platform via SQL Linked Server (including Microsoft Access) - you may need to familiarize yourself with OPENROWSET command in Transact SQL. EXE) and Great Plains Standard on MSDE or MS SQL Server. Microsoft Business Solutions stakes on Microsoft Great Plains as main Accounting/ERP application for US market. Net, Crystal Reports and Microsoft CRM SDK developer.
Data Transformation Services (DTS) - Good tool for importing your third party data into staging tables in GP - then you can pull them in using either stored procs of Integration Manager.
It sits in Microsoft SQL Server and uses all the spectrum of Microsoft technologies. However you can integrate Microsoft CRM with heterogeneous databases, such as Oracle, DB2, Lotus Notes Domino, Sybase, Pervasive SQL or Ctree/Faircomm. Microsoft CRM proved its market strength and ability to automate large publicly traded corporation. Microsoft CRM has web and MS Outlook clients and so by its nature it is web application. He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C.
Well, complication of computer networking and its security, plus the fact that SQL is now standard for the database platform (Microsoft SQL Server, Oracle, DB2, etc. So many times we were spinning our wheels in trying to test new custom business logic, when, say Windows or MS SQL Server security was restricting us to do the actions we needed. We saw numerous examples, when client purchases Microsoft CRM licenses from nation-wide distributor, and then is trying to find somebody to implement the system. When you decide on somebody to implement the system, you need from this moment on to trust him and let him have high security access to the ERP hosting server. As seeing large number of implementations - in our case these are Microsoft Business Solutions Products.
Jet Reports- Jet Reports is a complete reporting package utilizing Microsoft Excel. C/ODBC and C/FRONT - Both C/ODBC and C/FRONT enable you to easily use information from Navision in familiar programs such as Microsoft Word and Microsoft Excel. Using a familiar Microsoft Outlook ® - style interface, Business Analytics presents this information to your desk top where easy to use analytical tools allow you to carry out targeted analysis that is tailored by you, for you.
C/SIDE (Client/Server Integrated Development Environment) - The core of Navision is the C/SIDE. Navision Developer's Toolkit - The Navision Developer's Toolkit enables your Microsoft Certified Business Solutions Partner to upgrade your Navision solution to the latest version.
The basic source of knowledge was this article Developing Managed Event Sinks/Hooks for Exchange Server Store using C# by Logu Krishnan, published to the address http. The handler creates activity record in Microsoft CRM and then removes the message in the Exchange database before the commitment. ProcessMessage(pEventInfo, bstrURLItem, IFlags). The purpose of one of our projects was MS Exchange handler for processing incoming email. We utilized Synchronous Events and created the handler, which fires on OnSyncSave event.
Lotus is extremely flexible and you can program your own CRM or purchase CRM for Lotus, however Microsoft CRM has Microsoft SQL Server database and very simple Sales automation module. One of the popular requirements is the synchronization of Microsoft CRM Activities. The second reason is possible IT strategy to balance multiple platforms to avoid over-dependence on one vendor (such as Microsoft. You can use Lotus Workflow and then upon the completion it can transfer control to Microsoft CRM. There might be also licensing issue - if corporation has several hundred Lotus licenses - it doesn't want to lose them and pay for 200 Microsoft CRM users.
The other way is to have server in Mexico and have relatively inexpensive Microsoft Great Plains data be consolidated with Oracle, SAP, PeopleSoft based system in the USA. Some functionality could be realized through Microsoft Business Portal - which is web-based application. Microsoft Business Solutions Great Plains was purchased from Great Plains Software and Great Plains Software itself had strong international marketing plans and campaigns. Consider Windows 2003 Terminal server licenses. Is supported and you can have both English version in the US and Spanish version in Mexico working of the same Great Plains environment.
If you are MCSE+I - CRM will recruit all your MS Exchange, Active Directory, MS SQL Server, Windows domain security, Windows 2003 Server, Web publishing and HTML knowledge and experience. Microsoft CRM is for MCSE / Microsoft oriented IT departments - Microsoft CRM would be be-loved system for IT specialists. Microsoft CRM has the highest ever rate of successful implementations, because it is not a CRM, but rather popularized version of it - it just does the job - as cheap and reliable car. Microsoft CRM is CRM answer from Microsoft Business Solutions. We know the examples when 5 employees companies make a decision to implement and have surprising success in Microsoft CRM implementation.
DECS technology allows direct connection with DB2, Oracle, MS SQL Server, Sybase sources, and external sources by ODBC and OLE technologies. This method is available only for simple Lotus Domino databases, as them are not relation databases and SQL is not good to work with (problems with multiple fields values and different fields set in documents). If an HTTP task is started on Domino server, then from external applications is available sending/receiving data by of the same name protocol. This approach is better then use NotesSQL ® ODBC-driver, but can not be use with complex databases. Using of this technology is in the Microsoft platforms frame.
When Microsoft CRM send email from Account, Contact, Lead - connector takes control over and sends email through Lotus Domino server. When Lotus Domino server receives email - Java Agent side of the connector triggers checking with MS CRM if addressor email matches with any Contact, Lead or Account email. We found that matching is better approach and we have Microsoft CRM Exchange advanced connector - which works with matching, without standard GUID mechanism. Lotus could work in multiple hardware & OS platforms, such as Windows Server, AS/400, etc. Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being two groupware products from competing software development leaders, however could coexist within one organization computer network and even work together in collaboration.
Net, MS SQL Server, Active Directory, BizTalk (integration with Great Plains), C# and VB. Microsoft CRM is the only CRM option from Microsoft (in Navision you have Navision CRM module option - so this is an exception) and please, feel free to choose Microsoft CRM if you would like to try CRM from Microsoft. In our opinion Microsoft bought this product in order to get European market share, especially continental Europe. Then, Microsoft Business Solutions realized that Navision is a good fit for countries with tight government regulation. In all the other cases - you should try Microsoft RMS.
|
|