Clarity

 View Only

  • 1.  DBeaver 23.1 Connection Setting for AWS Clarity?

    Posted Jul 24, 2023 12:29 PM

    Is anyone able to connect DBeaver to Clarity in AWS (Oracle Database)?

    Seems DBeaver deprecated Legacy JDBC driver, it broke the connection after upgraded to this version 23.1.

    If anyone able to successfully connect, please provide some connection and settings required



    ------------------------------
    Sanjay Koshti
    HCSC
    ------------------------------


  • 2.  RE: DBeaver 23.1 Connection Setting for AWS Clarity?

    Posted Jul 31, 2023 08:52 AM
    • Make sure you have the latest JDBC driver from Oracle. The legacy drivers are no longer supported. You can download the latest from the Oracle website.
    • In DBeaver, create a new connection. Select "Oracle" as the database type.
    • For the JDBC URL, use something like: jdbc:oracle:thin:@your-clarity-endpoint.amazonaws.com:1521/ORCL
    • Replace "your-clarity-endpoint" with your actual Clarity endpoint.
    • For Username and Password, enter your Clarity credentials.
    • In the Driver Properties section, set:
      • oracle.jdbc.J2EE13Compliant to true
      • oracle.net.encryption_client to REQUIRED
      • oracle.net.crypto_checksum_client to REQUESTED
    • In the Advanced tab, set:
      • oracle.jdbc.fanEnabled to false
    • Test the connection to make sure it works.



  • 3.  RE: DBeaver 23.1 Connection Setting for AWS Clarity?

    Posted Jul 31, 2023 09:51 AM

    Thanks for the details, will you be able to share some screen shots to help out further please?



    ------------------------------
    Sanjay Koshti
    HCSC
    ------------------------------



  • 4.  RE: DBeaver 23.1 Connection Setting for AWS Clarity?

    Posted Jul 31, 2023 09:52 AM

    Is this drive required?

    https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html



    ------------------------------
    Sanjay Koshti
    HCSC
    ------------------------------



  • 5.  RE: DBeaver 23.1 Connection Setting for AWS Clarity?

    Posted Aug 16, 2023 02:32 PM

    I tried using these setting but no success, end up getting same error. Do you have any screen shots you can share for the setting



    ------------------------------
    Sanjay Koshti
    HCSC
    ------------------------------