Data Source Overview

A data source is the physical connection to a data repository such as a relational database, an OLAP cube, or a Microsoft Excel file.

A data source connection specifies the parameters needed to connect to the data source, such as the location of the database. It can also include credential information and other details specific to the data source.

In CDM, the administrator can add data source connections to these types of databases:

• OLAP
• Relational
• Microsoft™ Excel
• Hyperion Financial Management (HFM)

The administrator must create a data source connection before users can create queries. After the administrator adds a data source, users should be informed that the data source is available for them to perform queries and run reports.