Show TOC

Transferring Data with UD ConnectLocate this document in the navigation structure

Use

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. For more information, see 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 UD Connect sources are 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

  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 BW to enable communication between the J2EE Engine and BW. For more information, see the Implementation Guide under Start of the navigation path SAP NetWeaver Next navigation step Business Intelligence Next navigation step UDI Settings by Purpose Next navigation step UD Connect Settings End of the navigation path.

  3. On the basis of the source object elements, model the required InfoObjects in BW.

  4. In BW, determine a DataSource.

Result

You can now integrate the data for the source object into BW. You can either extract the data, load it into BW and physically store it there, or, as long as the prerequisites for this are fulfilled, you can read the data directly in the source using a VirtualProvider.