HP BAC - table names where the data collected by BPM is stored.

[Mallesh123]

Hello Guys,

Can anyone please tell me the list of tables where the data collected by the BPM's are stored. we are planning to pull this data and create our own customised reports.

Thanks for your help

Mallesh

[ASmolyaninov]

Hello Mallesh,

You can easily get DB fields from you system.

You should use Meta-Data-Manager method from the BSM JMX http://<your server name>:8080/jmx-console/HtmlAdaptor?action=inspectMBean&name=Topaz%3Aservice%3DMeta-Data+Manager.

Run MBean showMetaDataDBMapping(). This method shows all samples that are defined in BSM.

Output is like that:

Sample: trans_t (BPM_TRANS)

  TUID (TUID)
  time_stamp (SAMPLETIME)
  customer_name (CUSTOMERS_DIM.CUSTOMER_NAME) [BPM_TRANS.CUSTOMER_ID ->    CUSTOMERS_DIM.CUSTOMER_ID]
  customer_id (CUSTOMER_ID)
  internal_u_iTransactionId (INTERNAL_TRANSACTION_ID)
  u_iTransactionId (TRANSACTIONS_DIM.TRANSACTION_ID) [BPM_TRANS.INTERNAL_TRANSACTION_ID ->  TRANSACTIONS_DIM.INTERNAL_TRANSACTION_ID]
  szTransactionName (TRANSACTIONS_DIM.TRANSACTION_NAME) [BPM_TRANS.INTERNAL_TRANSACTION_ID ->   TRANSACTIONS_DIM.INTERNAL_TRANSACTION_ID]
  szTransactionDesc (TRANSACTIONS_DIM.TRANSACTION_DESCRIPTION) [BPM_TRANS.INTERNAL_TRANSACTION_ID -> TRANSACTIONS_DIM.INTERNAL_TRANSACTION_ID]

Here: trans_t - sample name

  BPM_TRANS - table name in profile database.

  customer_id - sample attribute alias

  BPM_TRANS.CUSTOMER_ID ->    CUSTOMERS_DIM.CUSTOMER_ID - DB column, where data stored       

You need samples which names begins with "trans_*" are related to BPM.

You also can use "BSM Reports Guide" for reference.

BR,

Andrew.

[Mallesh123]

Thanks for the information Andrew.  it is very helpful.

we are using BAC version 8.07. i couldn't find the Working with the Generic Reporting
Engine API chapter. please let me know if i need look in another document.

in your attached document,  there is a sample query to pull the data which uses the table name trans_t,  i couldnt locate this table in my bac profile database.

does all the data collected will be saved in the tables under the schema used for bac profile?

thanks a lot for all you help

Mallesh

[ASmolyaninov]

Hello Mallesh,

Did you try jmx? Unfortunatelly I don't have access to the BSM 8.07 now so I can't check whether Meta-Data-Manager exists in BSM8.

Any way, trans-t samples are stored into BPM_TRANS db table. Check it.

Working with the Generic Reporting Engine API chapter you can find in the "Solution and Integration Guide". See attachment.

BR,

Andrew.

[sarahgware]

I was wondering(hoping) if you could tell me if the data collected from sitescope is stored in similar database tables as bpm also. thanks for your help and time., Sarah

[Asaf Shechter]

nope, SiS has its own tables in the profile DB.