Creating a data source
Procedure
- In IBM Cognos Administration, on
the Configuration tab, select Data
Source Connections. Tip: To remove a data source, select the check box for the data source and select the delete button.
- Select the new data source button.
- In the name and description page, type a unique name for the data source and, optionally, a description and screen tip, and then select Next.
- In the connection page, from the Type drop-down
list, select the type of data source that you want to create.
The Configure JDBC Connection check box is enabled for the following data source types:
- DB2 Data Sources
- Microsoft SQL Server Data Sources
- Netezza® and TeradataODBC Data Source Connections
- Oracle Data Sources
- My Data Sets Repository
If you do not want to create a JDBC connection, clear the check box. For more information about JDBC connections, see Using JDBC Connections for Data Sources.
If your data source is not listed, click Other type.
- Specify the isolation level:
- If Isolation level does not appear, select Next.
- If Isolation level also appears, select the default object gateway or specify a value, and then select Next.
- Specify the connection parameters for the data source.
For information about connection parameters for the type of data source that you are using, click the associated item in the following list:
- IBM Cognos Finance
- IBM Cognos Now! - Real-time Monitoring Cube
- IBM Cognos Planning Contributor
- IBM Cognos Planning - Series 7
- IBM Cognos PowerCubes
- ODBC Data Source Connections, including Composite, IBM Cognos Virtual View Manager, Microsoft SQL Server, Netezza, Progress OpenEdge, Red Brick®, and Teradata
- DB2 Data Sources
- IBM InfoSphere Warehouse Cubing Services
- Informix Data Sources
- Microsoft SQL Server Data Sources
- Microsoft Analysis Services Data Sources
- Oracle Data Sources
- SAP Business Information Warehouse (SAP BW) Data Sources
- Sybase Adaptive Server Enterprise Data Sources
- TM1 Data Sources
- XML Data Sources
- External Repository data source connections
- My Data Sets Repository
- Select Test the connection, and
then Test to test whether parameters are correct.
In the Status column, you can see if the connection was successful. If it was unsuccessful, select Close, return to the previous steps, and verify your connection parameters. If it was successful, go to the next step.
- Click Finish.
If you selected a data source other than IBM Cognos PowerCube or SAP BW, the new data source appears in Data Source Connections on the Configuration tab, and can be selected when using the Metadata Wizard in Framework Manager.
If you selected IBM Cognos PowerCube or SAP BW, go to the next step.
- Click OK to return to Data
Source Connections, or for some data sources, you can
click Create a Package and OK. Note: You can create a package with your new data source now or later. For more information, see Creating a Package. The Create a Package check box is only available if you have the appropriate capabilities. For more information, see Secured Functions and Features.)