Cannot get BI JDBC query to display results..

[Former Member]

My connection to the Oracle DB works fine. The system check in Portal returns OK. The system alias is visible in VC. I can browse tables and views. I can use the BI integration wizard to set up a query, and I am also able to review the output (see the actual table rows) within the query configuration tool.

BUT - I can't get the data to be displayed in an output table. I have dragged a table from the output port of the BI query, the column names are what they should be. When deploying the model I get a warning: 'Element "BI query : "All Data : VC_test" is not in use'.

What am I doing wrong here?

Help MUCH appreciated!!

Henning

[Former Member]

Hello

It's necessary to add a "Start point" on the input of the SQL table. Something like:

Start point => SQL table => output table

Guido