Art of BI: Tutorial – ODI 10g & SalesForce.com Integration

By | In Art of BI, Big Data, Business Intelligence | October 11th, 2010

Sticking with a solid need for integrating sales, performance, and compensation data from distributed data sources I chose one that one that has been relatively absent from this attempt, Oracle Data Integrator.  The detail in this tutorial was too extensive to be placed in a basic blog post and is readily available as a PDF for download.  Please take note that unfortunately this a relatively straightforward integration with some deviations and patches.  Oracle presented this integration as ready but as you can see from this tutorial that that declaration was not 100% accurate.  However, with some step-by-step patching and careful procedural fine tuning the integration is indeed possible and value rich.

Download

[download id=”1″]

If you have any questions, comments, or concerns please post them with this blog post so that all can read and learn from the chain of question and answers.

Cheers,

Christian

Contact Us
Christian Screen
Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).

20 thoughts on “Art of BI: Tutorial – ODI 10g & SalesForce.com Integration”
  1. Hi,

    Thanks for this tutorial, it's really helpful.
    I'm having to upload instances of an object (say contact as in the tutorial) into salesforce from a flat file.
    However, the current problem i'm having, is that, none of the data from the flat file is populated in SFDC.
    I have a new object which is created but which has only a name, audit trail details. The data from the flat file are not transferred to the newly created object.

    Any help on this issue would be highly appreciated.
    Thanks.

    Regds,
    Nishna

    1. Gmb,

      I'm still considering writing the second installment. It will cover 11g ODI when I do write it.

      Cheers,
      Christian

  2. Thank you for this detailed guidelines. Since I am working on a Unix environment I have a quick question; how can I install ApexDataLoader.exe on unix platform? Is there a unix version of this utility?nnThanks Again!

      1. Yes, but you’d have to go the purse web service route instead of using the approach that I’ve listed.

  3. Thank you for this detailed guidelines. Since I am working on a Unix environment I have a quick question; how can I install ApexDataLoader.exe on unix platform? Is there a unix version of this utility?nnThanks Again!

    1. Monohar,

      ODI 11g has basically done away with the SalesForce.com adapter concept and instead you will need to use the Web Service integtration provided by ODI out of the box. This will allow you to have more flexibility in your integration with SF.com but is the only way in ODI 11g to achieve the connectivity you seek.

  4. I can’t download the link provided by you.
    I am just trying to get idea about how to integrated salesforce with ODI 11g.It would be helpfull if you can provide me with the link

  5. Hi christian
    Thank you very much, your post is very helpful!

    I need to send data from Oracle SQL to SalesForce.com. The environment is Linux and ODI 11g (11.1.1.3).

    The OdiInvokeWebService doesn’t supports the POST method (Only GET, and I received a 405 error).

    I have some questions:
    – This solution works in ODI 11g?
    – I need pay for third party softwares (DataDirect or some KM) ?
    – This solution works in Linux?
    – This solution still working with current version of SalesForce?
    – Can I send data to SalesForce?
    – What do you means with “go the purse web service route”?

    Thanks!
    Rafael Bueno