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

DB Connect Configuration

I created a DB Connect to BW itself to read a table within table.

I'm trying to create the datasource but when I choose "Display Table Contents" it says "No data in this table".

Does someone have any ideas on why I'm not able to see the data but I'm able to see the fields for selection.

Thanks,

Teresa Kallab.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2004 at 12:14 AM

    Teresa,

    I didnot understand 'read table within a table' phrase in your posting. If you want to extract some data within BW, you can create a generic extractor using RSO2 within BW instead of usning a DBConnect.

    Thanks,

    Gopal

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Teresa,

      Just refreshing my memory regarding the BW 3.5 delta features, it appears that for direct access needs you can not use DB connect, but you would need UDC (part of BW 3.5). Perhaps that may be the reason why display table contents using DB connect isn't displaying data.

      If you would like to query a BW table (which gets updated from another source system realtime), perhaps you might want to use an infoset query. Just my opinion.

      Cheers,

      Sree

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2004 at 02:43 PM

    Hello,

    Have you checked the DBConnect OSS note for your database? We are running SQL, so the note I had to use was 512739. I think your table is not meeting the SAP naming convention. Cheers!

    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.