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

DB Connect and General Remote Cube

Posted on Jul 13, 2004 at 03:14 PM 9 Views

I'm trying to read data from an Oracle Database using DB connect.

I'm new using remote cubes. Once the datasource is created which ones are the steps from the remote cube to read the data. I saw that Remote cubes don't work with an update rule.

Do I need to add any code to see the table?

Thanks,

Teresa Kallab

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Marc Bernard
    Marc Bernard
    Posted on Jul 15, 2004 at 12:55 AM

    Hi Teresa,

    just create the remote cube based on the InfoSource that matches your Oracle datasource. There's no coding required.

    Please note that this scenario obviously has it's limits when it comes to performance. So if you will be running many "remote" queries or will be processing a lot of data, then it might be better to extract the data in to BW.

    Regards,

    Marc

    SAP NetWeaver RIG, US BI

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jul 19, 2004 at 08:25 PM

      Marc,

      We are new with DB Connect. We are trying to connect to a non-SAP oracle database to extract some forecast data.

      Can I do a DB Connect to BW itself and read a table in BW?. So I don't generate performance issues in the source system.

      Can you give me pros and cons of using DB connect. We are planning on reading 16,000 records a day. Is there any limitation of records? what about users, how many users can we have reading the same table without having significant performance issues?

      Thanks,

      Teresa Kallab.