Entrar
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Upload data to CRM 2011 from SSIS 2008

Answered Upload data to CRM 2011 from SSIS 2008

  • quinta-feira, 7 de abril de 2011 17:39
     
     
    Entrar para Votar
    0

    Hi,

    I want to upload data to CRM 2011 from flat files. I am planning to use SSIS and i know i have to reference CRM webservices to access the entities. But i am not sure about the webservice URL and other objects which i have to use create data in the entity.

    Other approach which i am thinking of is, i could directly upload it to CRM DB's but i am not sure whether the entity will be mapped to just a single table. If an entity has more than one relationship then i might be ending up inserting data in multiple tables. I certainly want to go with webservice. So if any examples or links will be greatly appreciated.

    Sorry i am new to CRM and there are some examples for CRM 4.0 but it looks like the webservices are changed in 2011.

    Jegatheesh Rengasamy
     

Todas as Respostas

  • quinta-feira, 7 de abril de 2011 19:17
     
     Respondido
    Entrar para Votar
    0
    You can still use the CRM 4.0 Web Service endpoint in CRM 2011.  It remains functional for backward compatibility.
    --pogo (pat)
    • Marcado como Resposta Jegu sexta-feira, 8 de abril de 2011 03:12
    •  
     
  • quinta-feira, 7 de abril de 2011 22:17
     
     
    Entrar para Votar
    0

    Thanks pogo. Good to know.

    I'm just curious to know, what's the replacement service for the below CRM4.0 service in 2011?

    http://servername/mscrmservices/2007/CrmServiceWsdl.aspx (It's exposing all the entities but i don't think the below organization svc exposes that)

    This one?
    http://servername/orgname/XRMServices/2011/organization.svc?wsdl

    If the organization service is the right one then, how should i access the entities? Thanks!

    Jegatheesh Rengasamy
     
  • quinta-feira, 7 de abril de 2011 23:05
     
     
    Entrar para Votar
    0

    The new SOAP WSDL can be found at:

    http://<server>:<port>/XRMServices/2011/Organization.svc?wsdl=wsdl0

    It only exposes the generic Entity class, which is the equivalent of CRM4.0's DynamicEntity.

    --pogo (pat)
     
  • segunda-feira, 27 de fevereiro de 2012 05:30
     
     
    Entrar para Votar
    0

    The new SOAP WSDL can be found at:

    <a href="http://:<port>/XRMServices/2011/Organization.svc?wsdl=wsdl0">http://<server>:<port>/XRMServices/2011/Organization.svc?wsdl=wsdl0

    It only exposes the generic Entity class, which is the equivalent of CRM4.0's DynamicEntity.

    --pogo (pat)
    hi pogo, do you know how to expose the generic and customized entites?
     
  • sexta-feira, 4 de maio de 2012 13:49
     
     
    Entrar para Votar
    0

    Hi Jegu,

    I have done a lot of work on this type of stuff with 4 and 2011 and most of the development decisions were based on whether you are going to do a one time import or repeatedly synchronise the data. We ended up pretty much using Data Sync Studio rather than continually  because the trial keys gave us time for a fast import and the scheduler made sync'ing easy. Changing the fields was not a testing crisis and we didn't need SSIS everywhere. We ended up feeling pretty guilty using the trial keys so we kept buying it for our clients.

    Have a look at their blogs and give the trial a go. ->www.simego.com

    Dave