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.
Connectiors for PeopleSoft?
-
skschelske
- Posts: 1
- Joined: Mon Dec 31, 2012 1:25 pm
- OLAP Product: TM1
- Version: Unknown
- Excel Version: Excel 2003
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Connectiors for PeopleSoft?
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.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.
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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
Michel Zijlema
- Site Admin
- Posts: 713
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: Connectiors for PeopleSoft?
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
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