Configure a datasource to external oracle DB but it didn't work

[Miller Echagarreta]

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.00.00.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...!!!

[Stephen Danseglio]

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
------------------------------

[Miller Echagarreta]

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...!!!

[Jason Allen]

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)

[Miller Echagarreta]

 jdbc:oracle:thin:@<IP>:1521:<servicename>

 jdbc:oracle:thin:@<IP>:1521/<servicename>

[Rajesh Banuka]

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

Rgds,

Rajesh B