Oracle Analytics

Get Involved. Join the Conversation.

Topic

    RV
    Connect Oracle Analytics Cloud to Autonomous Data WarehouseAnswered
    Topic posted April 28, 2019 by RVGreen Ribbon: 100+ Points, last edited September 11, 2019, tagged Access & Manage Data, Packaging & Licensing 
    102 Views, 2 Comments
    Title:
    Connect Oracle Analytics Cloud to Autonomous Data Warehouse
    Summary:
    Error while trying to set-up connection to Oracle Autonomous Data Warehouse in Oracle Analytics Cloud
    Content:

    Dear all

    I successfully set-up an Oracle Analytics Cloud (OAC) trial instance and an Oracle Autonomous Data Warehouse (OADW) trial instance.

    I created two different connections to OADW:

    1. one in OAC "Data" component to use in Data Flow and Data Visualisation
    2. one in OAC "Service Console" to use as the source for the Data Modeler

    The first one could work successfully, but when I try to Test the second connection, it gives me the error "IO Error: got minus one from a read call".

    In both cases, I've used the wallet file download from OADW to create the connection.

    Great thanks in advance for your help.

     

     

    Image:

    Best Comment

    RV

    I could sort it. I was using the wrong TNS connection string. I copied the string from the OADW DB connection page and pasted it to the OAC connection editor.

    I've found the right TNS string within the OADW Connection Wallet that I've downloaded and that has worked successfully.

    Thanks

    Comments Are Closed

     

    • Brian Hall

      Connections / Source-Targets / Edit 

      Check your URL and JDBC Driver

    • RV

      I could sort it. I was using the wrong TNS connection string. I copied the string from the OADW DB connection page and pasted it to the OAC connection editor.

      I've found the right TNS string within the OADW Connection Wallet that I've downloaded and that has worked successfully.

      Thanks