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 users can create queries. After you add a data source, an icon with the name of the data source appears in the Data Source Connectivity work area. You should then inform users that the data source is available for them to perform queries and run reports. You can optionally export the list of data sources into a CSV file by right-clicking in the work area and clicking Export as .csv.
In CDM, you can add data source connections to the following data types:
- OLAP
- Relational
- Microsoft Excel
- Hyperion Financial Management (HFM)
- Business Intelligence
See the following articles for more:
- 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