I am using Pentaho CDE . I have a requirement to implement a d3 chart http://bl.ocks.org/robschmuecker/7880033
i have installed the d3 component library. selected the d3 component from d3 components in the component panel.
how do i proceed coding. since this chart is taking json as input, but i need to pass sql data source.
could anyone guide me on this. I know this is quite a broad question, but i am stuck at the very beginning.
You need to transform your data from a SQL table to the json the component requires.
If you're building a CDE dashboard, you should use CDA to query the database and return the result set. Then in the D3 component postFetch function, execute the required transformations.