You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
@nadment: There are 3 ways to setup a connection for oracle in Hop.
If you have a SID, to use this (old) format: jdbc:oracle:thin:@hostname:PORT:SID
Put the SID as is in the database name
If you have a service name, use this (newer) format: jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME
Put the service name with '/' prefix in the database name
If you want to use TNS format: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host) (PORT=port)) (CONNECT_DATA=(SERVICE_NAME=service_name))
Put the TNS description in the database name and leave the hostname empty as well as the port.
Issue Priority
Priority: 2
Issue Component
Component: Database, Component: Documentation
The text was updated successfully, but these errors were encountered:
What needs to happen?
https://chat.project-hop.org/hop/pl/7r5ar8dyjiboudcuh5srzqt61y
@nadment: There are 3 ways to setup a connection for oracle in Hop.
If you have a SID, to use this (old) format: jdbc:oracle:thin:@hostname:PORT:SID
Put the SID as is in the database name
If you have a service name, use this (newer) format: jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME
Put the service name with '/' prefix in the database name
If you want to use TNS format: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host) (PORT=port)) (CONNECT_DATA=(SERVICE_NAME=service_name))
Put the TNS description in the database name and leave the hostname empty as well as the port.
Issue Priority
Priority: 2
Issue Component
Component: Database, Component: Documentation
The text was updated successfully, but these errors were encountered: