Connecting data sources to SAP Analytics Cloud – available variants
Before you can start modelling stories and analytic applications a connection type suitable for the use case must be selected.
SAP Analytics Cloud generally distinguishes between 'live' and 'import' connection types for access to data from a wide variety of source systems. 'Live' allows access to data in (near-) real time. The import connection, on the other hand, enables extended modelling for the data being imported. When considered in more detail, connection types can be classified even more finely into the following variants:
- Live – direct connection via CORS
- Live – tunnel connection
- Import – local files
Live connection integration scenarios
In the case of live connections, the data models of the source systems are accessed directly. This does not allow extensive adaptation of data in the SAC model. Only additional semantics and calculations can be generated in the live SAC model. Not intervening heavily in the source system's data model and leaving the data in that system allows simple and (near-) real-time data connections.
Direct connections to source systems are established using the technology of cross-origin resource sharing (CORS), which is the recommended SAP procedure for live connections. The procedure implemented with CORS makes it possible to address the data source directly and securely from the browser by executing corresponding scripts in the background and not having them blocked by the browser. No real connection is thus established between SAC and the source system; instead, exchange via a secure URL ensures that the source system allows requests from the browser.