Toad Data Point 5.3 - Installation Guide

Create HBase Connections

Toad allows you to connect to an Apache HBase distributed database, a NoSQL type data source, to view and query tables.

After creating a connection, see About Business Intelligence and NoSQL Data Sources for more information about this data source.

Note: This feature is available in the Toad Data Point Professional Edition only.

To create an HBase connection

1. Click on the Connections toolbar (ALT+F+N).
2. Select Apache HBase from the Group list.

3. Enter the connection information in the Create New Connection dialog. Review the following for additional information:

   Stargate host	Enter the HBase Stargate server name.
   Stargate port	The default port is 60050. If different, enter port number.
   Category	(Optional) Select an existing category or create a new one. See Set Connection Categories for more information.
   Note: In NoSQL and Business Intelligence connections, Toad automatically saves the password in the connections.xml file as obfuscated text, as well as in Toad. To add additional password security, use Toad's Master Password feature. See Security Options for more information.

4. Click Connect to connect immediately while saving the connection information. Optionally, click Save to save the connection without connecting.
5. Upon creating an initial connection, Toad automatically maps the data source objects. This process runs in the background, and until it is finished, you may experience a delay when attempting to access these objects.

Tips: 

• Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.
• You can specify a proxy server to use for Business Intelligence and NoSQL connections at Tools | Options | Database | Data Services.

Related Topics

About Business Intelligence and NoSQL Data Sources