All Apps and Add-ons

DB Connect Enable jConnect Password Encryption

korimko
Engager

The Sybase DB I'm trying to connect to requires password encryption enabled. Does anyone know how to modify driver properties in DB Connect? I can't find any options in the GUI for this.

Thanks!

Tags (2)
0 Karma
1 Solution

korimko
Engager

My solution was to modify the connection settings in db_connection_types.conf

There is a parameter, connection_properties, which you can add.
https://docs.splunk.com/Documentation/DBX/3.1.4/DeployDBX/databasespec

It accepts the properties in JSON format and the key needs to match the jConnect property names.
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc39001.0605/html/prjdbc/pr...

e.g.

[sybase_ase]
displayName = Sybase ASE (jConnect)
serviceClass = com.splunk.dbx2.SybaseJConnectJDBC
jdbcUrlFormat = jdbc:sybase:Tds:<host>:<port>/<database>
jdbcDriverClass = com.sybase.jdbc4.jdbc.SybDriver
supportedVersions = 7.0
database = master
port = 5000
ui_default_schema = dbo
connection_properties = {"ENCRYPT_PASSWORD":"true","RETRY_WITH_NO_ENCRYPTION":"true"}

View solution in original post

0 Karma

korimko
Engager

My solution was to modify the connection settings in db_connection_types.conf

There is a parameter, connection_properties, which you can add.
https://docs.splunk.com/Documentation/DBX/3.1.4/DeployDBX/databasespec

It accepts the properties in JSON format and the key needs to match the jConnect property names.
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc39001.0605/html/prjdbc/pr...

e.g.

[sybase_ase]
displayName = Sybase ASE (jConnect)
serviceClass = com.splunk.dbx2.SybaseJConnectJDBC
jdbcUrlFormat = jdbc:sybase:Tds:<host>:<port>/<database>
jdbcDriverClass = com.sybase.jdbc4.jdbc.SybDriver
supportedVersions = 7.0
database = master
port = 5000
ui_default_schema = dbo
connection_properties = {"ENCRYPT_PASSWORD":"true","RETRY_WITH_NO_ENCRYPTION":"true"}

View solution in original post

0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.