DB Connect and General Remote Cube

[Former Member]

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

[former_member93896]

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

[Former Member]

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.