I will TLDR this as much as possible and provide any required additional info as needed.
I have installed Pentaho and used PDI to connect to a local oracle database. I am able to see tables and I am able to connect via the web console and see the connection there.
What I want to be able to do is use that database connection for analysis. In PDI I see the db but not sure what to do next? And in the web console it seems I am unable to use that database connection to actually do anything. Could use some pointing in the right direction.