Build reports using Bex and Bex web directely from a SQL/ORACLE DB

[Former Member]

BI Experts,

With BI 7.0 is it possible to build reports using Bex or Bex web directely from a view in SQL /ORACLE DB without actually saving data in BI?

Thanks

Yashu Raj

[Former Member]

Hi,

It is possible both from Bex and Webex and not only for sql or oracle.You can use data from systems based on the BI Java Connectors in BEx Web Applications.Sun's JDBC (Java Database Connectivity) is the standard Java API for Relational Database Management Systems (RDBMS). The BI JDBC Connector allows you to connect applications built with the BI Java SDK to over 170 JDBC drivers, supporting data sources such as Teradata, Oracle, Microsoft SQL Server, Microsoft Access, DB2, Microsoft Excel, and text files such as CSV. This connector is fully compliant with the J2EE Connector Architecture (JCA).

You can also use the BI JDBC Connector to make these data sources available in SAP BI Systems via UD Connect, or you can create systems in the portal based on this connector.

In the Visual Composer, you can also access various data sources using the BI Java Connectors. With SAP NetWeaver BI, recommended access using the SAP BI Connector, with which you can use BEx Queries or Query views that already exist.

Check the links below.

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/05ad36dbcc6e74e10000000a422035/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/05ad36dbcc6e74e10000000a422035/frameset.htm

Regards.

[Former Member]

Yes it is possible.

You know, reports can only be defined over an infoprovider. Which means first you have to create an infocube. And if you want to access data without extracting it into bw,

this cube should be virtual.

Also, you have to define the datasource. address your table in the db, allowing real time data access. Now you have the source and target. What is left is the path that the data should flow. You should create a transformation ( for field and char assginment) , a DTP and infopackage.

Then define your query on this infoprovider.

Aslo check : [;

Hope this helps

derya