To include remote data sources in SAP Datasphere, you need to create a connection to the external system and then import or access remote tables from that source.

Here’s a step-by-step guide:

✅ Step 1: Go to Connections in SAP Datasphere

  1. Log in to your SAP Datasphere tenant.
  2. In the left navigation pane, go to “Connections.”
  3. Click “Create” to add a new connection.

✅ Step 2: Choose the Connection Type

  • Select the type of remote source you want to connect, such as: SAP HANA SAP BW/4HANA SAP S/4HANA Google BigQuery Snowflake Oracle, SQL Server, etc.

Each source has its own connector; pick the correct one based on your system.

✅ Step 3: Enter Connection Details

  • Provide: Connection name Host URL or IP Port Authentication method (User/password, SAML, OAuth, etc.) Technical user credentials

✅ Step 4: Save and Test the Connection

  • Click “Save & Test.”
  • If it shows "Connection successful", the source is ready to use.

✅ Step 5: Import or Access Remote Tables

  1. Go to the Data Builder.
  2. Choose “New Graphical View” or “New Entity”.
  3. Click “Sources” and navigate to the connection you created.
  4. Browse the available tables or views.
  5. Drag and drop the remote tables into your data model.

You can choose virtual tables (for live/federated access) or persisted tables (for loading data into Datasphere).

🔁 Optional: Create Data Flows (ETL)

If you want to copy data from remote sources (not just virtual access):

  • Use the Data Flow tool in Datasphere to define data pipelines.
  • Map source to target tables.
  • Schedule or trigger data loads.

🔒 Notes:

  • Ensure network access is allowed (VPN/firewall settings).
  • Use Data Provisioning Agent if your source is on-premise.
  • Follow naming conventions and governance rules for clarity.

Mail us on contact@anubhavtrainings.com

Call us on +91-84484 54549

Website: Anubhav Online Trainings | UI5, Fiori, S/4HANA Trainings



Comments

Post a Comment

Popular posts from this blog

Image
    Anubhav Trainings  is an SAP training provider that offers various SAP courses, including SAP UI5 training. Their SAP Ui5 training program covers various topics, including warehouse structure and organization, goods receipt and issue, internal warehouse movements, inventory management, physical inventory, and much more. SAP S/4HANA  is an abbreviation of SAP Business Suite 4 SAP HANA, an enterprise resource planning (ERP) software package. ... It enables organizations to make business decisions informed by real-time insights, machine learning, IoT scenarios, and predictive computing. Pre-requisites 1. Basic knowledge of programming like DDIC, Function Module, Internal Table 2. Basic programming skills 3. Knowledge of Open SQL Why learn and get certified? 1. Learning CDS view will enable developers to build cutting-edge business applications leveraging the proven, reliable technology as well as the robust in-memory capabilities provided by in-memory DB. 2. Accordi...
Read more
Image
  SAP MDK (Mobile Development Kit) is a development tool provided by SAP that allows developers to create mobile applications for various SAP platforms, including SAP Fiori, SAP Cloud Platform Mobile Services, and SAP S/4HANA. The future scope of SAP MDK looks promising due to the following factors: Increasing Demand for Mobile Applications: The use of mobile devices for business operations is growing rapidly. Organizations are recognizing the need for mobile applications that provide employees, customers, and partners with access to critical business processes and data on the go. SAP MDK enables developers to build native and hybrid mobile apps, making it a valuable tool in meeting this demand. Simplified Mobile Application Development: SAP MDK simplifies the process of building mobile applications by providing a low-code development environment. It offers pre-built UI components, drag-and-drop functionality, and reusable templates, which reduces the development effort and accele...
Read more
Image
  SAP ABAP (Advanced Business Application Programming) is often considered the backbone of SAP development because it serves as the primary programming language for customizing and enhancing the functionality of SAP applications. Here’s why it holds this reputation: 1. Core Role in SAP Systems ABAP is integral to SAP's ERP solutions, enabling the customization and extension of standard SAP modules (e.g., SD, MM, FI). It facilitates the development of reports, interfaces, conversions, enhancements, and forms (RICEF), which are critical in adapting SAP solutions to meet specific business requirements. 2. Rich Development Environment The ABAP Development Workbench provides a comprehensive suite of tools for developing, debugging, and deploying applications within the SAP ecosystem. Features like ABAP Editor, Debugger, and Dictionary allow developers to efficiently create and manage applications. 3. Integration with SAP Frameworks ABAP is closely integrated with SAP’s proprietary datab...
Read more