Reporting using 3rd party reporting apps

Aspirant

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..

1 ACCEPTED SOLUTION

Accepted Solutions
F-Secure

Re: Reporting using 3rd party reporting apps

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

odbcConnectorEnabledBooleanEnables or disables the access to Policy Manager Server database via ODBCfalse (Disabled)
odbcConnector.pgAllowOthersBooleanWhen 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.pgPortNumberSpecifies the port number to connect to

5435

for more detail instructions please contact F-Secure support

View solution in original post

4 REPLIES 4
F-Secure

Re: Reporting using 3rd party reporting apps

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

odbcConnectorEnabledBooleanEnables or disables the access to Policy Manager Server database via ODBCfalse (Disabled)
odbcConnector.pgAllowOthersBooleanWhen 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.pgPortNumberSpecifies the port number to connect to

5435

for more detail instructions please contact F-Secure support

View solution in original post

Aspirant

Re: Reporting using 3rd party reporting apps

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

Superuser

Re: Reporting using 3rd party reporting apps

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.

Highlighted
Aspirant

Re: Reporting using 3rd party reporting apps

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.