| |
| |
|
softwarecatch.com
|
|
|
|
Microsoft CRM Customization: Integration with Third Party SQL Application/Database
Microsoft CRM - Client Relationship Management package from Microsoft Business Solutions was initially designed to be customizable with Microsoft Visual Studio.Net and one of its programming languages - C#.Net or VB.Net. You can use ADO.Net, Web Service, Transact SQL scripting and stored procedures, deploy such SQL Server tools as Linked Server to all ODBC/OLEDB compliant database, including ORACLE, Sybase, Ingress, DB2, Unidata, Pervasive SQL, Ctree and even Lotus Notes/Domino. In this small article we would like to give you the clue on programming the integration with SQL third party Database. First - use Microsoft CRM SDK to initiate communication with Microsoft CRM, we have it in C#: String[] arr1 = coll.AllKeys; int loop1, loop2; for (loop1 = 0; loop1 0?1:arr1.Length); loop1++) { String[] arr2 = coll.GetValues(arr1[loop1]); for (loop2 = 0; loop2 < arr2.Length; loop2++) { strAccountId = arr2[loop2].Replace("}",null); strAccountId = strAccountId.Replace("{",null); } } if (Page.IsPostBack==false) { // Server should be set with the name of the platform Web server string Server = ConfigurationSettings.AppSettings["ServerName"]; // VirtualDirectory should be set with the name of the Microsoft // CRM Virtual Directory on the platform Web server string VirtualDirectory = "mscrmservices"; string strDir = "http://" + Server + "/" + VirtualDirectory + "/"; // BizUser proxy object Microsoft.CRM.Proxy.BizUser oBizUser = new Microsoft.CRM.Proxy.BizUser (); oBizUser.Credentials = System.Net.CredentialCache.DefaultCredentials; oBizUser.Url = strDir + "BizUser.srf"; // CRMAccount proxy object Microsoft.CRM.Proxy.CRMAccount account = new Microsoft.CRM.Proxy.CRMAccount (); account.Credentials = System.Net.CredentialCache.DefaultCredentials; account.Url = strDir + "CRMAccount.srf"; Then you use ADO.Net for calling stored procedure with parameters to do the integration job: try { string SQLStatement="ICS_UpdateAccountPrivate '"+ strAccountId +"' , '" + this.TextBoxWorkPerformed.Text + "' , "+doubleEncode(System.Double.Parse(this.TextBoxAnnualRevenue.Text))+" , "+ intEncode(System.Int32.Parse(this.TextBoxNumberOfEmployees.Text.Replace(",","")))+" , "+ doubleEncode(System.Double.Parse(this.TextBoxAverageGrowthRate.Text))+" , "+ "'"+this.DropDownListOwnership.SelectedItem.Text +"' , "+ intEncode(System.Int32.Parse(this.RadioButtonList.SelectedItem.Value))+" , "+ intEncode(System.Int32.Parse(this.TextBoxCredit.Text.Replace(",","")))+" , '"+ this.TextBoxComments.Text+"'"; System.Data.SqlClient.SqlConnection tmpConnection = new System.Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings["ConnectionStringICS"] ); About The Author Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Colorado, Oregon, Washington, Canada, UK, Australia and having locations in multiple states and internationally (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: 1-866-528-0577 andrewk@albaspectrum.com.
MORE RESOURCES:
Google News |
|
|
|
RELATED ARTICLES
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. Microsoft Great Plains international implementation - USA / Mexico - overview for consultant Microsoft Business Solutions Great Plains was purchased from Great Plains Software and Great Plains Software itself had strong international marketing plans and campaigns. If we look back to 1990th - we'll see that GPS had Multilanguage support and Great Plains Dynamics / Dynamics C/S+ was localized and translated into multiple languages, including Spanish. Microsoft Great Plains: Offshore Customization & Development - Overview for Consultant When you visit department stores and see that majority of the apparels are produced in other countries, not US - you probably do not worry about this fact. About 10 years ago, when Clinton's high tech era was at the inception - we saw the signs of high tech professionals inflow in the USA from overseas. Business Planning Software Once a business idea is selected, it is highly recommended that we sharpen the concept by a detailed planning process. The result of this step is a comprehensive business plan, with its major components being the marketing "mix," the strategic plan, operational and logistical structures, and the financial proposal. ERP Software Financing: the Future? - Overview for Company Owner In our case - we serve Microsoft Business Solutions ERP and CRM products: Microsoft Great Plains, Microsoft CRM, Navision, Microsoft RMS, as well as we do customization and integration to these products. We would like to share with you our experience with financing through Microsoft Financial Corporation, the entity handling software financing for Great Plains, CRM, Solomon, Navision & Axapta. What is Preventive Maintenance Software? Preventive Maintenance (PM) is defined as scheduled work done on a system to identify and fix any occurring issues before they become problems. The concept of preventive maintenance applies to many different industries. Cisco Certification: Introduction To ISDN, Part V The major reason I recommend getting your hands on real Cisco equipment rather than a simulator is that real Cisco routers give you the chance to practice and learn show and debug commands.The knowledge you acquire from debugs is invaluable. Microsoft Great Plains Integration Manager - Advanced Techniques Great Plains Integration Manager scripting and translation - overview for programmer, software developer, database administrator, IT specialistMicrosoft Business Solutions main middle market ERP application - Microsoft Great Plains has multiple integration options: MS SQL Scripting (stored procedures and views), ADO.Net programming, Microsoft SQL Server DTS packages. Builders Beware Which Type of Shop Can Rely On A Home Built System?Not all shops are at a disadvantage when it comes to building their own system. To determine which avenue a shop should take, owners must know what type of shops benefit from a self built solution and what type is better off purchasing one. Microsoft Great Plains FA: Fixed Assets - Overview For Consultant Great Plains Fixed Assets Management module is a robust tool that can help you manage your assets effectively. It integrates perfectly with other Great Plains modules like General Ledger, Purchase Order Processing, and Payables Management ensuring accuracy while reducing redundant data entry. SQL Administrator Skills Required to Support Microsoft Great Plains Microsoft Great Plains is becoming more and more popular and we see new purchases among midsize and large corporations, where, in our opinion, Microsoft SQL Server DB administrator position is a must. If you are database administrator and you are part of the decision making team, purchasing Microsoft Business Solutions Great Plains for your corporation, we would like to set your expectation on the level of SQL knowledge, skills and experience needed to support Microsoft Great Plains in-house? Data querying. Causes of ERP Failures ERP is the acronym of Enterprise Resource Planning. Multi-module ERP software integrates business activities across various functional departments, from product planning, parts purchasing, inventory control, product distribution, to order tracking. Crystal Reports For Microsoft RMS - Overview For Developer/Report Designer If you are software developer or database administrator - we would like to give you the clues on Crystal Report creation for Microsoft RMS Database: Microsoft SQL Server or MSDE - this means that you can deploy native SQL driver for connection or use ODBC for flexibility. Tables Structure - it is extremely self-explanatory: Customer, Transaction (invoices, returns, layaways and others), TransactionAmount, Cashier, Tender to give you examples Links - Usually master table has ID column and Transaction-related table links by [Entity]ID column: Transaction. Databases - How We Love to Hate Them! You've finally created databases that you can actually use to store and manipulate all your critical data. That's great news and quite an accomplishment. Microsoft Moves to Small Business Accounting/Retail Market - Stakes and Thoughts In this small article we will be looking at the new opportunities for Microsoft Small Business Server specialists, but rather look at the global business strategy and possible ways of future ERP modules standardizing and interoperability. This is important to get into consideration for midsize and large corporate business IT decision makers. IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business System or CRM: Lotus Notes Domino, Oracle, DB2There are multiple opinions on building your established large business IT system. Some companies prefer to be "Microsoft shop", others prefer to stick to Java world. Groupware and Version History: Collaboration Series #1 This article is the first of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware. Free Software - Powerful Alternatives to Budget-Busting Software When you buy a computer, it most likely comes with Microsoft Windows preinstalled. And when you need a word processor, spreadsheet, or other software, you probably buy it from a computer store. Microsoft Great Plains in Metal Distribution: Implementation & Customization - Consultant Overview Microsoft Business Solutions Great Plains serves to the wide spectrum of horizontal markets and could be also considered as generic ERP/MRP/Accounting platform for light and advanced customization to fit verticals. In this small article we describe distribution sector with the example from metal distribution - Dealer/broker of industrial nonferrous by-product scrap, de-tins and de-oils industrial by-product scrap and finished parts. MicroWorld Releases New Version of MailScan Ver. 4.5 - Antivirus and Content Security Software MicroWorld Technologies, Inc. the leading solutions provider in the area of Anti-virus and Content security, has announced the launch of its new version of MailScan Ver.
|
|
Powered By: Free Work At Home Business Opportunity! |
| © 2006 |
