Agenda is shown above
Left shows import data connections, the right shows live data connections
Who can create connections? See the roles above
You can share connections with the team
Import Data to the Cloud
Importing & storing it in the cloud
Updates can be scheduled
Limit on connection - 8K rows 100 columns
On premise system, use the Cloud Connector and the SAP Cloud Agent
Connect to Live Data
Data sources are above
Create framework, metadata, then goes to firewall of connection, and data does not leave firewall
Do not have limit of 8K rows
Runs on external server to get the metadata
This is the most known method
No external server needed
Some configuration needed on browser; install certificate
How to connect to several environments - BW Development, etc
Reverse proxy - redirect browser to as many paths / resources as needed
Direct - each system has a certificate
Pros and cons are shown above
No additional server, better performance - direct is supported by SAP
Sometimes customers run into problems with reverse proxy and think something is wrong with SAP Analytics Cloud; usually it is reverse proxy problems
See data sources/versions that can do the Live Data Connection
You can go to lower versions with support packs applied SAP Note 2541557 (BW) https://launchpad.support.sap.com/#/notes/2541557
Some final considerations are shown above
Dear SAP, will it be possible to connect SAP Data Services (former BODS) to SAC?
Hi, what are the risks if we don't install an SSL certificate in the direct connection scenario? Considering that the exposed data is metadata only.
SAP Analytics Cloud enforces the requirement for an SSL Certificate for direct connections so it is not optional.
Is connection with some of application like PeopleSoft (oracle) is possible with OData Connection ?
Can we have both reverse proxy and direct connection for a single SAC tenant?
Can an SAC story/dashboard include data across different connections, for example a live connection and an imported data file
Can we connect to social media data sources (i.e. twitter)?
I recommend looking https://www.sap.com/products/data-hub.html
I have been using SAC without an SSL certificate with a Direct Connection via CORS for over 6 months now.
That point that says no additional server required is incorrect as you need a server to manage the ssl certificates.
In a BW live connection there is no way to create hierarchies, how could you do them?