COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: donlburton54 on 26 Oct 2015 05:39:47 PM

Title: Framework Manager Teradata JDBC Connection
Post by: donlburton54 on 26 Oct 2015 05:39:47 PM
If I've installed the Teradata JDBC drviers on the Cognos App Server (Linux) do I still need to configure ODBC as well?  I ask because the FM "New Data Source" docs spell out filling in a ODBC connection string.  This connection would be DQM.

Thanks in advance for any help.
Title: Re: Framework Manager Teradata JDBC Connection
Post by: MFGF on 27 Oct 2015 04:12:10 AM
Quote from: donlburton54 on 26 Oct 2015 05:39:47 PM
If I've installed the Teradata JDBC drviers on the Cognos App Server (Linux) do I still need to configure ODBC as well?  I ask because the FM "New Data Source" docs spell out filling in a ODBC connection string.  This connection would be DQM.

Thanks in advance for any help.

Hi,

No - if you plan on using just DQM, you only need the JDBC connection to be defined. When you set up a data source connection to Teradata, the first page of connection settings is for CQM and for authentication - you only need to check the password box and specify the user ID and password on this page. When you click Next you can then enter the JDBC connection parameters.

Cheers!

MF.
Title: Re: Framework Manager Teradata JDBC Connection
Post by: donlburton54 on 06 Nov 2015 03:57:02 PM
Thank you!  One other quick question - Is the Teradata client software required on the Cognos Application Server or are the JAR files enough?
Title: Re: Framework Manager Teradata JDBC Connection
Post by: MFGF on 09 Nov 2015 03:29:13 AM
Quote from: donlburton54 on 06 Nov 2015 03:57:02 PM
Thank you!  One other quick question - Is the Teradata client software required on the Cognos Application Server or are the JAR files enough?

If you're just using JDBC, the jar files are all you need :)

MF.