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

Update of Direct data Driver->7.1.5

Received Response
31
Views
6
Comments
KeithDunlop
KeithDunlop Rank 2 - Community Beginner
edited Aug 13, 2024 5:26PM in Oracle Analytics Cloud and Server

What are DataDirect used ?

The following are setup ..windows terminal server ..

pastedImage_0.png

Can they be easly be updated from 7.1.4 to 7.1.5

Answers

  • Nelson Nolivos -Oracle
    Nelson Nolivos -Oracle Rank 1 - Community Starter

    Hello @KeithDunlop

    The DataDirect drivers are a collection of JDBC drivers of the most popular DB engines. It will have the JDBC for Oracle Databases for example, but also for other brands.

    They should not be upgraded blindly without checking what JDBC versions are supported with the RDBMS in the backend, or in the case of OBIA, with other products that use JDBC drivers. For example DAC as part of OBIA 7.9.6.4 requires JDK 1.6, thus the JDBC drivers to connect to sources and target databases should be the ones that work with that JDK 1.6 version only.

    Hope it helps,

    Nelson

  • KeithDunlop
    KeithDunlop Rank 2 - Community Beginner

    Thanks Nelson ..

    A customer has  12c OBIEE - customer has reported the following  &  found the following unpublished bug from Oracle

    Bug 25047502 - DATA IS NOT DISPLAYING ON QUERY EXECUTION THOUGH PHYSICAL QUERY RETURNS DATA

    They have flagged the following Tech DOC

    OBIEE 11g|12c: How To Obtain Updated ODBC Drivers ( Doc ID 1542558.1 ) .

    12c OBIEE on Linux server and access via Windows server 2012 R2 terminal server

    DSN – set to Oracle BI Server-Oracle_Home on terminal server

    pastedImage_2.png


    Looking to see which box should be update with the upgrade ..

    Thx

    Keith

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Ia that a pure, stand-alone OBIEE?

  • Nelson Nolivos -Oracle
    Nelson Nolivos -Oracle Rank 1 - Community Starter

    I agree with Christian.

    Please ask that in the OBIEE Community.

    Regards,

    Nelson

  • KeithDunlop
    KeithDunlop Rank 2 - Community Beginner

    Back ground ..

    Random values are displayed in Columns on reports -   If I query the physical table this is not the case. 

    Issue happen with in OBIEE report and Issue SQL ( Logic sql generated) -- Does not happen when run physical sql via SQL Developer

    Also when logic SQL from flagged report .. when ran via Administration -> issue SQL

    Sparsely-populated dimensions

    Any ideas

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Update the driver on a test system first and check what's the impact