cdaquery: Query Pentaho via the cda web service interface

In piersharding/RPentaho: RPentaho Pentaho CDA Webservice client interface for R

Description

Query Pentaho via the cda web service interface. CDA is the Community Data Access - http://www.webdetails.pt/ctools/cda.html. This enables users to construct a uniform data interface to any of the Pentaho data sources. The cda web service provides a JSON based result payload that converts easily to R structures. In this case all resultsets are given back to the user as a data.frame.

Usage

cdaquery(pentaho, file, id, solution, path, withFactors=FALSE,toNumeric=TRUE, toDate=TRUE, ...)

Arguments

pentaho	Pentaho connection object
file	CDA file name
id	CDA Id
solution	CDA solution name - this is usually the top level directory name
path	CDA path from the solution to the file name
withFactors	Convert character vectors to Factors - default FALSE
toNumeric	Convert numeric vector types to Numeric - default TRUE
toDate	Attempt to convert Date labelled vectors to POSIXct date types - default TRUE
...	Any other named parameters are passed as paramters to the web service call

Details

cdaquery calls the cda web service to execute a predefined CDA query. The query results are parsed and converted into a data.frame object eg:

df <- cdaquery(pentaho, solution='sol', file='cde1.cda', id='MDX1')

Value

Returns a data.frame.

Note

Not much to note here.

Author(s)

Piers Harding

See Also

RPentaho, cdaquery, cdbquery, cdbgroups

Examples

## Not run: 

pentaho <- RPentaho("conn.yml")
df <- cdaquery(pentaho, solution='sol', file='cde1.cda', id='MDX1')


## End(Not run)

piersharding/RPentaho documentation built on May 25, 2019, 6:09 a.m.