Importing tables issue — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Importing tables issue

Received Response
1
Views
3
Comments
3193829
3193829 Rank 5 - Community Champion
edited Aug 13, 2024 6:12PM in Oracle Analytics Cloud and Server

Hi,

I am trying to import a table from the oracle DB into the RPD.  But i was not able to see the schemas/table structures. I tried in the server and client but it didnot work.

Can anyone please help me on this.

Thanks,

K

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    log into oracle via SQL Developer with same connection credentials - do you see the schema in the list and objects?

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Which Oracle client and OBIEE client are you using 32 or 64 bit? Both should be in sync with each other.

  • Joel
    Joel Rank 8 - Analytics Strategist

    Are you using ODBC or OCI in your connection pool? Do these work on server in terms of connecting to your underlying database?