BI Source systems: DB Connect 和 UD Connect的区别

    To connect SAP BI system to source system in purpose of data retrieval you can use apart of other types of source systems following ones: DB Connect & UD Connect. Both of them are basically connection to any database system which is able to provide data for BI system. DB Connect relies on ABAP Stack of WAS besides UD Connect is built on JAVA Stack of WAS.

DB Connect - Enables connections to different relational database management systems and the transfer of data from tables or views from these database management systems into the BI system. Technically it opens another database connection (default database connection is dedicated to SAP kernel which opens a connection to the database on which the SAP system is running) and by this connection data are coming from database to BI system. There is a dependency on database type. There can be two cases: BI system is based on same/different database system as source system. If they are same on BI side (on its application server) there must be installed Database Shared Library (DBSL). If they are different a database-specific client for the particular source database on the BI application server needs to be installed before you can use the DB Connect functions. As SAP system is able to run on different database system a several common industry standard databases are supported. As a source object in database you can use directly database table or view (schemas as well).

UD Connect - Component of BI that, together with the SAP Web AS J2EE connectivity (JAVA Stack), allows you to access virtually all relational and multidimensional data sources. Various drivers, protocols and providers as resource adapters for BI JDBC Connector are available: BI ODBO Connector, BI SAP Query Connector, BI XMLA Connector.

UD Connect (Universal Data Connect) uses the BI Java Connectors as resource adapters for establishing connections to data sources. The data can either be loaded into BI, or accessed directly using a VirtualProvider.

UD Connect source is instance that can be addressed as a data source of BI using BI Java Connectors.

UD Connect source object is multidimensional or relational data store in the UD Connect source, for example, table or cube.

One important prerequisite is there: BI installation must be installed with J2EE Engine (JAVA Stack of WAS) and with BI Java components.