I am relatively new and try to evaluate some more details how to handle data sources in BI

One of my transformation work with a vendor specific JDBC driver. Unfortunately, the driver does not yet support quoted identifiers - the reason why I can not setup a datasource in BI with the driver.

1. I managed to create a Transformation in PDI which I would like to use as a datasource in BI. I uploaded the KTR to BI suite an can run the transformation successfully (output CSV to local filesystem...). I just don't know how to setup a datasource when selecting "Pentaho Data Services" as connection type.
2. I created a working analysis based on the static CSV file from the transformation.

Could someone explain a little bit how to use the KTR file as dynamic data source?