This query provide all the necessary connection detail in ODI Topology.
SELECT DISTINCT SNP_TECHNO.TECHNO_NAME AS TECHNOLOGY, SNP_CONNECT.CON_NAME AS DATA_SERVER, SNP_PSCHEMA.EXT_NAME AS PHYSICAL_SCHEMA, SNP_PSCHEMA.SCHEMA_NAME AS SCHEMA_NAME, SNP_PSCHEMA.WSCHEMA_NAME AS WORK_SCHEMA, SNP_CONTEXT.CONTEXT_NAME AS CONTEXT_NAME, SNP_LSCHEMA.LSCHEMA_NAME AS LOGICAL_SCHEMA, SNP_CONNECT.JAVA_DRIVER AS DRIVER_INFO, SNP_MTXT_PART.TXT AS URL FROM SNP_TECHNO LEFT OUTER JOIN SNP_CONNECT ON SNP_CONNECT.I_TECHNO=SNP_TECHNO.I_TECHNO LEFT OUTER JOIN SNP_PSCHEMA ON SNP_PSCHEMA.I_CONNECT=SNP_CONNECT.I_CONNECT LEFT OUTER JOIN SNP_PSCHEMA_CONT ON SNP_PSCHEMA_CONT.I_PSCHEMA=SNP_PSCHEMA.I_PSCHEMA LEFT OUTER JOIN SNP_LSCHEMA ON SNP_LSCHEMA.I_LSCHEMA=SNP_PSCHEMA_CONT.I_LSCHEMA LEFT OUTER JOIN SNP_CONTEXT ON SNP_CONTEXT.I_CONTEXT=SNP_PSCHEMA_CONT.I_CONTEXT LEFT OUTER JOIN SNP_MTXT_PART ON SNP_MTXT_PART.I_TXT=SNP_CONNECT.I_TXT_JAVA_URL WHERE SNP_CONNECT.CON_NAME IS NOT NULL ORDER BY SNP_TECHNO.TECHNO_NAME
November 9, 2018 at 11:44 AM
Below is the SNP tables SQL query included **** jdbc url ****
SELECT DISTINCT
SNP_TECHNO.TECHNO_NAME AS TECHNOLOGY,
SNP_CONNECT.CON_NAME AS DATA_SERVER,
SNP_CONNECT.DSERV_NAME AS DSERV_NAME,
SNP_CONNECT.USER_NAME AS USER_NAME,
SNP_PSCHEMA.EXT_NAME AS PHYSICAL_SCHEMA,
SNP_PSCHEMA.CATALOG_NAME AS CATALOG_NAME,
SNP_PSCHEMA.SCHEMA_NAME AS SCHEMA_NAME,
SNP_PSCHEMA.WSCHEMA_NAME AS WORK_SCHEMA,
SNP_PSCHEMA.WCATALOG_NAME AS WCATALOG_NAME,
SNP_CONTEXT.CONTEXT_NAME AS CONTEXT_NAME,
SNP_LSCHEMA.LSCHEMA_NAME AS LOGICAL_SCHEMA,
SNP_CONNECT.JAVA_DRIVER AS DRIVER_INFO,
SNP_MTXT_PART.TXT AS MTXT_PART_URL,
SNP_MTXT.FULL_TXT As MTXT_URL
FROM SNP_TECHNO
LEFT OUTER JOIN SNP_CONNECT ON SNP_CONNECT.I_TECHNO=SNP_TECHNO.I_TECHNO
LEFT OUTER JOIN SNP_PSCHEMA ON SNP_PSCHEMA.I_CONNECT=SNP_CONNECT.I_CONNECT
LEFT OUTER JOIN SNP_PSCHEMA_CONT ON SNP_PSCHEMA_CONT.I_PSCHEMA=SNP_PSCHEMA.I_PSCHEMA
LEFT OUTER JOIN SNP_LSCHEMA ON SNP_LSCHEMA.I_LSCHEMA=SNP_PSCHEMA_CONT.I_LSCHEMA
LEFT OUTER JOIN SNP_CONTEXT ON SNP_CONTEXT.I_CONTEXT=SNP_PSCHEMA_CONT.I_CONTEXT
LEFT OUTER JOIN SNP_MTXT_PART ON SNP_MTXT_PART.I_TXT=SNP_CONNECT.I_TXT_JAVA_URL
LEFT OUTER JOIN SNP_MTXT ON SNP_MTXT.I_TXT=SNP_CONNECT.I_TXT_JAVA_URL
WHERE SNP_CONNECT.CON_NAME IS NOT NULL
ORDER BY SNP_TECHNO.TECHNO_NAME
February 15, 2018 at 8:23 PM
even for me also it is blank.. i am not able to find where this info stores .. any idea ?
December 30, 2017 at 3:19 AM
Hi
This is a wonderful information. I just have a doubt. When I execute the above query the url field is displaying null characters. I don’t know where the jdbc url is stored in Odi tables. Will you be able to help.
Thanks
Ravi
September 20, 2017 at 12:28 PM
Fantastic information