ODBC Output

[dharav]

Hello All

I have to export the TM1 cube data in to SQL table for validation purpose. I utilized ODBC Output concept in my TI process to achieve the target. It runs successfully and data successfully transferred in to database.

Here is MY TI process:

ODBCOUTPUT.txt

(1.56 KiB) Downloaded 314 times

Points to discuss:

1) It took almost 8 min to transfer data. data size is small. 900,000 data values approx. What could be the reason behind this?

2) In my TI process: First, i am deleting all rows and then inserting all new rows from TM1 database. I have to do this zero out process in SQL to eliminate duplicate transaction. is there better way of doing this?


Thanks

Dharav

[jim wood]

If you do a search on this forum, you'll find a discussion on whether to use ODBC Output. The general opinion was that it is only useful for very small data sets. When I say small I mean setting flags and that kind of thing. I think every person that posted mentioned that they exported any kind of data set to a flat file and loaded it in to the DB from there,

Jim.

[dharav]

Got it and implemented

Thank you Jim