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

DB Connect and General Remote Cube

Posted on Jul 13, 2004 at 03:14 PM 14 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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

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

    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 a 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.

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.