![]() |
Consumption Analytics Documentation |
Data feed configuration for the SmartJdbcCollector.
<bean class="com.cloudcruiser.batch.collect.JdbcFeedConfig">
Spring Batch Example
<bean id="feedConfig" class="com.cloudcruiser.batch.collect.JdbcFeedConfig"> <property name="request" value="SELECT accounting_end_date, accountid, resourceid, sum(resource_units) as resource_units, sum(variable_money_value) AS money_value from summary t1 join account t2 where DATE(accounting_end_date) = ? and t2.account_uid = t1.account_uid and t2.acct_structure = 0 group by accountid, resourceid"/> <property name="requestParameters"> <list> <bean class="com.cloudcruiser.batch.collect.RequestParameter"> <property name="type" value="STRING"/> <property name="pos" value="1"/> <property name="value" value="${param.myJobParam}"/> </bean> <bean class="com.cloudcruiser.batch.collect.RequestParameter"> <property name="type" value="DATETIME"/> <property name="pos" value="1"/> <property name="value" value="${env.selectDate}"/> <property name="format" value="yyyyMMdd"/> </bean> </list> </property> <property name="adjustTimestamps" value="true" /> <property name="outputs"> <list> <bean class="com.cloudcruiser.batch.collect.OutputField"> <property name="cctype" value="USAGE_DATE"/> <property name="input" value="accounting_end_date"/> </bean> <bean class="com.cloudcruiser.batch.collect.OutputField"> <property name="cctype" value="IDENTIFIER"/> <property name="input" value="accountid"/> <property name="label" value="@acctid"/> </bean> <bean class="com.cloudcruiser.batch.collect.OutputField"> <property name="cctype" value="RESOURCE"/> <property name="input" value="resource_units"/> <property name="labelInput" value="resourceid"/> </bean> <bean class="com.cloudcruiser.batch.collect.OutputField"> <property name="cctype" value="RESOURCE"/> <property name="input" value="money_value"/> </bean> </list> </property> </bean>
(c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP