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

Using DB connect with Oracle to extract data in BW

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

  • author's profile photo Former Member
    Former Member
    Posted on Apr 08, 2004 at 05:35 PM

    Hi

    There is plenty of information on DBconnect at help.sap.com and also on sapnet under alias BW

    Both those sources should give you all the information u need to use DBLINK/DBconnect

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Satish for the reply,

      But using help only i came to know of this feature.

      Following them step by step , i have come to this blockage point.

      How can i check, whether DBSL is installed or not.

      We are using SAP client on CITRIX to work.

      Its installation is on a remote site.

      I have put this question to the admin too, but i am in wait state.

      Regards

      Deepali

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.