TM1 Forum

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

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

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

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

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

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

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

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.

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.