Getting Salesforce data into SAP HANA for reporting

[tkoitka]

Hi

What options are there to load Salesforce data into SAP HANA for reporting needs?

My client has Business Suite on HANA (on-prem) & SAP BODS.

I know we can batch load data into HANA using BODS but I want to know all my options first before recommending a solution.

Some of the Salesforce data is quite large, one table is 11M records.

Appreciated any guidance.

Thanks

Tyler Koitka

[former_member187605 · Accepted solution]

11M is not a big table. And you can use CDC for incremental loads. Check out the SAP Data Services Supplement for Adapters guide (help.sp.com)Adapters, section 11 Using Salesforce.com adapter metadata for details. You need to:

1. Configure the SalesForce adapter in the DS management console.
2. Create an adpter datastore.
3. Import the metadata
4. Build your application

[tkoitka · Accepted solution]

Thanks Dirk.

This was our main option.

Do you know if there is any other method? What about SDI?

[former_member187605 · Accepted solution]

You can write your own adapter to work with SDI. But why would you reinvent the wheel, knowing your customer has a DS license already?

[tkoitka · Accepted solution]

I agree with you but the real-time replication requirement is what they really want.

It may be a situation where the customer needs to compromise.

Thanks.

[peter_ha3]

Hi Tyler,

you could use the Salesforce adapter for SDI for this requirement:

https://blogs.sap.com/2017/09/14/salesforce.com-adapter-for-sap-sdi-replication-of-salesforce-data-i...

[tkoitka]

This is great Peter - I don't know how I missed this blog post. In the end, the client was happy to just proceed with BODS and more frequent loads. However, I will present this to them to see if they are happy to pursue this at some point in the future.