[AccessD] ODBC - COGNOS

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




More information about the AccessD mailing list