Doing sql queires from ScriptedDataSource

I have a few reports that I would like to do by creating my own sql and processing the result To do this I need to have a Database connection. I can make my own before the query. But it seems the best way would to make use of a Connection Pool. Does the Ihub have a connection pool that I could access from a scripted datasource? If it does what do I need to do. Gary Rather

Find more posts tagged with

Comments

mwilliams

Not sure if this pooling is available from a scripted datasource, but you might look into this part of the documentation that talks about setting up the iHub connection pooling. <a data-ipb='nomediaparse' href='http://developer.actuate.com/be/documentation/ihub3/help/BIRTDesigner/index.html#page/DAG/iHub_Connecting_Data_Sources.15.15.html'>http://developer.actuate.com/be/documentation/ihub3/help/BIRTDesigner/index.html#page/DAG/iHub_Connecting_Data_Sources.15.15.html</a>

grather

On the iHub where is thisLog in to Configuration Console, choose Advanced view, then choose Server Configuration Templates. What is the Configuration Console. I have the iportal url. and the SystemConsole url What is the Configuration Console?

mwilliams

Configuration Console was part of iHub2 and iServer. I'm looking into this to see if there is an updated doc.

grather

So any ideas how to get setup and use a Database connection pool for ScriptedDatasets