Re: Newbie question re data interrogation?

From: Chuck Dillon (spam_at_nimblegen.com)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 08:46:46 -0500

Glenn Banwell wrote:

> My company have installed some new software which is Unix-based.
>
> We are used to being able to interrogate our databases either via SQL or via
> Access and an ODBC link.
>
> We are now told that this isn't possible (which I don't believe) because the
> software is Unix-based but that the company are considering buying something
> called "Cognos" which, apparently, is frightfully expensive but will do
> everything we want.

If access via a standard protocol like ODBC is not possible it's a
limitation of the software system not the operating system. I expect
that the real message is that they will not be opening the back door of
the system but rather forcing your custom applications to use well
defined interfaces. That would be a good thing.

I never heard of Cognos before I saw this post but not too surprisingly
there seems to be lots of information at http://www.cognos.com

You might also be interested in this hit I got from google:
http://www.datadirect.com/news/releases/20030616/index.ssp
which speaks to the availability of ODBC drivers.

-- ced

>
> I've Googled on "Cognos" but I'm not even sure what I'm looking for. There
> are lots of references to "business intelligence solutions" which I suspect
> are fairly close.
>
> Anybody got any ideas what Cognos is, what it can do, if it's any good, any
> alternatives etc etc?
>
> Many thanks.
>
> 

-- 
Chuck Dillon
Senior Software Engineer
NimbleGen Systems Inc.

Relevant Pages

  • Re: Sybase Source. What "data flow source" to use?
    ... "Allan Mitchell" wrote: ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL using C
    ... I am almost a new C programmer and now I need to use SQL within my C ... The people who are telling you to use a C API are out of their mind. ... is not less complicated than ODBC and ties the user to a single ...
    (comp.lang.c)
  • Re: Quick primer on Unidata-to-SQL Server Connectivity?
    ... but creating a view and then running an SQL query with more than one ... but somewhat extensive experience with UniData SQL. ... until some things improved in UniData ODBC. ...
    (comp.databases.pick)
  • Re: Sybase Source. What "data flow source" to use?
    ... when I right-click over a SQL 2005 ... database and select Import Data, the list of providers does not include ... either A) the list of datasources defined in ODBC Datasources on my computer, ... I've been so excited about SSIS and telling my co-workers how ...
    (microsoft.public.sqlserver.dts)
  • Re: Access SQL DAYOFWEEK() problem
    ... not a SQL function ... "Duane Hookom" wrote: ... >> Could anyone tell me what is the correct syntax for the scalar functions? ... >> ODBC Scalar Functions ...
    (microsoft.public.access.modulesdaovba)