Data Sources

A data source defines 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 database, such as the location of the database and the timeout duration. A data source connection can include credential information and sign-on. You can also add new connections to a data source and modify or delete existing connections. You must create a data source connection before you can create queries.

In CDM, you can add data source connections to the following data types:

• OLAP
• Relational
• Microsoft Excel
• Hyperion Financial Management (HFM)
• Business Intelligence

Required Permission

To work with data sources, you should have the following permission allowed:

Application Permissions > Data Management > Manage Data Sources

Topics

Configure the Whitelist Element for Data Sources

Configure Windows Authentication for Data Sources

Add an OLAP Data Source

Add a Relational Data Source

Add a Microsoft Excel Data Source

Add an HFM Data Source

Add a Business Intelligence Data Source

Edit a Data Source Connection

Delete a Data Source Connection

See Also

Data Refresh

Expiration Policies for Data Sources