TM1 Forum

Posted: **Tue Mar 19, 2013 1:33 pm**

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

Posted: **Tue Mar 19, 2013 2:12 pm**

ODBCINSERT

Posted: **Tue Mar 19, 2013 2:32 pm**

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

Posted: **Tue Mar 19, 2013 3:25 pm**

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

* i.e. non-imaginary

Posted: **Tue Mar 19, 2013 3:42 pm**

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

Posted: **Tue Mar 19, 2013 3:56 pm**

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.

Posted: **Tue Mar 19, 2013 5:44 pm**

qml wrote:Probably better to stick to the more traditional* ODBCOutput function.

* i.e. non-imaginary

ROTFLMAO

TM1 Forum

Data from TM1 to DWH

Data from TM1 to DWH

Re: Data from TM1 to DWH

Re: Data from TM1 to DWH

Re: Data from TM1 to DWH

Re: Data from TM1 to DWH

Re: Data from TM1 to DWH

Re: Data from TM1 to DWH