Transferring Data with UD Connect  

Purpose

UD Connect (Universal Data Connect) uses Application Server J2EE connectivity to enable reporting and analysis of relational SAP and non-SAP data.

To connect to data sources, UD Connect can use the JCA-compatible (J2EE Connector Architecture) BI Java Connector. More information: BI Java Connectors.

Prerequisites

You have installed the J2EE Engine with BI Java components.  For more information, see the SAP NetWeaver Installation Guide on the SAP Service Marketplace at service.sap.com/instguides.

Terminology

UD Connect Source
The UD Connect Sources is the instances that can be addressed as data sources using the BI JDBC Connector.

UD Connect Source Object
UD Connect source objects are relational data store tables in the UD Connect source.

Source Object Element
Source object elements are the components of UD Connect source objects – fields in the tables.

Process Flow

...

       1.      Create the connection to the data source with your relational or multi-dimensional source objects (relational database management system with tables and views) on the J2EE Engine.

       2.      Create RFC destinations on the J2EE Engine and in BI to enable communication between the J2EE Engine and BI. For more information, see the Implementation Guide for SAP NetWeaver → Business Intelligence → UDI Settings by Purpose → UD Connect Settings.

       3.      Model the InfoObjects required in accordance with the source object elements in BI.

       4.      Define a DataSource in BI.

Result

You can now integrate the data for the source object into BI. You now have two choices. Firstly, you can extract the data, load it into BI and store it there physically. Secondly, provided that the conditions for this are met, you can read the data directly in the source using a VirtualProvider.