Data source for TI Process.

[jbcraigs]

We want to use TI to pull in data from DB2.

What would be a better source in terms of performance,
1. ODBC
or
2. C10 Framework Package(this would probably use DB2 client)?

Any other factors that would influence this choice besides performance?

Thanks.

[rkaif]

Use ODBC to connect to DB2

[tomok]

We want to use TI to pull in data from DB2.

What would be a better source in terms of performance,
1. ODBC
or
2. C10 Framework Package(this would probably use DB2 client)?

Any other factors that would influence this choice besides performance?

Thanks.

if you go the ODBC route (which is the one I recommend too) the TM1 server is going to have to be able to connect to DB2 in order for it to work. This means you'll probably have to install the DB2 client on the TM1 box. I haven't worked with DB2 in a few years but that's what I had to do the last time I used it as a data source.

[jbcraigs]

Thanks for response. But on other forums I read that using Framework Manager package might provide better performance as compared to ODBC connection. Has anyone actually compared the performance while loading large data volumes?

Thanks again.

[David Usherwood]

TM1's support for FM as a data source is very new and for SAP BW at least there are postings suggesting issues. I can't see why introducing an additional layer into the mix would be faster, unless the FM route uses some kind of better eg native driver. Remember that TI is ETL ie the results are stored within TM1, so your user isn't going all the way back to DB2 for the data on their reports.