Jim Lawrence (AccessD)
accessd at shaw.ca
Mon Jun 14 19:36:40 CDT 2004
Hi Mark: You can attach to, what ever the database is, where ever the data resides, using the same username and password. Use a direct ADO-OLE connection to that data through Access. If you can access the data through Cognos you can access the data through Access...it is that simple. HTH 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 2: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/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com