I've created simple transformation in PDI/Kettle that reads a spreadsheet from Google Drive and send results to a Copy Rows to Result step. Works like a charm in PDI, but when I upload to BI Server and call it from a CDE Dashboard I get the following error:
Can't run transformation due to plugin missing
That makes sense since the step to connect to Google Drive was installed in PDI as a plugin from Marketplace.
So, what is the best approach to solve this problem, allowing the BI Server to know this PDI plugin and run the transformation?
Thanks in advance,