Software Information |
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: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Getting Technical Support Help Online Sometimes your PC will start acting strange for no apparent reason or a programwhich you use regularly will all of a sudden stop working as it should. Thiscan be a frustrating experience especially if you have no idea where to go forhelp. 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. Editing Your Photos Using Microsoft Picture It Publishing Platinum 2002 - A Great Dinosaur I started using PIP (Picture It Publishing) Platinum 2002 right after I got it in a bundle with my HP Pavallion N5295 Notebook more than several moons ago!I don't want to be a rocket scientist to produce edited photos quickly and with quality results, again and again.I had a terrible time at first with the edited pictures. Software Tools To Help Your Business Sell More Sales are all about leverage, because there is only so much you can do on your own. But, with the help of these simple tools, you can easily double, triple and quadruple your productiviting and make more sales. Fleet Maintenance Software Reviews Innovative Maintenance Systems (IMS) is one company that offers solutions for companies in need of fleet maintenance software. One of their most popular products is Fleet Maintenance ProŽ. Screenshots Vista Windows FeaturesAdditionally, Vista will include many other new features.AeroVista will include a completely re-designed user interface, code-named Aero. Helping Newbies Understand Professional Software The Windows registry is a huge database that ensures normal computer operation. Installing and uninstalling software can make your registry a mess, leading to decreased PC performance and causing computer crashes. Data Quality Best Practices for Salesforce.com Executive SummaryAn effective plan for entering, cleaning and updating the data for your salesforce.com (SFDC) system is critical for achieving success with SFDC. eCommerce development for Microsoft Great Plains: tools and highlights for programmer Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise was designed in earlier 1990th as ERP, which can be easily transferable to the winning Database and OS platform and it was originally available on Mac and PC - Mac OS and Microsoft Windows respectively. Graphical platforms battle is pretty much over and now with eCommerce demands, we should look at Great Plains Dynamics tables structure:? Naming Convention. The Secret of the Layer Styles Dialogue When you double-click a layer in the Layer Palette, you will access the Layer Style dialogue box. Here, you can set many eye-catching layer styles such as Bevel & Emboss, Drop Shadow, Inner Shadow, etc. Twelve Things You Should Know to Save on Computer Software Do you want to get quality software at a reasonable price? Whether you work at home or just need good software for your personal computer, you are faced with an almost endless selection of computer software. Sorting through the options can sometimes be a major task. Microsoft Update - 5 Reasons to Update Service Pack 2 Microsoft released Service Pack 2 (SP2) for the Windows XP operating system back in August (2004), representing significant improvements in many areas, especially system security. For those people that are still unsure whether they should update to it, the following five reasons may help make the decision easier. Understanding XML Server XML Server can be a Web Server that stores the XML files in it and serves them on demand. The XML Server would have processing capabilities with an XML engine and to transform the XML document to other forms. Begun, The Browser Wars Have As Mozilla Firefox nears 10% market share, with well over 25 million downloads direct from the makers website, and goodness knows how many through other sources, Microsoft announces that it will be releasing IE 7 ahead of schedule. Originally scheduled for release with Microsoft's new Longhorn operating system in 2006, it seems that Microsoft are reacting to the run away success that Firefox has had over the last few months. An Introduction to .NET Framework .Net Framework is a platform or development environment to seamlessly create web-applications that are accessible through client machines from across the globe. Microsoft Great Plains: Interest Calculation Example - Stored Procedure for Crystal Report This is intermediate level SQL scripting article for DB Administrator, Programmer, IT SpecialistOur and Microsoft Business Solutions goal here is to educate database administrator, programmer, software developer to enable them support Microsoft Great Plains for their companies. In our opinion self support is the goal of Microsoft to facilitate implementation of its products: Great Plains, Navision, Solomon, Microsoft CRM. MultiNational Corporation ERP Implementation - Microsoft Business Solutions Great Plains If you look back to the history, you will see that ERP for large publicly traded company had to be built upon very reliable hardware (more likely non-Intel hardware: mainframe, Sun sparc, etc.), powerful database platform: Oracle, DB2, Ingress, Sybase and reliable OS: UNIX. Design a Web Album Using Adobe Photoshop- Part 2 So let's begin crunching down these 300 images using Adobe Photoshop from start to finish. When I say 'crunching', to some 300 images may seem like allot, but it's not. Guide to Software Marketing IntroThis concise article will tell you in plain English how you can promote your software easily and effectively.Submit your softwareI recommend submitting your software to upload. Microsoft Great Plains Data Conversion - Overview For Developer Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. |
home | site map | contact us |