Author Topic: Cognos Tools Against a Data Warehouse!  (Read 4489 times)

Offline tabanchuy

  • Full Member
  • ***
  • Join Date: May 2010
  • Posts: 12
  • Forum Citizenship: +0/-0
Cognos Tools Against a Data Warehouse!
« on: 13 May 2010 09:09:27 pm »
Hi,

I am used to cognos 7.2 and i have not created a catalog that accesses a data warehouse, I am used to pulling data straight to DB2 source with an ODBC.

I would just like to know the difference between making a catalog that points to a data warehouse, and a catalog that points straight to a source.

I know that an ETL uses different ODBCs to connect and join various databases and hosts it as a different environment from there on. So how do I go about making a catalog that will pull data there?

Someone please enlighten me, any inputs will surely be appreciated! :)
Learning is a day to day process!!!

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,252
  • Forum Citizenship: +662/-10
  • Cognos Software Muppet
Re: Cognos Tools Against a Data Warehouse!
« Reply #1 on: 14 May 2010 05:54:49 am »
What kind of database is being used for the data warehouse?  In reality a data warehouse is just another database as far as Impromptu is concerned - all you need to do is to use the appropriate native/odbc connection to point to it, then bring in definitions of the required tables as normal.

MF.
Meep!

Offline tabanchuy

  • Full Member
  • ***
  • Join Date: May 2010
  • Posts: 12
  • Forum Citizenship: +0/-0
Re: Cognos Tools Against a Data Warehouse!
« Reply #2 on: 14 May 2010 09:25:58 am »
Ah ok. That's all i need to know! hehehe. I was thinking it might be something that could be accessed without the need of an ODBC, like its owning the datawarehouse as its own database hehehe. I was over-thinking there!

I appreciate your help sir! Sorry for the ignorance! hehehe.
Learning is a day to day process!!!