AnsweredAssumed Answered

APM SQL Rest API

Question asked by EarlWilliams on Jun 13, 2017
Latest reply on Jun 17, 2017 by Guenter_Grossberger

Hello everyone,

 

I have set up the APM SQL Server process and have successfully connected into it via the SQuirreL client using the "System" connection via TEAM Center.  I am looking to leverage the Rest API functionality, since we can use the token for one of our applications.

 

Has anyone set this up before, and if so, did you need to set the following (in the collector of where the APM SQL Server process is running) IntroscopeEnterpriseManager.properties file to true?

introscope.public.restapi.enabled=true

 

The reason why I asked, is this is an attribute that has been around for awhile and I didn't know if it had anything to do with APM SQL Server.

 

I do see the following entry section below the old entries that indicate that it might be used, but I wanted to confirm with everyone here:

 

###############################################################################
# APM Data configuration
###############################################################################
# If value of this property is set to positive number then data transfer from
# APM Data SQL rest api will be limited to this value (in KB/s).
# Otherwise transfer is unlimited.
# Default value: -1
#introscope.enterprisemanager.restapi.sql.rateLimit=-1

# If value of this property is set to positive number then
# APM Data SQL rest api will be limited to number of paralel connections.
# Otherwise transfer is unlimited.
# Default value: 5
#introscope.enterprisemanager.restapi.sql.connectionLimit=5

# If value of this property is set to positive number then
# number of group by groups in memory in APM Data SQL rest api
# will be limited to to this value.
# Otherwise number of groups hold in memory is unlimited.
# Default value: 100000
#introscope.enterprisemanager.restapi.sql.groupCountLimit=100000

# Period for which IP address is blocked due too many failed logins in
# generating temporary token (in seconds).
# Default value: 5 minutes
#introscope.enterprisemanager.restapi.token.lockTime=300

# Number of allowed failed attempts from IP address before it gets blocked.
# Default value: 5
#introscope.enterprisemanager.restapi.token.maxFailsPerIp=5

# Maximum number of connections in generate temporary token endpoint.
# Default value: 10
#introscope.enterprisemanager.restapi.token.connectionLimit=10

Outcomes