webMethods BigData Driver for Apache Hive

DataSource

Transaction Type	DataSource Class
NO_TRANSACTION, LOCAL_TRANSACTION	wm.jdbcx.hive.HiveDataSource40 -OR- wm.jdbcx.hive.HiveDataSource

Other Properties

Specify the parameters in the Other Properties field:

Parameter	Description
transactionmode	To enable LOCAL_TRANSACTION connections: transactionmode=ignore Note: LOCAL_TRANSACTION connections are not supported.

Kerberos Authentication

Add the login module in Integration Server_directory\instances\<instance_name>\config\is_jaas.cnf file. The is_jaas.cnf file is provided by Integration Server and located in Integration Server_directory\instances\<instance_name>\config directory.

Example of a login module configuration file:

JDBC_DRIVER_01
{com.sun.security.auth.module.Krb5LoginModule required
useKeyTab=true keyTab="C:/SoftwareAG/Temp/user_xxx.keytab"
principal="user_xxx/gbs.windmill.local@CLOUDERA.COM"
doNotPrompt=true;
};

Configure the krb5.conf file in Integration Server Administrator. For more information, see Kerberos Authentication.

Specify the Kerberos authentication parameters in the Other Properties field in the following format:

authenticationMethod=kerberos;servicePrincipalName=<Service_Principal_Name>

For example:

authenticationMethod=kerberos;servicePrincipalName=hive/gbs.windmill.local@CLOUDERA.COM

Required Connection Property Fields

Driver Name	Server Name	User	Password	Database Name	Port Number	Network Protocol
webMethods BigData Driver for Apache Hive	No	No	No	No	No	No

For more information about limitations, see Limitations.