Hello Listers, Ben and Terry,thanks for your replies.
Yes I do agree that we can connect without using the AR ODBC driver. I have tried to connect to Cognos through the Database directly and not using the Oracle driver.I used some functions to convert the integer date and the selection fields which are numeric. Are are any other hindrances or field types that have to be taken care of when reporting directly or through the Oracle driver? Any suggestions/tips and tricks will be of great help. Cognos mentions that it supports ODBC 3.5 and above, but even with the ARODBC70 it does not seem to work.Just thought of checking if any of the AR listers has been successful with Cognos and AR ODBC. Thanks and Regards, Veerain On 9/20/07, Ben Cantatore <[EMAIL PROTECTED]> wrote: > > > Ok, I think I understand the reluctance, yes, you see the tables and their > cryptic names. The key is to ignore the tables and report of the views, > which off of my oracle ODBC driver, I'm able to do just fine. Perhaps the > solution for you is to create a simple report with the Oracle driver and > show them and see how they respond. > > Ben Cantatore > Remedy Administrator > Avon > (914) 935-2946 > > > *Terrence D Paskiewicz <[EMAIL PROTECTED]>* > Sent by: "Action Request System discussion list(ARSList)" < > [email protected]> > > 09/19/2007 12:25 PM Please respond to > [email protected] > > To > [email protected] cc > Subject > Re: Reporting using BI Cognos > > > > > > > That's how we feel too. Unfortunately, our Remedy Support Team doesn't > agree and we're limited to using the Remedy ODBC driver. > > One question: If you use an Oracle ODBC driver, do you see the table > names and field names, or are you looking at table numbers and field > numbers? > > > - Terry > ------------------------------ > Sr. Business Systems Analyst > Corporate Information Technology > ITCS Reporting Services Abbott > 200 Abbott Park Road > Dept: GA67, Bldg: NWJ46 > Abbott Park, IL 60064-6370 Phone (847)937-1889* > [EMAIL PROTECTED] <[EMAIL PROTECTED]> > ------------------------------ > This communication may contain information that is proprietary, > confidential, or exempt from disclosure. If you are not the intended > recipient, please note that any other dissemination, distribution, use or > copying of this communication is strictly prohibited. Anyone who receives > this message in error should notify the sender immediately by telephone or > by return e-mail and delete it from his or her computer. > > > > *Ben Cantatore <[EMAIL PROTECTED]>* > Sent by: "Action Request System discussion list(ARSList)" < > [email protected]> > > 09/19/2007 11:17 AM > Please respond to > [email protected] > > To > [email protected] cc > Subject > Re: Reporting using BI Cognos > > > > > > > > Since you're not reporting within Remedy, I see absolutely no reason why > you shouldn't use an Oracle driver to report on the data. > > Ben Cantatore > Remedy Administrator > Avon > (914) 935-2946 > *Terrence D Paskiewicz <[EMAIL PROTECTED]>* > Sent by: "Action Request System discussion list(ARSList)" < > [email protected]> > > 09/19/2007 11:26 AM > Please respond to > [email protected] > > > To > [email protected] cc > Subject > Re: Reporting using BI Cognos > > > > > > > > > > Hello Veerain, > > Please forgive my lack of Remedy terminology - I'm a report developer, not > a Remedy admin or developer. > > We have some people here trying to do the same thing using Cognos 8.2. > > They attempted to connect via the Remedy ODBC but were not successful. > Cognos 8.2 requires ODBC drivers to be compliant with ODBC spec 3.5 or > higher. The Remedy-supplied ODBC drivers from AR 6.0 and 6.3 are written > to an ODBC spec lower than 3.5. > > According to Remedy AR 7.0 release notes, the ODBC driver is enhanced and > has ODBC spec 3.5 compatibility. > > I hope this helps. > > - Terry > > Let's see... > > Remedy AR 6.0.3 > HP Ux 11 > Oracle 10g > ------------------------------ > Sr. Business Systems Analyst > Corporate Information Technology > ITCS Reporting Services Abbott > 200 Abbott Park Road > Dept: GA67, Bldg: NWJ46 > Abbott Park, IL 60064-6370 Phone (847)937-1889* > [EMAIL PROTECTED] <[EMAIL PROTECTED]> > ------------------------------ > This communication may contain information that is proprietary, > confidential, or exempt from disclosure. If you are not the intended > recipient, please note that any other dissemination, distribution, use or > copying of this communication is strictly prohibited. Anyone who receives > this message in error should notify the sender immediately by telephone or > by return e-mail and delete it from his or her computer. > > > > *Veerain G <[EMAIL PROTECTED]>* > Sent by: "Action Request System discussion list(ARSList)" < > [email protected]> > > 09/18/2007 11:43 PM > Please respond to > [email protected] > > > To > [email protected] cc > Subject > Reporting using BI Cognos > > > > > > > > > > > ** > Hello Listers, > > ARS 5.1.2.and ARS 6.3 > Oracle 9i > Solaris > > We have BI Cognos 8.2 used for reporting in our organisation.Could Cognos > be used for Remedy reporting. > > Is there anyone who has been able to create Remedy reports in Cognos by > connecting through the Remedy ODBC? > > Any suggestions/pointers to get this working would be highly appreciated. > > I have searched through the archives and do not find much help in > there.Myearlier posts on this have not got any replies,so just trying again! > > Please help!!! > > Thanks and Regards, > Veerain > > __20060125_______________________This posting was submitted with HTML in > it___ > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
