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

How to establish connectivity in SAP BW with Oracle database

Hi ,

till now i jhave learnt how to use flat file as source system to load master data.

In SAP help, i have seen that thru DBConnect, we can easily create a source system of database

.When i try to create sourcesystem Database

It opens a window which has

Logical System Name

& Source System.

What will come under this?

I am treating Logical System Name as OracleSID . So i give =sicom (our local sid to database)

& Source System = Oracle

In next screen in DBMS option = ORA

then username

DB password in both textboxes in same line.

& Save.

Message comes as "Data was saved"

But when I try to come to previous windows , message comes as

Source System= SICOM cannot be accessed.

"Where I went wrong " is what I am unable to get.

I am a novice to BW.

Thanks in advance for the fast answer

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Mar 31, 2004 at 06:21 AM

    If you are working on BW 2.x you are trying to use a functionality called BD Link. On BW 3.x they call it DB Connect: take a look to sapnet or to the guide to have specific info about the steps to follow.

    Hope it helps


    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.