Connect TM1 to SAS DW

[nimol]

Has anybody tried to connect TM1 9.5.2 to a SAS DW. As far as I can see it's not supported, but sharing any experience on using for example ODBC is appreciated.

[Michel Zijlema]

Has anybody tried to connect TM1 9.5.2 to a SAS DW. As far as I can see it's not supported, but sharing any experience on using for example ODBC is appreciated.

Hi nimol,

I have a customer connecting from TM1 (64-bit 9.1.3) to SAS DW. This connection is using the ODBC Gateway service that is no longer available from TM1 9.4 onwards.
Linking from TM1 9.5.2 is possible only if you run a 32-bit version of TM1, as there is not yet a 64-bit ODBC driver for SAS DW available. As I understand this 64-bit driver will become available with he next SAS DW release.

Michel

[nimol]

Thanks Michel for your reply.

I found this at SAS homepage so I guess that would work with 64-bit version:
http://support.sas.com/software/product ... index.html

News about SAS ODBC Drivers
64-Bit Driver for Windows x64
The December 2011 release of SAS 9.3 includes a 64-bit driver for Windows x64 operating environments. Now, 64-bit ODBC-compliant applications can use SAS Drivers for ODBC in native mode. The 64-bit driver does not support connections to the SAS Scalable Performance Data (SPD) Server.



--------------------------------------------------------------------------------

[SimonLAylett]

Bump for this.

I'm using 9.5.2 and am running multiple TI's on top of a .csv file, which in turn is output from a SAS query.

I'm exploring the possibility of directly querying the DW using the same SAS code via the ODBC link.

Possible? Easy? do I just need access to the relevant ODBC link and the SAS code?

Any advice appreciated.