Data from TM1 to DWH

[TM1ethusiast]

I need to write a process which should push the Data form TM1 to Data Warehouse.Has anybody done this before?Thanks a lot

[lotsaram]

ODBCINSERT

[Wim Gielis]

Hello Lotsaram

Just stepping in on this one.
Can you link me/us to more information on this function?
Don't think I used that function before.

Thanks,

Wim

[qml]

Probably better to stick to the more traditional* ODBCOutput function.
















* i.e. non-imaginary

[TM1ethusiast]

I will explain my requirement again,there are two file which are generated monthly from other source systems and we process the data loading in TM1,now what we want to do is after processing the data load ,TM1 should push same data in to EDW without any modification.Your help will be greatly appreciated.Thanks

[David Usherwood]

Write a TI using the ODBCOUTPUT function.
Despite the name, this doesn't actually output to an ODBC data source, but executes a line of SQL whic you need to build from your content - something on the lines of (say)

Code: Select all

odbcoutput(<dsn>,
'insert into some_table values(''' |
  account |
  ''',''' |
  dept |
  ''',' |
  value |
  ')' 
  );

As you can imagine this isn't fun to debug. I replace odbcoutput(<dsn>, by asciioutput(file, and look at how the SQL is building up.
You may find writing a flat file and using bcp to be less painful and probably faster.

[lotsaram]

Probably better to stick to the more traditional* ODBCOutput function.

* i.e. non-imaginary

ROTFLMAO