Understanding Data Sources

There are two types of Data Sources in Metric Insights:

  • Configurable:  are Data Sources for which the source database and access credentials are user-defined.  Each Metric Insights customer can establish and maintain SQL-based access to internal databases and Plugin connections to external sources, including Web Services and a wide range of data service providers.
  • Non-Configurable:  are received by all customers and require no customer maintenance or configuration

1.  Configurable Data Sources (You can use either of the following to pull data into Metric Insights):

  • SQL: Any source accessible through a JDBC driver is considered a SQL data source. This includes traditional databases as well as NoSQL sources with JDBC access; for example, Hadoop Hive. For more information, see: Create New SQL Data Source
  • Plugin: Are used to obtain data that is not fetched using a JDBC driver and is collected using a plugin. Plugins are special components, built by Metric Insights, that send a native fetch command to a Data Source.  Results are fetched in a way that allows Metric Insights to consume the data. A list of supported plug-ins can be found here. For more information, see: Create a New Plugin Data Source

NOTE: Web Services are considered to be a Plugin configured to access data from a custom Web Service

2.  Non-Configurable Data Sources available to all customers are:

3.   Remote Data Collectors

1. Data Source Editors

Information on creating new Data Sources can be found at:

SQL Data Sources

Plugin Data Sources

2. Select a Data Source on an Element Editor

When creating a new element, once you have provided the general information, you are directed to the element Editor > Data Collection tab.

  1. The Data Source drop-down list contains all of the SQL and Plug in Data Sources that have been defined for your instance as well as all non-configurable Data Sources.
  2. Select a Data Collection Trigger that fetches the data. Those are used to control when content should be updated. For more information refer to: Create a Data Collection Trigger (Scheduled / Externally Triggered)
  3. Based on your Data Source selection, you either see a Plugin Command / SQL Statement text box into which you enter the fetch command or other options for defining what data should be fetched from the respective source.

3. Data Source is defined in Dataset / Metric / Report / Event / Dimension and Data Dependency Editors

The Event, Dimension and Data Dependency Editors all have data collection settings similar to those on the element editors.

The example above shows the Dimension Editor.

0 Comments

Add your comment

E-Mail me when someone replies to this comment