Data Source Library


Apps - Manage datasources icon.png  The data source library contains all the data source types grouped by category, from which data sources are created. 

  • Each data source identifies a source of a data (databases, files, third party applications, etc. ) and has different properties depending on its type.
  • You can display data of a data source in charts, tables, lists and reports using widgets added to each app.
  • Data sources include both static data sources where the data is fixed and dynamic data sources where the data is automatically updated.

Open url.png  See General remarks on data sources.

List of data source types

Standard category

Used to define static or dynamic data sources from composite data sources or database queries.

Apps - Datasource - Composite icon.png Composite: Used to combine information from several data sources.
Apps - Datasource - SQL Server icon.png MS SQL Server: Used to retrieve data by running a query in a SQL Server database.
Apps - Datasource - MySQL icon.png MySQL: Used to retrieve data by running a query in a MySQL database.

Files category

Used to define static data sources from the data available on a local server.

Apps - Datasource - CSV icon CSV: Used to retrieve data from a CSV file.
Apps - Datasource - JSON icon.png JSON: Used to retrieve content from a JSON file.

Applications category

Used to define dynamic data sources from third-party applications.

Apps - Datasource - EasyVista icon.png EasyVista: Used to retrieve data by running an Product name - ev itsm.png parent query.
Apps - Datasource - EasyVista KPI icon.png EasyVista KPI: Used to retrieve data using an Product name - ev itsm.png trend.
Apps - Datasource - EasyVista icon.png EasyVista Knowledge Base (Note: Automatically created via the Knowledge Base widget): Used to access the Product name - ev itsm.png knowledge base.

Online category

Used to define dynamic data sources from data available online or by interfacing with third-party products.

Apps - Datasource - CSV Online icon Online CSV: Used to retrieve data from a CSV file.
Apps - Datasource - JSON Online icon.png REST: Used to retrieve content from a JSON file.
Apps - Datasource - REST Connector icon.png REST (Connector): Used to retrieve content in JSON format using the resources configured for a connector.

Procedure: How to manage the data sources of an app

1. To add a new data source:

  • Click Apps - Add datasource icon.png in the Objects pane.
  • Click the type of data source you want. Note: To open a category, click Apps - Category close.png next to it.

Best Practice icon.png  You can use the Apps - Search icon.png search field at the top of the Properties Inspector to filter the type of data source using the name.

  • Specify the properties of the new data source in the Properties Inspector. Modifications will automatically be taken into account and the new data source will become available to all of the widgets in the app.
     

Best Practice icon.png  You can duplicate an existing data source and modify the required properties. To do so, click Apps - Duplicate icon.png next to the data source you want in the Objects pane.

2. To modify a data source:

  • Click Apps - Manage datasources icon.png in the Objects pane and click the name. Note: Those pointing to an alias appear in bold.

Best Practice icon.png  You can use the Apps - Search icon.png search field at the top of the Properties Inspector to filter the data sources using their name.

3. To delete a data source:

  • Click Apps - Manage datasources icon.png in the Objects pane and then click Apps - Delete icon.png next to the data source you want.
Tags:
Last modified by Christine Daussac on 2017/03/31 09:51
Created by Administrator XWiki on 2014/09/02 11:38

Shortcuts

Recent Updates

Haven't been here in a while? Here's what changed recently:

-   Product name - ev itsm.png
-   Product name - ev sas.png

Interesting Content

Quick Call
SCCM Distribution
Actions
Reporting Tools
Purge of archives

Powered by XWiki ©, EasyVista 2017