Data sources

A data source contains your stored data. The type of data source you select determines the type of report you can create.

Caution: You must have a clear understanding of the database schema to be able to manage data sources and views. Database schemas are blueprints of how the data is organized in the database. Analytics allows for great flexibility in managing the data sources and views but it is only recommended for users with knowledge and understanding of the database schemas and its administration.

Some examples of data sources are:

• Client Purchase Order

• Expense

• In Out Timesheet

• Invoice

• Organization

• Project Scheduling

• Resource Bookings

• Role Scheduling

• Timesheet

• User Scheduling

• Work

Your data sources will depend on the modules licensed and the permissions granted. The Data Sources list page is where you can:

• Create a new data source.

• Edit an existing data source.

• Delete an existing data source.

• View data source information. The following information displays:

  • Title: The title of the data source.

  • Enabled:

    • Yes the cache is enabled .

    • No the cache is disabled.

  • Database Connection: The name of the database connection.

  • Database User: The user who created the database connection.

  • Last Modified By: The user who last modified the data source.

  • Last Modified On: The date on which the data source was last modified.

• Download the list of data sources.