What is Datasource & data source connection?? How to find the error in conn??

[TRV]

Dear All,

Can any body here explain the concept of datasource & connections. what is the function of DS, about the databases & about the ETL part.
& one more question, when we run a report if there is an error related to datasource, how to find that it belongs to a particular datasource, how to find the datasource connection is working or not??

any help regarding this is appreciated, thanks guys.

[Lynn]

Dear All,

Can any body here explain the concept of datasource & connections. what is the function of DS, about the databases & about the ETL part.
& one more question, when we run a report if there is an error related to datasource, how to find that it belongs to a particular datasource, how to find the datasource connection is working or not??

any help regarding this is appreciated, thanks guys.

Whoa, this is broad and rather vague, especially the "about the databases & about the ETL part" portion. I can tackle a portion rather broadly. A data source is (not surprisingly) a source of data. Typically this is a database but it could be a cube or a spreadsheet among other possibilities. Connections are used to (again, not surprisingly) connect to your data source and generally would include logon credentials.

There are test functions available in Cognos Connection that you can use to see if a data source connection is working or not. Ultimately you have packages built in Framework Manager that refer to specific data sources and model meta data for use in reporting. Your modeler should be able to describe which sources are used in any particular package. It is possible to use hand coded SQL in Report Studio referring to a data source directly, although this is not generally regarded as a best practice.

If you look at the report you should be able to see what package it is using or what data source a SQL query might be referring to.

You might want to review some of the product documentation to get a better perspective on the overall architecture.

[Zimbo_African_1980]

Yeah this is too broad. I gues u can also add that the ETL(extract, transform and Load) is done to create the datasource.
everything else u said answers qn