Skip to Content
author's profile photo Ratnakara gattu
0
Ratnakara gattu

SalesForce data integration with SAP HANA

Posted on Jun 08, 2018 at 02:32 AM 1.2k Views

Our client wants SalesForce tables to be replicated into SAP HANA. In our case BODS is NOT an option. Can we use SLT to replicate SAlesForce Data? if so what kind of connectors need to used? Is SDI an option in this case?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Jeff Kresse
    Jeff Kresse
    Posted on Jun 08, 2018 at 01:59 PM
    0

    From SDI perspective, you may be able to use the Camel Adapter with SalesForce's JDBC interface. The only complication might be that SF does not use SQL, but rather SOQL (SalesForce Object Query Language).

    I'm not sure if SalesForce has an OData interface for the data you need to replicate, SDI has an adapter for OData as well.

    Last, you could develop a custom adapter to connect to SalesForce with SDI.

    Best regards,

    Jeff K

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Ratnakara gattu
    Ratnakara gattu
    Posted on Jun 08, 2018 at 03:02 PM
    0

    Jeff

    looks like Advantco SFDC adapter converts the SAP HANA SQL syntax to SOQL syntax automatically

    . We are investigating on this.

    thanks for your response.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Ratnakara gattu
    Ratnakara gattu
    Posted on Jul 17, 2020 at 05:38 PM
    0

    Shyam

    We used Advantco SFDC adaptor with SDI to integrate SFDC data into HANA.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.