Enquire Now

How To Configure Import Connections For Data Acquisition In SAP Analytics Cloud

Read to understand how to Configure Import Connections for Data Acquisition in SAP Analytics Cloud. SAP S/4HANA offers a wide range of functionality for end users as compared to other tools of a similar nature.

The SAP firm offers a cloud-based, SaaS-based business intelligence product called SAP Analytics for the cloud. It offers SAP Consulting Services Customers all the essential features of an analytics tool. This SAP-developed tool, built on a HANA-based BI platform, offers analytics compatibility with information from other databases, CRM systems, and ERP systems. 

Data can be fetched from IT consulting and services like Salesforce, Microsoft SQL, and ERP programmes..With the SAP Analytics Cloud solution, you can easily access diverse data sources while combining analytics and planning with special integration to SAP applications.

Key capabilities provided by SAP Analytics Cloud 

Machine learning technology is used by the SAP Analytics tool in SAP Consulting Services to perform data cleansing, spot potential data issues, and offer filtering alternatives. The analytics cloud’s modeling capability can be used to improve your data and build hierarchies for greater data insight. This includes:

  • Enterprise Intelligence
  • Planning Analytics with Augmented Analytics
  • Intelligent Transformation

Principal Elements of SAP Analytics Cloud

The following are some main advantages that SAP Analytics cloud offers to users:

  • Data Exploration Machine Adaptive abilities
  • Financial and business planning that is integrated
  • Statistical Analysis
  • Automatically cleaning data
  • Exploration and display of data
  • Role-based personalization for various users
  • Using unique widgets
  • Applications Adaptation to on-site sources

This application offers a wide range of functionality for IT consulting and services as compared to other tools of a similar nature, including drag and drop reporting, real-time analytics, BI insights, the creation of data visualisations, dashboards, and interactive stories.

Steps to Configure Import Connections for Data Acquisition in SAP Analytics Cloud

Make sure to complete the following steps before attempting to set up an import connection in SAP Analytics Cloud in SAP Consulting Services.

  • A cloud connector has been set up.
  • The agent for SAP Analytics Cloud has been set up.
  • Both the source system and SAP Analytics Cloud have produced the user ID needed to set up the connection to the source.
  • The source system grants the user ID the required security access.

The next steps are as follows:

  • The Connections page in SAP Analytics Cloud must be visited as the initial step in configuring an import connection. To access the main Connections page in SAP Analytics Cloud, click the Connections icon in the left-hand menu, as shown in the image below.
  • The Name and Type of the connection are listed on the Connections page. The connection type (import vs. live data) and source are listed in the Type field. The Type column indicates that the sources are SAP S/4HANA and SAP BW, and the connections are Live Data connections.
  • For SAP S/4HANA, there are two potential connections. S/4 HANA – DIRECT designates a connection to an on-premises SAP S/4HANA system. The third connection option is to a system running SAP S/4HANA Cloud. For reporting and planning, a customer using SAP S/4HANA Cloud can also use SAP Analytics Cloud.
  • All potential sources for the import data connection type are described under Acquire Data (import data connection). You can also filter the list based on the type of data source because there are numerous alternatives (Cloud versus On-Premise, ERP versus Data Warehouse, etc.). To set up the connection parameters for this example, select an SAP S/4HANA connection. The new connection screen will then open as shown below. Depending on the source selected, different criteria need to be kept in mind.
  • The following are the primary inputs for an SAP S/4HANA source:
  1. Connection Name/Description: The connection’s name ought to serve as a distinctive identifier.
  2. Link to an On-Premise S/4HANA instance: Due to the fact that we are configuring a connection to an on-premise system, this option must be checked. The source should not have been SAP S/4HANA Cloud, hence this option shouldn’t be selected.
  3. Location: The site must be the Default Location
  4. Data Service URL: This is the hostname and port number combination for the connection.
  5. Authentication Type: There are two possibilities for an SAP S/4HANA source: basic authentication and no authentication. In order to establish the connection using a system user ID and password, you must select Basic Authentication. There are two more choices available if the Acquire Data source is chosen as OData Services: Client credentials for OAuth 2.0 and an OAuth 2.0 Authorization Code.
  6. Username/Password- When the Basic Authentication option is selected, the User Name and Password fields must be kept up to date. The appropriate access levels for this username and password should be present in the SAP S/4HANA source. Once this is done and the connection is established, the user name and password don’t need to be entered again when the source data import is being used.


The import connection can be used to replicate data after the destination model is set up, where the imported data would eventually remain because it necessitates modeling to be done in SAP Analytics Cloud. This connection can be used to duplicate data from SAP Consulting Services and transform the data before loading it into the model once the model has been configured. Following completion of the initial load, additional loads can be set to run at intervals of several hours up to many months.

2 Mar, 2023

Leave a Reply

Your email address will not be published. Required fields are marked *

OurRelated Blog