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 www.albaspectrum.com.
Beecher limo rentals ..Our hosted solution allow you to run your own search... Read More
XML Server can be a Web Server that stores the... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
I have always regretted how Microsoft price gouges and rips... Read More
Microsoft Business Solutions Great Plains serves multiple industries in the... Read More
Beginning with Domino version R4 it has integration with the... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
The world of small business accounting software can be a... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
It is really interesting that a bug can create problem... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
Following tips help you to learn a software in lesser... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
If you are to buy a HelpDesk & Asset Management... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
All your software is stored on a hard-drive. But how... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
We live in a post-industrial age where information is the... Read More
Linux essentials:It's free for download but you have to pay... Read More
Bridgeview limo Chicago ..Costs of fleet maintenance software can vary widely. It is... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
We all already got used to computer monitoring both at... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
Are you lost in the mess of documents that get... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
I started using PIP (Picture It Publishing) Platinum 2002 right... Read More
In the case when you represent mid-size or mid-size-to-large business,... Read More
Java has come along a long way. Many would agree... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
In this article you will find some background information about... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Microsoft Business Solutions Great Plains serves multiple industries in the... Read More
Anti-virus software is used to find, remove or fix files... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Microsoft Business Solutions main middle market ERP application - Microsoft... Read More
The purpose of one of our projects was MS Exchange... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
Since technology changes so quickly, it is hard to begin... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
Software |