HTTP route configuration and URLs - table and column in SSG database

Products

• CA API Gateway
• API SECURITY
• CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7)
• CA API Gateway Enterprise Service Manager (Layer 7)
• STARTER PACK-7
• CA Microgateway

Issue/Introduction

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.

Environment

Release : 9.2

Component : API GTW ENTERPRISE MANAGER

Resolution

Provide a sample policy when imported and setup for your environment will display all Service names and corresponding Routing URLs

Additional Information

 

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 

 

 

Service Name	Routing URLs
Validate1	http://<Server Name Host><Domain>.net
Validate5	http://<Server Name Host><Domain>.net
Route-3	${gateway.DM_host}${request.http.uri}${request.url.query}, ${gateway.DM_host}${request.http.uri}${request.url.query}, ${gateway.DM_host}${request.http.uri}${request.url.query}, ${gateway.DM_host}${request.http.uri}${request.url.query}
Route-2	http://<Other Server Name Host><Domain>.net:81/site1