Restricted access
 
 

September 29, 2010

Data Integration Application for Microsoft Dynamics CRM

A couple of days ago, our team faced an issue when developing a custom application for data integration to Microsoft Dynamics CRM. We thought that sharing the problem and the solution will be useful for the community, so here it is.

Apatar developers had chosen PHP technology for that custom data integration application; I will explain why they had chosen PHP and not Java or Delphi in my next post. Meanwhile, please, keep in mind that this case describes accessing Microsoft Dynamics CRM by means of PHP NuSOAP.

The Microsoft Dynamics CRM Software Development Kit includes documentation that covers a wide range of instructive and practical information. Unfortunately, it does not provide the appropriate information on accessing Microsoft Dynamics CRM MetadataService (fields, tables, and their descriptions) and CrmService (accounts, contacts, leads). To be more exact, it provides the same URL formula for accessing both metadata and data services:

http://server_name_here/MSCRMServices/2007/service_name_here.asmx

where service name is either MetadataService or CrmService.

In the course of development, it became clear that this formula does not work for both services. So, the correct formulas are:

For Metadata

http://server_name_here/MSCRMServices/2007/MetadataService.asmx?wsdl

For CRM data

http://server_name_here/MSCRMServices/2007/CrmService.asmx

As you can see, to access MetadataService you have to add ?wsdl at the end of URL, and to access CrmService you don’t have to add anything.

Hope you’ll find this information useful!

September 24, 2010

Customer Data Integration Using RSS Feeds

Filed under: Data Integration, Database Integration — Tags: , , — Katherine Vasilega @ 7:45 am

September 17, 2010

Data Mapping for Data Integration

Filed under: Data Integration, Data Migration, Data Synchronization, Database Integration, ETL — Katherine Vasilega @ 6:43 am

March 5, 2010

Database Integration: On the Importance of Data Quality Standards

November 27, 2009

Database Integration: Integrating Data from Multiple Sources to SugarCRM

Filed under: Data Integration, Data Migration, Database Integration — Olga Belokurskaya @ 6:27 pm

November 13, 2009

Preparing for SugarCRM Data Integration

Filed under: Data Integration, Database Integration — Olga Belokurskaya @ 10:39 am

September 9, 2009

How Database Synchronization Differs from Other Operational Data Integration Types

Filed under: Database Integration, ETL — Tags: , — Olga Belokurskaya @ 7:47 am

June 25, 2009

Open Source Data Warehouses: the Benefits

Filed under: Data Warehousing, Database Integration, Open Source — Tags: , — Olga Belokurskaya @ 1:21 am

June 16, 2009

What Makes Customer Relationship Management Projects Fail

Filed under: Database Integration — Tags: , — Olga Belokurskaya @ 5:54 am

December 3, 2008

Making an Asset of Your Data

Filed under: Data Cleansing, Data Quality, Database Integration — Alena Semeshko @ 4:26 am
« Older Posts