Data sources

Data sources define the JDBC connections between the hosts and the database.

About data sources

Data sources define all JDBC connections to the data tables in the relational database. The data tables contain processed cluster data that can be extracted and used in reports.

You define the JDBC connection to the database when you install Platform Analytics. The information about the JDBC driver together with the user and password information is called the data source. If you change your database or modify your connection, you need to update the data source properties in Platform Analytics accordingly. The default Platform Analytics data source for the server and the node is ReportDB.

Platform Analytics uses one or more data sources. You must install JDBC drivers for your database type on the Platform Analytics server host before defining the corresponding data source.

Data source interactions

The data source is the JDBC connection between the data tables in the relational database and all Platform Analytics components. Any interaction with the data tables in the database goes through the JDBC connection as defined in the data source.

Server data source interactions

Data transformers obtain data from the data tables through the server data sources, and stores transformed data into the data tables through the server data sources.

The data purger purges old records from the data tables through the server data sources.

Node data source interactions

The data sources for the Platform Analytics node interact with the data tables in the database. If your cluster has multiple FLEXnet Manager servers, each FLEXnet Manager server has its own data source.

Data loaders either request cluster operation data, or obtain it directly from the data tables through the node data sources. The data loaders store this data into data tables through the node data sources.

The following diagram illustrates the interaction between data sources and other components.

Data source actions

Actions on the Platform Analytics server data sources

If the Platform Analytics server is running on a UNIX host, you need to restart the Platform Analytics server daemons (by running perfadmin stop all and perfadmin start all) after changing the server data source.


Action

Platform Analytics Console

View the list of server data sources.

In the navigation tree, click Data Sources.

Add a server data source.

When viewing the list of data sources, select Action > Add Data Source.

Edit the settings of a server data source.

When viewing the list of data sources, click the data source and select Action > Edit Data Source.

Delete a server data source.

When viewing the list of data sources, click the data source and select Action > Remove Data Source.


Actions on the Platform Analytics node data sources


Action

Command line

Add a node data source.

UNIX: dbconfig.sh add data_source_name

Windows: dbconfig add data_source_name

where

  • data_source_name is the name the data source that you want to add.

Edit the settings of the Platform Analytics node data source (ReportDB).

UNIX: dbconfig.sh

Windows: dbconfig

Edit the settings of any node data source, including FLEXnet Manager data sources.

UNIX: dbconfig.sh edit data_source_name

Windows: dbconfig edit data_source_name

where

  • data_source_name is the name the data source that you want to edit.