I have a working database connection to my allways free Oracle database in O11.I want to do the same from ODC.Untill now I did not manage to get this working.
Can anyone give me the way to define this connection in ODC?
Hi,
thank you all for your answers and help.I found a solution myself, after searching for 'Oracle JDBC easy connect'.
The solution is adding tcps before the host:tcps://adb.eu-frankfurt-1.oraclecloud.com
Hi @Eric Slikker ,On the ODC portal you have this option - and same information you can use
@Rahul If it had been that simple I had not asked this question. I think the problem is in the parameters: protocol=tcps and security=(ssl_server_dn_match).And in this private cloud I can not define SQLNET.ORA and TNSNAMES.ORA.In Outsystems 11 this is the difference in the configuration mode basic or advanced.If it is this simple, please tell me what I must fill in in the additional parameters to get what I want. And if you want to try this yourself you can get an allways free developer Oracle cloud database.
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)))
Thank you for your suggestion.Can you tell me where and how I can define these additional parameters.In O11 I had the advanced possibility and I lack this in Data Fabric.This is feedback I already gave when I was part of a pre-release test of data fabric.
For your knowledge, the proper connectstring tha works from SQLDeveloper is:jdbc:oracle:thin:username/password@(description=(address=(protocol=tcps)(port=1522)(host=adb.eu-frankfurt-1.oraclecloud.com))(connect_data=(service_name=tfy6z2cjwgzutyx_erixdatabase23_high.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))
When I try things in ODC and see the error: jdbc:oracle:thin:ERIXOUTSYSTEMS/"******"@adb.eu-frankfurt-1.oraclecloud.com:1522/tfy6z2cjwgzutyx_erixdatabase23_high.adb.oraclecloud.com?connect_timeout=15&useFetchSizeWithLongColumn=true&defaultRowPrefetch=1100
The Additional Parameters input allows you to specify additional connection string parameters for advanced connection scenarios. Parameters are separated with the & character or ; for SQL Server connections.
Documentation: https://success.outsystems.com/documentation/outsystems_developer_cloud/integration_with_external_systems/integrate_with_external_data_sources_using_data_fabric/create_connections_to_external_data_sources/ .