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.IsPostBackfalse)
{
// 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.
|
|
|
Separate Anti-keylogging Protection: Who Needs It Most?
If there still are few unprotected computers left, I haven't seen any.Every emerging threat causes means of defense to appear. Anti-virusesand firewalls were the first. Now most computers have also an anti-spyprogram installed. More and more often experts say that some computersneed autonomous anti-keylogging protection as well.Or do they? Isn't a separate anti-keylogger on a PC a little too much?Can a user do without it--why so much attention to a particular typeof what is usually called spyware? Well, the threat is extremelyserious, that's why.Information is not a liquid, but, unfortunately, it tends to leakquite the same...(related: Software)
Easy Guide To Raid Recovery
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive Disks. It is a method of combining several hard drives into one unit. This method offers fault tolerance (the ability of a system to continue to perform functions even when one or more hard disk drives have failed...(related: Software)
Microsoft And Webmasters
Does Microsoft care for WebmastersIt's always been a problem with websites appearing exactly the same on different platforms. As a web developer / webmaster it is extremely difficult to make user experiences rich by having the site look the same in any OS / Browser. The biggest problems they have with there famous Internet Explorer browser is security issues and W3C Standards compliance issues.Does Microsoft have a vision of having the world's most popular browser still? Yes but ...(related: Software)
Preventive Maintenance Software Companies
Several software companies design programs for preventive maintenance. Most of the preventive maintenance software companies produce programs for facilities and businesses. Because many programs are adaptable, they can be used for different types of facilities. Some of the best know preventive ...(related: Software)
Corporate Erp: Standard Vs. Rich Functionality ? Microsoft Great Plains
Traditionally we were considering functionally rich systems, such as SAP, Oracle Financials, PeopleSoft, JDEdwards as the fit for large publicly traded corporation. There might be multiple opinions for the future corporate ERP/MRP systems. We would like to give you our prognosis: high-end systems will be losing market to generic granulated standard functionality systems. Customization will be in high demand ? but it will be appropriate to go for light of medium customization versus purchasing high-end functionality system. It is not a secret, that nowadays multiple companies from Fortune 500 list use midmarket solution, such as Microsoft Great Plains as their corporate ERP. In this small article we'll try to defend our position and give you...(related: Software)
The Top 5 Wrong Reasons For Not Hiring Testers
Considering whether or not your software company should hire a dedicated team of testers? Here are the Top 5 Wrong Reasons why you shouldn't.We Have a Beta ProgramSome people feel that the best way to debug a system is to ship it to your customers and wait for trouble tickets. I don't know how things work in your industry, but as far as I'm concerned, finding new customers is hard enough. I definitely don't want to make matters worse by shipping them buggy software.I've spent the last 5 years in the telecommunications industry where the standard for reliability is 5-9. If I even suggested to my custom...(related: Software)
Software Piracy - Global Increase
Pirated software is on the increase and now accounts for over one third of the software installed on the world's computers and it's cost the software industry a staggering, $28bn (£12bn) last year in lost revenues. That's the startling claim of the UK based, Business Software Alliance. Their annual survey of global software piracy shows that some 36% of softwar...(related: Software)
Online Powerpoint Presentation ? Convert Powerpoint To Flash
Although we don't know whether Microsoft ever envisioned such a big market about PowerPoint on its first release. Today this software is impacting profoundly on education and corporation's activities in the way that nobody could ignore. With a wealth of visual and audio effects people rely on it to express their ideas, plans more intuitively with more effective communication outcomes.One of most wildly PowerPoint application exists in education. With the booming of Internet, traditional education approaches have been eclipsing by various new emerging ways. And in spite of heavy promotion of supposedly new television educational approaches in recent years, from my point of view, the real innovation and revolution is taking place somewhere els...(related: Software)
Microsoft Great Plains Integrations ? Retail Management Sample
Microsoft Business Solutions is emerging as very attractive vendor for mid-size companies. The strength of its products is in their cross integration potential. This integration strategy will be the software development direction for this Microsoft subdivision. Meanwhile, as of right now ? we have to recommend just to stake on it and deal with custom or in-house developed integrat...(related: Software)
Free Preventive Maintenance Software
While several preventive maintenance software manufacturers offer free trials for their products before charging a fee, some companies offer their products for free. Free preventive maintenance software is rare, and is sometimes less thorough than software that must be purchased, but it can be a good solution for a new or struggling business.Often a company will offer the bare minimum of their software for free, and ask that the consumer pay for any upgrades. Again, this bare minimum could be enough for many businesses. Alternatively, it is often sufficient for a co...(related: Software)
Sql Scripts For Project Accounting: Microsoft Great Plains Series ? Overview For Developer
Microsoft Business Solutions Great Plains has Project Accounting module where you can budget the project, assign it to customer contract and then log expenses, timesheets, inventory spending, and finally bill the customer against the project or contract. Microsoft Great Plains Project Accounting does excellent job, but there are cases when you need developer or MS SQL DB ...(related: Software)
Microsoft Great Plains Integration Manager ? Working With Text File
Microsoft 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. You certainly can deploy suc...(related: Software)
Best Practices In Choosing Network Monitoring Software
Blue Cross and Blue Shield of Hawaii (HMSA) found itself with a rapidly expanding network and data center. Our network devices, servers, and software were all growing in complexity and we knew that we would have to leverage technology to gain better control of our IT systems and network. In the past, we confronted the sam...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software