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
ODBC Driver installation
- 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
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
Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
-
- 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
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
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
- 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
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
Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
-
- 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
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
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
-
- 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
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.htmlmattgoff wrote:You need to match the driver to TM1, so assuming you're running TM1 x64 you need the 64-bit Oracle driver
-
- 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
Thanks! I think we are on 32 bit so we will match it.
BrianL wrote: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.htmlmattgoff wrote:You need to match the driver to TM1, so assuming you're running TM1 x64 you need the 64-bit Oracle driver
- 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
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.BrianL wrote: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.htmlmattgoff wrote:You need to match the driver to TM1, so assuming you're running TM1 x64 you need the 64-bit Oracle driver
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
-
- 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
Agreed.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.