Zoomdata connects to a wide array of data sources available in the marketplace today—from modern databases (including Hadoop, Search, Streaming, and NoSQL) to traditional sources like SQL-based stores. 'Out-of-the-box', Zoomdata comes prepackaged with the following connectors that are automatically installed during the Zoomdata installation process:
JDBC drivers for a few of the connectors are no longer included in the installation package. This means that if you use one of those connectors, then you would also need to configure a JDBC driver before it can be enabled and accessible from within Zoomdata. For additional details including the list of connectors, see Adding a JDBC Driver.
The management of connector services is broken out into two sections:
- Connector Servers
Each connector server runs independently within the Zoomdata environment. You can set up a connection type for each connector server and manage the ones to be available to users in the Zoomdata account.
This means that you are able to enable or disable any number of these servers at any time, depending on the sources that you use and what you need to connect to Zoomdata. Refer to the following figure for a high level concept diagram of the Zoomdata environment.
The setup and management of the connector servers (in the Zoomdata environment) is handled via the Manage Connector Services page, which is accessible to supervisors. To make the actual connection between Zoomdata and your data source, you need to go to the Data Sources page, accessible from the Settings menu. See Connecting to Data for guidance in this area.
The Manage Connector Services page (available to supervisors) lets you toggle the availability of servers for data stores. You can add connector servers that are not available out-of-the-box in Zoomdata. You can also use this page to enable connectors. The Manage Connector Services page is described in this topic.
|The Data Sources page (available to administrators) lets you define the connection between Zoomdata and a data source as well as configure data sources. See Connecting to Data.|
The Manage Connector Services page is where you register a new server and set up the connection type so that it will be accessible by users from the Sources page. Instructions to set up a new connector server is covered in Configuring a New Connector Manually . Refer to the topic for additional connector servers that are available from Zoomdata and may be requested by contacting Zoomdata Support.
Manage Connector Services Page
The connector services page consists of two sections:
- Connector Servers
The connector server section lets the Zoomdata administrator manage the connectivity between Zoomdata and the data store.
The Connector Server table provides the following information:
Connector server name
Type: identifies the type of connector server in the Zoomdata environment
URL/Host: shows the URL or host information
Available: specifies whether the server is enabled or not
Delete: option to delete a connector server, if available
You can delete a connector server that you manually configured. However, keep in mind that before deleting it, you must first delete the connections to the server from the Data Sources page. Then you need to delete the connector (at the bottom of the Manage Connector Services page). When the connections and the connector are all deleted, you can delete the connector server.
Connector Server Types
The Type column identifies the type of server used for connecting Zoomdata to your data source. The following types are supported by Zoomdata:
- Discovery: utilizes a capability integrated in the Zoomdata environment allowing the Zoomdata server to locate and set up the connector server automatically
- HTTP/Socket: if you manually add a connector server to the Zoomdata environment, then it will be either an HTTP or a Socket type
- Core - identifies the connectors that are built into the Zoomdata Server.
Connectors that are of type 'Core'
Connector servers that you registered and connected in Zoomdata are accessible and the registration details may be edited (for example, if the server has moved or changed). Default connector servers provided by Zoomdata are not editable.
If your Zoomdata environment contains a large number of connector servers, a search box is available to help you locate the desired one.
Connectors represent the ability to connect to a specific type of data store (such as Impala or Elasticsearch). This section enables the connected data source to be displayed in Zoomdata's Data Sources page and have them be accessible to users.
The Connectors table provides the following information:
- Connector name
- Connector server name
- Description (optional field that you fill in)
- Toggle to enable or disable the availability of the connector on the Data Sources page
Delete: option to delete a connection type, if available
The 'Internal' connection type cannot be deleted.
To edit a connector, select the connector name. Remember that any connector denoted as 'internal' cannot be edited. If your Zoomdata environment contains a large number of connector servers, a search box is available to help you locate the desired one.
A connector can be enabled or disabled at any time. Checking or unchecking the checkbox in the Enabled column for the target connector determines whether its representative icon appears on the Data Source page. The toggle is instantaneous, removing or adding the icon on the Data Sources page. Existing connected data sources can still be accessed and used.