ODBC Driver installation

Post Reply
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

ODBC Driver installation

Post by kenship »

Hi,

A consultant created an instance in our Dev TM1 that pulls data from data warehouse using TI a while ago.

Now he's not with us, we want to create the same instance in other environment.

In Dev, we install both TM1 and BI on the same server. We are not sure if we can just install the same driver set in other environment for data warehouse connection. The other environments have BI and TM1 sitting on different server.

Kenneth
User avatar
mattgoff
MVP
Posts: 516
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

Re: ODBC Driver installation

Post by mattgoff »

WIthout more info on the specific database/driver, all anyone can say is: "probably." You may have to do some additional configuration to help the driver locate the database.

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Re: ODBC Driver installation

Post by kenship »

Thanks for the reply.

I found out that the Oracle driver is already installed and working for BI.

Now what we don't know is whether we can mirror the same process and Oracle driver (32 bit I was told) for TM1, is there any configuration procedure for TM1 to engage the Oracle driver like BI? or simply just spell it out in TI process.

Thanks again.

Kenneth
User avatar
mattgoff
MVP
Posts: 516
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

Re: ODBC Driver installation

Post by mattgoff »

You need to match the driver to TM1, so assuming you're running TM1 x64 you need the 64-bit Oracle driver (P.S. you should add your TM1 version to your profile and/or include it in your initial post for better help). Beyond that, you'll need a TNS entry which points to the Oracle server. If you use a different DSN when you set up the datasource you'll also need to update the TI process; otherwise it should work as-is.

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Re: ODBC Driver installation

Post by kenship »

Hi Matt,

I just talked with our Application team that manages installation. He initially was worried regarding the need to go through JDBC.

However, I checked the TI process and it's ODBC connection using OraClient11g_home1.

I guess that means we can go straight to install oracle driver on our TM1 server and have TI configured to connect to Oracle.

Thanks again.

Kenneth
BrianL
MVP
Posts: 264
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: ODBC Driver installation

Post by BrianL »

mattgoff wrote:You need to match the driver to TM1, so assuming you're running TM1 x64 you need the 64-bit Oracle driver
Actually, IBM created a new 32bit proxy for 10.2.2, so this shouldn't be a concern - https://www.ibm.com/support/knowledgece ... proxy.html
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Re: ODBC Driver installation

Post by kenship »

Thanks! I think we are on 32 bit so we will match it.
BrianL wrote:
mattgoff wrote:You need to match the driver to TM1, so assuming you're running TM1 x64 you need the 64-bit Oracle driver
Actually, IBM created a new 32bit proxy for 10.2.2, so this shouldn't be a concern - https://www.ibm.com/support/knowledgece ... proxy.html
User avatar
mattgoff
MVP
Posts: 516
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

Re: ODBC Driver installation

Post by mattgoff »

BrianL wrote:
mattgoff wrote:You need to match the driver to TM1, so assuming you're running TM1 x64 you need the 64-bit Oracle driver
Actually, IBM created a new 32bit proxy for 10.2.2, so this shouldn't be a concern - https://www.ibm.com/support/knowledgece ... proxy.html
And they used to have AXnet back in the day too, but if the matching driver is available you should really use that. A proxy layer should be a last resort to be used only if the matching driver isn't available.
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
BrianL
MVP
Posts: 264
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: ODBC Driver installation

Post by BrianL »

mattgoff wrote:...if the matching driver is available you should really use that. A proxy layer should be a last resort to be used only if the matching driver isn't available.
Agreed.
Post Reply