Connect Oracle Analytics Cloud to Autonomous Data Warehouse

Question

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:

* one in OAC "Data" component to use in Data Flow and Data Visualisation
* 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.

RV · Answer

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

Brian666H · Answer

Connections / Source-Targets / Edit

Check your URL and JDBC Driver