SAC Change Datasource Development in a One-Tenant Environment

SAP Analytics Cloud is a powerful frontend and offers multiple options to share stories with consumers.

When consumption is growing it is also very important that new developments are deployed smoothly for end users.

Especially in a landscape with one tenant, acting as development system, quality system and productive system this could be a challenge.

When models are created on live data connections, there is the option to change the data source from the inside of the model, enabling to switch between for example development and production system.

It is done by clicking on Change Data Source within the settings menu:

A pop-up will appear, which is a warning for indexes for Search to Insight (which is not part of this paper)

Press OK. The selection for the new Data Source appears.

The new Data connection must be of the same type as the previous one. In the connection then switch from for example development to production system.

After that a new data source has to be selected.

When only changing from development to production for example it is best to have the same name and data source on all systems/connections available. Any deviation can lead to problems with existing stories on the previous data source.

If a story already exists on the model, a warning will pop up with the list of dependencies.

It is important to afterwards check all the dependent objects in case widgets or dynamic texts are not showing properly.

Always handling such a switch with care since especially if there are stories on the models that are already published to multiple teams/user groups.