Predictive Insights - Extracting Data from APM

Body

NOTE: Please refer to the product documentation for official integration procedure. Only use this if you would like to customize.

https://www.ibm.com/support/knowledgecenter/en/SSJQQ3_1.3.6/com.ibm.scapi.doc/admin_guide/c_oapi_adminguide_integrateapm.html

 

Extracting data from APM is not much different from extracting data from a file source. 

 

This blog entry is going to show you the how-to in a step-by-step manner.

 

(1) First of all, start the mediation.sh tool.

https://www.ibm.com/support/knowledgecenter/en/SSJQQ3_1.3.6/com.ibm.scapi.doc/admin_guide/t_scapi_startingthemediationtool.html

 

(2) Once you have it running, add a new "Predictive Insights Project".

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(3) After a new PI project is created, you can now proceed to add a new "Predictive Insights Data Source".

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(4) Since APM stores its data in a database, you would need to choose "Database" as the Data Source Type.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(5) Now, it's time to configure the datasource.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(a) You give the data source a name.

(b) Then, you configure the timezone of the data.

(c) You enter the hostname of the APM server.

(d) The database is, by default, named "WAREHOUS".

(e) The schema is, by default, named "ITMUSER".

(f) You can use user "db2apm" to access the database.

(g) The default password can be found here =>

https://www.ibm.com/support/knowledgecenter/en/SSHLNR_8.1.4/com.ibm.pm.doc/install/admin_passwords_default.htm

(h) Then, please proceed to "Test Connection" and make sure it's successful.

 

(6) Once you are able to connect to the APM database, you can synchronize the schema.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(7) Once the schema is synchronized, you should see something similar to the following.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(8) From there, you can create the metric group(s) as intended.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(9) After that, you can create and start the topic that you want to use for the model.

 

 

 

 

 

 

 

 

 

 

 

 

 

(10) Once you are happy with your model, you can proceed to deploy it.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(11) Once the model is deployed successfully, then you can proceed to extract the data from APM.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(12) Viola! Now you can see that real data is extracted and merged into PI.