TM1 Forum

I am wondering if there are any pre-built, delivered connectors for TM1 to interface directly with PeopleSoft Financials. I worked briefly on an Oracle OBIEE project and OBIEE had this type of connector. If not, is the "best way" (subjective of course) to create an extract of the required data from PeopleSoft and make that available to TM1?

I've searched around some, but don't see anything similar for TM1, so I thought I'd ask here.

thanks in advance.

skschelske wrote:I am wondering if there are any pre-built, delivered connectors for TM1 to interface directly with PeopleSoft Financials. I worked briefly on an Oracle OBIEE project and OBIEE had this type of connector. If not, is the "best way" (subjective of course) to create an extract of the required data from PeopleSoft and make that available to TM1?

I've searched around some, but don't see anything similar for TM1, so I thought I'd ask here.

thanks in advance.

Depends on the underlying database that PeopleSoft is running on. In my case it was SQL Server and we just used a standard ODBC connection to read data from the tables. Log in to SQL Server, run the queries, grab the data.

In the previous version it was running on DB2-saurus, and we did essentially the same thing though if I recall correctly it took some additional custom drivers.

AFAIK there is no specific connector / connection tempate available for connecting TM1 to Oracle Financials.
Like Alan I've used an ODBC connection to the database (Oracle) to update dimension structures and upload data from Oracle Financials. I also have customers where I use flat files generated from standard reports and upload these into TM1 cubes.

Michel