› › Use SQL Access Insert Reference Data Values for EXTOL Dashboard

Use SQL Access Insert Reference Data Values for EXTOL Dashboard


Previous to Dashboard 2.1, users only had the ability to populate values into EXTOL Dashboard via 'User Reference Fields'. With EXTOL Dashboard 2.1 users have the ability to use the Ruleset Rule: SQL Access Insert Reference.

EBI Ruleset Example

In the example below we show three rules: 98, 99 and 100. In each instance we populate a predetermined value with a keyword.

In rule #98 we pass in the variable 'EDOC_var' and assign the keyword: EDOC. This would be an ideal set-up for a JDEdwards (JDE) ruleset.
Note: In cases where there are large amounts of data being stored (passed into EXTOL Dashboard) the wait times in EBI 2.6 can be excessive. This excessive time is attributed to lack of indices set-up over the internal EXTOL (Derby) tables. This issue has been reported to EXTOL.

EXTOL Business Integrator SQL Access Insert Reference Data Value screenshot


By: on
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.