I suggest to first create an 'External DB connection' to store DB connection details.
After that, you can instantiate a new 'Generic - Database extractor (Java)' and configure it.
In order to import Business Driver metrics, please select WKLDAT as dataset.
Then query should be formatted as per WKDAT dataset specification.
As example, let's import a business driver metric TOTAL_EVENTS to report all events happened for application 'myapplication' in one day.
The output of the query should be like:
query should be like:
SELECT '2019-04-26 00:00:00' as TS, 86400 as DURATION, 'myapplication' as DS_WKLDNM, 'myapplication' as WKLDNM, 'TOTAL_EVENTS' as OBJNM, '12345' as VALUE FROM SOURCE_TABLE WHERE TS>:PARL
- DS_WKLDNM is the field where to store business driver lookup information. WKLDNM the business driver name. Can be the same if there is no need to have a more advanced lookup.
- Filtering condition 'TS>:PARL' is optional and is required when ETL should run on daily base and source data provide a timestamp. So it is possible to just import newly added samples. If name of TS column is different in source table, it is possible to change it (editing ETL configuration in advanced mode, changing lastcounter column parameter). Latest processed samples will be recorded as lastcounter (see lastcoounter section in ETL page)
- Please select required metrics among all WKLD datasets