Reporting using 3rd party reporting apps

Hi..

I want to know how to connect to the H2 db to the 3rd party reporting apps. I'm trying to use jdbc connection but don't know exact connection string to connect to live H2 db.

Thanks..

Find more posts tagged with

Comments

suhadi

nope. the one you mentioned refer to enabling h2 db console. the one above refer to using 3rd party app to connect directly to h2db.

etomcat

Hello,

Is this solution still valid? The "official" knowledge base says:

http://community.f-secure.com/t5/Management/Policy-Manager-advanced/ta-p/21758
To enable H2 Database Console, set this property to "true": h2ConsoleEnabled

Do both of these settings refer to the same thing?

Thanks in advance: Tamas Feher, Hungary.

suhadi-pbg

i'll try that. thank you so much..

JuliaR

Hello suhadi-pbg,

It should be enabled in additional_java_args: "HKEY_LOCAL_MACHINE\SOFTWARE( Wow6432Node)\Data Fellows\F-Secure\Management Server 5\additional_java_args"

Property name Value type Description Default value

odbcConnectorEnabled	Boolean	Enables or disables the access to Policy Manager Server database via ODBC	false (Disabled)
odbcConnector.pgAllowOthers	Boolean	When enabled, allows for remote clients to access the database When disabled, only the clients residing on the same computer have the access	false (Disabled)
odbcConnector.pgPort	Number	Specifies the port number to connect to	5435

for more detail instructions please contact F-Secure support