Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2004
    Posts
    11

    Talking Unanswered: Need to call tables from oracle to BO

    I need to pull up tables from the data marts of the Oracle source database using Oracle client, or ODBC network layer.

    How can i use in BO. Do i need to decode them. The OS of oracle database is Unix(sun)

    Please help me.

  2. #2
    Join Date
    Jun 2003
    Location
    Ottawa
    Posts
    105

    Bo...

    I'm assuming you mean Business Objects?

    You will need the "Designer" Component to build your meta-data layer (a "universe")....all, the connections are done here, and you have the choice of the driver you would like to use, (i.e. native oracle, or odbc).

    Once your universe is connected and you've defined the tables, joins and objects you're good to go with BO Reporter.
    You're obsessed and distressed 'cuz you can't make any sense
    Of the ludicrous nonsense and incipient senescence
    That will deem your common sense useless

  3. #3
    Join Date
    Nov 2004
    Posts
    11

    Business objects

    Yes. You are right with all that is happening thereafter.

    My doubt was that for any tables you retrieve from Oracle 8i in Unix enviornment then we need to use the shell scripting.

    But i have not heard anything like that in BO.

    Yes the semantic layer universe in Designer needs the tables to go for joins etc,
    But now i am concerned in the part of connecting the tables from the database.

    Thanks,

  4. #4
    Join Date
    Jun 2003
    Location
    Ottawa
    Posts
    105
    the fact oracle is sitting on UNIX is irrelevant.

    The communication is from designer to oracle client....oracle client to the db. UNIX doesn't come into the picture whatsoever. (as far as BO is concerned).

    If you can connect with SQL Plus from the machine you have designer on, you are ready to go.
    You're obsessed and distressed 'cuz you can't make any sense
    Of the ludicrous nonsense and incipient senescence
    That will deem your common sense useless

  5. #5
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    > for any tables you retrieve from Oracle 8i in Unix enviornment then we need to use the shell scripting.

    What do you need the OS of the database server to do?

  6. #6
    Join Date
    Nov 2004
    Posts
    11
    I am clear with your answer.

    Thanks so far the confusion has become clear.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •