I am working on a service to list the endpoint URLs in the route configuration for each service configured on the CA API gateway.
I need to know the table name from where I can fetch the details, also, it would be great help you can point me to a document for the mapping of the configurations and the ssg database.
Release : 9.2
Component : API GTW ENTERPRISE MANAGER
Provide a sample policy when imported and setup for your environment will display all Service names and corresponding Routing URLs
When accessed browser will prompt for creds, use JDBC connection “localhost” then display service name and routing URLs
How to:
Need to create JDBC connection to localhost ssg database (NOTE name used in policy is localhost)
Connection Name: localhost
JDBC URL: jdbc:mysql://localhost:3306
User name: gateway
Password: xxxxxxxx
Create new service /RoutingURls, then import the sample-policy.xml
MUST be access SSL, then provide the gateway ID/PW used in policy manager
https://FQDNHost:8443/RoutingURls
Sample Results page