Details on Hortonworks Connection

This dialog is used to set up a connection to a Hortonworks database, allowing you to choose whether to analyze data in-database or to import it into your analysis. Note that you need to install a driver on your computer to get access to the Hortonworks connector. See the system requirements at http://support.spotfire.com/sr_spotfire_dataconnectors.asp to find the correct driver. You can also view Getting Started with Connectors to learn more about getting access to connectors in Spotfire.

To add a new Hortonworks connection to the library:

Select Tools > Manage Data Connections.
Click Add New > Data Connection and select Hortonworks.

To add a new Hortonworks connection to an analysis:

Select File > Add Data Tables....
Click Add.
Select Connection To > Hortonworks.

Option	Description
Server	The name of the server where your data is located. To include a port number, add it directly after the name preceded by colon. The default port is 10000. Example with port number: MyDatabaseServer:10000 Note: The Hortonworks connector supports only HiveServer2.
Authentication method	The authentication method to use when logging into the database. Choose from No authentication Kerberos Username Username and password Username and password (SSL)
Realm	[Only applicable when Kerberos authentication is selected.] The Kerberos realm of the Hive server host. Leave blank if a default Kerberos realm has been configured for your Kerberos setup. For more information about the realm, contact your Hortonworks system administrator.
Host FQDN	[Only applicable when Kerberos authentication is selected.] The fully qualified domain name of the Hive host. For more information about the service name, contact your Hortonworks system administrator.
Service name	[Only applicable when Kerberos authentication is selected.] The service name of the Hive server. For example, "hive". For more information about the service name, contact your Hortonworks system administrator.
Username	The name of the user account you wish to use when logging into Hortonworks.
Connect	Connects you to the specified server and populates the list of available databases below.
Database	Select the database of interest from the drop-down list.