Smart Data Integration Objects

[rrmalgi]

Dear All,

Please help clarify the below queries relating to SDI:

1. How do we transport SDI objects(Rep Task , Flowgraph etc) to different environments?
2. If transport mechanism is not available, is it advisable to create objects in new environments(QA , Prod)?
3. We have several consultants working on same project. But we cannot access other's workspace and objects created by them. How can we ensure that all objects created for a project are visible to all? Helps mitigate any risk that arises if a member moves out of project/org
4. Is DPA needed for connecting to various SaaS like SFDC , Twitter , SFSF etc? In that case where should we deploy the DPA?

I have gone through the below series of blogs and several other blogs before posting my queries here:

https://blogs.sap.com/2016/01/18/hana-smart-data-integration-architecture/

Regards,

Malgi

[jeff_k]

Hi Malgi, are you using XS Classic or XS Advanced for your SDI Development? Assuming XSC for now.

1. You can bundle the reptasks and flowgraphs in a delivery unit and import it in the target environment using XS Landscape management. However you would need to create some objects manually beforehand because they cannot be transported that way (remote sources, actual virtual tables used by your tasks). 2506148 - Is it possible to transport SAP HANA Smart Data Integration and SAP HANA Smart Data Qualit...
2. Yes, you need to recreate remote sources & virtual tables in other environments since they can't be transported.
3. I think this should be handled by creating a role that has object/package privileges on all shared objects.
4. DPA is required for almost all adapters, including Twitter. It should be installed close to the source, ideally on the same LAN but not the same host as the source. This allows for independent restart of the dpagent machine if needed for troubleshooting. For internet based adapters like Twitter, the most important consideration is a stable internet connection, location is not important. That said, most SaaS don't have specific adapters in SDI, and I think the usual method of integration is through ODataAdapter, which runs on the HANA system itself (no DPAgent involved).

Regards,

Jeff

[rrmalgi]

Thanks Jeff for providing the clarification.

I have one more question

"DPA is required for almost all adapters.."

What about for databases, Ex: Oracle, which are not hosted on On Prem environment but on Hyperscalers like AWS or Azure?

DPA can be on-premise? Or DPA adapters does not support connecting to DB hosted on Hyperscalers? Please clarify.

Regards,

Malgi

[jeff_k]

Cloud databases are covered in the PAM document on page 7: https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/TIP/PAM_HANA_SDI_2_0.pdf. DPA does not need to be in AWS or Azure to support those Hyperscaler DBs.