Has anyone connected TM1 to Workday (Saas) in the Cloud? We are switching from Oracle to workday so I assume an ODBC connection is no longer an option. I would like to keep our drilldown capabilities if possible.
We are on version 10.2
Excel 2010
Windows Server 2008 R2
Thanks
Connection to Workday
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Connection to Workday
If you are not going to have ODBC connectivity to Workday then you won't be able to utilize it for drill-thru in your TM1 cube(s). I wouldn't necessarily assume that you won't have ODBC connectivity. You should ask first.
-
mbeckwith
- Posts: 2
- Joined: Tue Jan 06, 2015 11:02 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: 2010
Re: Connection to Workday
I spoke with the Workday implementation consultant and there is no ODBC connection to Workday. They said I would have to use a webservice to get data.
-
roymathew1
- Posts: 4
- Joined: Mon Mar 18, 2013 3:48 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 10
Re: Connection to Workday
Or have workday sent the data in a csv file and load into the database, in the same format as it existed before. This is what I do for some HCM data (we haven't moved to WD financials as yet):
Workday -> Monthly Report in csv format -> SFTP Server (Workday can place the file here) -> Informatica job -> Database -> TM1
Workday -> Monthly Report in csv format -> SFTP Server (Workday can place the file here) -> Informatica job -> Database -> TM1