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.
Culver prom limo ..If you've been using MySQL database to store your important... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Homeland security, airport security, Internet security ??" these days we???re... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
The world of small business accounting software can be a... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
#5 All your hardware components like Printers, PCs etc come... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
All of us know that Microsoft bought former Great Plains... Read More
Spyware is software or hardware installed on a computer without... Read More
Spyware, what it is and what it does. Basically, spyware... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
Microsoft Great Plains is one of the Microsoft Business Solutions... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
Not all of us have the luxury of working both... Read More
The major reason I recommend getting your hands on real... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
In this article you will find some background information about... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
Professional services firm cuts costs and improves productivity with integrated... Read More
No matter how much you enjoy your favorite screensavers, sometimes... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
Wood Dale limo ..You probably didn't casually invite, or extend a formal attendance... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
It's not very often I get excited about a software... Read More
Bill of Lading is required report for Logistics and Freight... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Domino server is a buffer between the operation system and... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Intro This concise article will tell you in plain English... Read More
It is a well known fact that Java as a... Read More
Handling character strings in Java is supported through two final... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
I started using PIP (Picture It Publishing) Platinum 2002 right... Read More
It is really interesting that a bug can create problem... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
Using professional icons in your application or website can bring... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
In this small article we will show you the possible... Read More
Software |