TM1 Forum

Posted: **Mon Oct 12, 2009 11:27 am**

Hi All,

TM1 Perspectives 9.4.1 FP2
Excel 2007

Has anyone ever tried to connect to Pastel via TI?

I am trying this because Pastel will be my data source for a TM1 application.

Thanx people!

Posted: **Mon Oct 12, 2009 1:07 pm**

Googling around there are ODBC drivers for Pastel, so you should be able to connect that way. If not, get a flat file out and read that in.

Posted: **Fri Oct 16, 2009 8:06 pm**

I figured it out! Actually it is quite easy. Connect through ODBC to the relevant Pastel Data Source and there you go!

Create a sql query to extract the relevant data and you are good to go.

Tip: Use Excel to connect first and generate the query and just copy it in.

TM1 Forum

Connecting to Pastel Partner

Connecting to Pastel Partner

Re: Connecting to Pastel Partner

Re: Connecting to Pastel Partner