Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 03:01 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 11:31 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.