(v24) Connect Visual Data Discovery to Data Stores

Connect Visual  Data Discovery to Data Stores

This applies to: Visual Data Discovery

Using connectors, you can connect to a wide array of data stores, from modern databases such as Hadoop, Search, Streaming, and NoSQL, to traditional sources like SQL-based stores. By default, your environment comes preconfigured with certain connectors enabled. However, additional connectors are available. If the connector you are looking for is not shown, it may be because:

• The connector is installed but is not enabled. For more information, see Manage Connectors and Connector Servers.

• The connector was not installed and needs to be downloaded separately. For more information, see Obtain Additional Connector Servers.

• The connector requires you to provide a licensed JDBC driver. For more information, see Add a JDBC Driver.

Certain connectors require a JDBC driver, which is obtained through a separate download. This allows you to select and add a driver that meets your operation needs or policies.

To connect to a data store and use its data in a data discovery visual, you must first verify that a connector and its connector server have been defined in data discovery for the data store. See Manage Connectors and Connector Servers. Then you must define a data store connection and a data source configuration that uses the connection. The data store connection can be defined while you are setting up the data source configuration. See Manage Data Discovery Data Store Connections and Manage Visual Data Discovery Data Sources for more information.

Note: Symphony supports only underscores and dashes in data store field names. No other special characters or white space are supported. If your data store uses special characters other than underscores and dashes in field names, please remove them before attempting to create a data source configuration.

For information about what versions of data stores are supported by the Symphony connectors, see Data Connector Reference. For information about which features are supported by different connectors, see Connector Feature Support.

You can also use a Managed Dashboard connection as a source or in a fusion source in Visual Data Discovery. See Add and validate a connection to a data cube.