6.2 Accessing Data from SAP Systems Flashcards
SAP BusinessObjects universe can connect to :
SAP and non-SAP datasources
Integration of SAP universe can be done in 2 ways:
- as a live connection, no data stored in the cloud
- as an import data connection, data will be stored on the cloud and updated periodically
Components of a SAP universe live connection to SAC (5)
SAP Universe > SAP BOBJ BI platform live data connect > Reverse proxy > Browser >SAC
Components/flow of a live SAP universe data import to SAC (4)
SAP Universe
> SAP Analytics Cloud Agent
> SAP BTP Connectivity Cloud Connector
>SAC
Requirements for Live data connection (Universe to SAC) (2)
- SAP BOBJ Live Data Connect
- Specific URL running to see universe live connection
Requirements for data import (Universe to SAC) (2)
- SAP BTP Connectivity Cloud Connector
- SAP Analytics Cloud Agent
How to create a universe connection
- create connection
2. create a model on the universe import connection (universe query)
What are the 2 connection types to integrate SAC with S/4HANA
- live connection
- import connection
3 ways to create a live connection to S/4HANA
- Direct
- Tunnel
- Cloud
with S/4HANA, what can you build stories on?
- CDS views
- queries
S/4HANA Live data flow to SAC
- S/4HANA tables
- CDS view (can feed fiori app)
- SAC live connection
- SAC live model
- SAC story
Technical prereqs to import data from S/4HANA (2)
- on prem edition is S/4HANA 1610 with SAP NW release 7.51 SP2
- Latest SAC edition
When importing data from S/4HANA, Master data must be imported first. (t/f)
T
Considerations when importing Master data from S/4HANA
- Descriptions of IDs (properties) may need to be imported separately
- If importing hierarchies, import members first and then the nodes, then the node text
- MD import is only set up once, can be run periodically after
- if data is static, some dim data can be maintained in SAC
