Connections

Overview

Data integration is about extracting, transforming and loading (ETL) large amounts of data from one system to another. The data is processed in bulk and transformations can happen on the full data set, like aggregation, sorting or finding duplicates. Traditionally these ETL tools interact at the database level and pull the data – so the data integration middleware is in control, not the source application.

Data integration allows companies to:

• Optimize analytics: Access, queue, or extract data from operational systems – commonly known as data warehousing – then transform and deliver it to the business in the form of trusted analytics.

• Drive consistency between operational applications: Ensure database-level consistency across applications (intra- and interenterprise), on a bi- and unidirectional basis.

• Share data outside your organization: Provide trusted data to external parties such as customers, suppliers, and partners.

• Orchestrate data services: Deploy all runtime data integration functionality as data services to ensure speed and accuracy.

• Support data migration and consolidation: Address data movement and transformation needs relative to data migration and consolidation, for example, when replacing legacy applications or migrating to new environments.

Data Integration and SAP integration methods

SAP is an application platform that integrates multiple business applications and solutions, such as Customer Relationship Management (CRM), Advanced Planner and Optimizer (APO), and Bank Analyzer. Developers can add business logic within SAP using Java 2 Enterprise Edition (J2EE) or Advanced Business Application Programming-Fourth Generation (ABAP/4 or ABAP), a language proprietary to SAP. You can use the SAP Table, BAPI/RFC functions, and IDocs integration methods to extract data from or load data to SAP systems. Use SAP Table for data-level integration, BAPI/RFC functions for object-level integration, and IDocs for message-level integration. You can use SAP ADSO Writer Connector to load in SAP BW4 HANA. You can also use SAP ODP Extractor Connector to extract data from SAP S4 HANA, ECC, and other Operational Data Provisioning (ODP)-enabled applications. You can perform delta extraction on any ODP source that is enabled with Operational Delta Queue (ODQ).

Creating Import Data Connections

• Import Data Connection to an SAP ERP System

• Import Data Connection to an SAP BPC System

• Import Data Connection to SAP HANA

• Import Data Connection to SAP S/4HANA

Import Data Connection

An import data connection allows you to Connect & Import data from your Source system into JustPerform