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

SalesForce data integration with SAP HANA

Posted on Jun 08, 2018 at 02:32 AM 1k 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?

SAP HANA smart data integration SAP Landscape Transformation
Add comment
10|10000 characters needed characters exceeded

2 Answers

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

    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 comment
    10|10000 characters needed characters exceeded

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

    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 comment
    10|10000 characters needed characters exceeded