Dataflow 3.x Example: JDBC Source with Master Data 

In the following example, master data are extracted from the UD Connect source, loaded into BI and physically stored there.

A database management system (DBMS) with tables is used as the UD Connect source and views are used as the UD Connect source objects. In order to be able to use this source you have to install the appropriate JDBC driver for your DBMS provider on the J2EE Engine of the SAP Web AS. After that you can configure the BI JDBC Connector, that is, the connection between the J2EE Engine and the DBMS. In BI, you create an InfoSource on InfoObjects that are compatible with the view or table fields of the DBMS. For this InfoSource, you generate a generic DataSource for access to data in the DBMS. Select a table or a view for the DBMS and assign the fields to the DataSource fields. You create an InfoPackage for the InfoSource and use it to determine parameters for the data transfer into BI and to load data into BI. Data is stored physically in BI and can be used for analysis purposes in the portal or using the Business Explorer tools.

There is no inversion of the transfer rules in this case because when you make selections in the query, you are accessing the data that is physically stored in the BI Enterprise Data Warehouse Layer and has already been transformed and accessed.