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 |