[AccessD] ODBC - COGNOS

Fred Hooper fahooper at trapo.com
Mon Jun 14 16:42:43 CDT 2004


Exactly

|-----Original Message-----
|From: accessd-bounces at databaseadvisors.com 
|[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
|Mitsules, Mark S. (Newport News)
|Sent: Monday, June 14, 2004 5:33 PM
|To: 'Access Developers discussion and problem solving'
|Subject: RE: [AccessD] ODBC - COGNOS
|
|
|You know the more I step back from this, the more I realize 
|that I need to talk with the data warehouse guys...  For 
|starters, "I" don't know what db they are using (I'm thinking 
|it is SQL Server).  Secondly, it is they who would have to 
|provide me the network location and access so that I could 
|attach.  Moreover, since there is probably no way in hell that 
|they would allow me to attach directly to the tables, I'm 
|guessing that I would have to get them to create a view for 
|me.  Once that's complete, it will be just like attaching to 
|another .mdb table, correct?
|
|
|
|Mark
|
|
|
|-----Original Message-----
|From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca] 
|Sent: Monday, June 14, 2004 3:15 PM
|To: Access Developers discussion and problem solving
|Subject: RE: [AccessD] ODBC - COGNOS
|
|
|Mark:
|
|Why do you do just jump all the steps by coping the SQL code 
|out of the initial Cognos report and use that get the ccode 
|bases to extract the data directly from database.
|
|Can I assume it is an Oracle DB? If so, I could help you as I 
|have been doing similar things, for the last year. From Oracle 
|directly into Access. If it is not an Oracle DB, there are not 
|DBs, that I am aware, that the information could not be extracted from.
|
|Jim
|
|-----Original Message-----
|From: accessd-bounces at databaseadvisors.com
|[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of 
|Mitsules, Mark S. (Newport News)
|Sent: Monday, June 14, 2004 11:06 AM
|To: 'Access Developers discussion and problem solving'
|Subject: RE: [AccessD] ODBC - COGNOS
|
|
|Rich,
|
|I'm confused with your response.  It sounds like you've never 
|done this, but I can't tell whether or not you think it is 
|even possible.
|
|I'll explain my situation a little more.  As it stands now, my 
|current practice is to run a weekly Cognos report from the 
|finance data warehouse and save that data as an Excel 
|spreadsheet.  I then import that data into Access.  So...why 
|is there an ODBC driver for Cognos?  I'm just floating this 
|idea, but it seems to me that if someone went to the trouble 
|of writing an ODBC driver for Cognos, then I should be able to 
|connect directly to the catalog from Access and save myself 
|two steps.  Does that sound feasible? If so how?
|
|
|Mark
|
|
|-----Original Message-----
|From: Lavsa, Rich [mailto:Rich_Lavsa at pghcorning.com]
|Sent: Monday, June 14, 2004 1:25 PM
|To: 'Access Developers discussion and problem solving'
|Subject: RE: [AccessD] ODBC - COGNOS
|
|
|Why would you need to go against a Cognos catalog?  As far as 
|I know that isn't possible other then through Cognos itself.  
|There might be a way to use the Data Cube that gets generated 
|for each report after it is refreshed although I wouldn't have 
|any idea how to do that.  A Cognos catalog is basically where 
|you say what fields you want from what table, what 
|calculations you want, and the place where you apply security.
|
|Cognos is a reporting tool, therefore the login ID that is 
|used should, (I say SHOULD loosely), be read only anyway so if 
|you are trying to do data changes then you'd be in trouble.  
|If you are trying to analyze the data then why not just use 
|Cognos, after all it is a great too for analyzing data, its 
|what it was built for.
|
|If you needed the data then why not go against the same 
|table(s)/warehouse that the Catalog is getting its information from.
|
|Rich
|-----Original Message-----
|From: Mitsules, Mark S. (Newport News) [mailto:Mark.Mitsules at ngc.com]
|Sent: Monday, June 14, 2004 1:08 PM
|To: [AccessD]
|Subject: [AccessD] ODBC - COGNOS
|
|
|Group,
|
|Has anyone ever returned a recordset from a Cognos catalog?  
|Suggestions?
|
|Mark
|--
|_______________________________________________
|AccessD mailing list
|AccessD at databaseadvisors.com 
|http://databaseadvisors.com/mailman/listinfo/ac|cessd
|Website: 
|http://www.databaseadvisors.com
|--
|_______________________________________________
|AccessD mailing list
|AccessD at databaseadvisors.com 
|http://databaseadvisors.com/mailman/listinfo/ac|cessd
|Website: 
|http://www.databaseadvisors.com
|--
|_______________________________________________
|AccessD mailing list
|AccessD at databaseadvisors.com 
|http://databaseadvisors.com/mailman/listinfo/ac|cessd
|Website: 
|http://www.databaseadvisors.com
|
|-- 
|_______________________________________________
|AccessD mailing list
|AccessD at databaseadvisors.com 
|http://databaseadvisors.com/mailman/listinfo/ac|cessd
|Website: 
|http://www.databaseadvisors.com
|-- 
|_______________________________________________
|AccessD mailing list
|AccessD at databaseadvisors.com 
|http://databaseadvisors.com/mailman/listinfo/ac|cessd
|Website: 
|http://www.databaseadvisors.com
|




More information about the AccessD mailing list