Tech doc page has been updated. Thank you all for sharing.
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/23-4/configuring-and-viewing-monitoring-data/the-dashboard-portlet/create-and-assign-the-data-source-for-a-widget.html#concept.dita_ce1e7096c1f416c3e41200ded7281319527d30dc_CreateanSQLDataSource
Original Message:
Sent: Oct 24, 2024 12:24 PM
From: Miller Echagarreta
Subject: Configure a datasource to external oracle DB but it didn't work
jdbc:oracle:thin:@<IP>:1521:<servicename>
jdbc:oracle:thin:@<IP>:1521/<servicename>
Original Message:
Sent: Oct 15, 2024 01:05 PM
From: Jason Allen
Subject: Configure a datasource to external oracle DB but it didn't work
I believe this is a documentation error, it should just say "port" not "CA Portal." You should put the port that the database listens on (e.g. 1521 for Oracle usually)
Original Message:
Sent: Oct 15, 2024 12:24 PM
From: Miller Echagarreta
Subject: Configure a datasource to external oracle DB but it didn't work
Steve, excuse me for not being clear...!!!
I am configure a datasource for a widget... I have doubt with the part "CA Portal" what need i change here ? i put the name of the service but it didn't work
Best regards...!!!
Original Message:
Sent: Oct 11, 2024 05:54 PM
From: Stephen Danseglio
Subject: Configure a datasource to external oracle DB but it didn't work
Hi Miller,
What documentation are you referencing?
What exactly are you tryiing to accomplish?
Are you trying to use the adogtw probe to connect to an external database?
Determine the correct URL of your Oracle database. The URL should be in one of the following formats:
jdbc:oracle:thin:@<dbhost>:<dbport>:<sid>
jdbc:oracle:thin:@<dbhost>:<dbport>/<sn>
dbhost = the database hostname
dbport = the database listen port (default is 1521)
sid = the service id for the database
sn = the service name alias for the database
To see what service name aliases are available for connection requests, login as the SYS account and execute the query..
select con_id, name from v$services;
If youre using the jdbc_response probe, format is:
jdbc:oracle:thin:@IP address:Port Number:Database Name
You may also want to look at the adogtw probe:
adogtw configuration
Steve
------------------------------
Steve Danseglio
Technical Support Engineer 4 | IMS Division
UIM Certified Expert
KCSv6 Practices Certified
Certified Customer Success Manager (CCSM) Level 1
Original Message:
Sent: Oct 11, 2024 11:45 AM
From: Miller Echagarreta
Subject: Configure a datasource to external oracle DB but it didn't work
Hi Everyone.
I need configure a datasource to extern DB but it didn't work. Maybe i have some bad on the configuration
This is the configuration from documentation:
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@<dbserver>:CA Portal:<service name>
this is my configuration:
jdbc_driver = oracle.jdbc.driver.OracleDriver
jdbc_url = jdbc:oracle:thin:@172.29.16.10:SVFE:SVFE1
I have doubt with the part "CA Portal" what need i change here ? i put the name of the service but it didn't work
Best Regards...!!!