Hi, is there a way to extract all "sql over sqlJndi" queries? We have many *.cda files with similar selects. We would like to extract them all in order to compare them when we have to change something. Opening each dashboard, and manually copying is not an option. Regards. <a data-tag-text="Ctools" data-sign="#" class="user-content-hashtag" href="https://hitachi.connectedcommunity.org/search?s=tags%3A%22Ctools%22&executesearch=true" data-tag-key="2e7baf93-987a-4c6c-9b00-84a35a063582">#Ctools</a> <a data-tag-text="Pentaho" data-sign="#" class="user-content-hashtag" href="https://hitachi.connectedcommunity.org/search?s=tags%3A%22Pentaho%22&executesearch=true" data-tag-key="70b4436b-4549-4ce3-aa64-4566c7b665c9">#Pentaho</a>

Pentaho

View Only

Glupe Registracije posted 10-23-2018 12:20

Hi,

is there a way to extract all "sql over sqlJndi" queries?

We have many *.cda files with similar selects. We would like to extract them all in order to compare them when we have to change something.

Opening each dashboard, and manually copying is not an option.

Regards.

#Ctools
#Pentaho

Dan Keeley posted 10-23-2018 14:35

Simple!

Use the repository synchronizer, and dump everything to disk.

Then use PDI to loop around all the CDA files.

Use the get data from XML step, and a CDA path something like this:

/CDADescriptor/DataSources/Connection

And there you go.

I do this to identify every CDA end point, so i can automate creation of unit tests!

Glupe Registracije posted 10-25-2018 13:02

Dan, thank you very much for your answer. I was unaware of the repository synchronizer plugin existence.

At the moment, I am testing it. Furthermore I am testing pentaho api-s (getCdaList, listQueries, getCdaFile...) as well.

Regards.

Dan Keeley posted 10-25-2018 13:10

good call - the api will work perfectly well too. In fact the repo sync uses the API anyway.

I was just using the repo synchronizer in a "sledgehammer to crack a nut" way