Page 1 of 1
Connection to Workday
Posted: Thu Jan 08, 2015 7:55 pm
by mbeckwith
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
Re: Connection to Workday
Posted: Fri Jan 09, 2015 2:41 am
by tomok
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.
Re: Connection to Workday
Posted: Mon Jan 12, 2015 3:42 pm
by mbeckwith
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.
Re: Connection to Workday
Posted: Wed Aug 12, 2015 4:33 pm
by roymathew1
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