What is OneCloud?
Automating the Workday | BlackLine Financial Close
OneCloud is a modern iPaaS technology that provides intuitive integration, data transformation, and automation for a wide range of Performance Management (EPM), Business Intelligence (BI), Systems of Record (SoR), and other business-critical applications, that reside on-premises and in the cloud.
A manual process was performed, twice, daily, that included manual downloads from Workday, Excel-based transformation using pivot tables and a manual upload into BlackLine.
The following data were extracted from Workday for loading into BlackLine:
Workday GL Account Balance
Workday GL Account Balance in USD
Workday Canceled Journals
Workday Currency Rates
"With OneCloud, we achieved significant monthly time savings. The automated close process provides us with near real time data which results is faster close times."
Sr. Financial Systems Solutions Manager, e-commerce website.
©2020 OneCloud, Inc | www.onecloud.io
This use case focuses on the ability of OneCloud to fully automate and integrate Workday Financials data, including balances, journals and currency rates, into BlackLine.
Automating A Financial Close Process
Are you looking for a fast, secure, and scalable method to integrate Workday with BlackLine? OneCloud allows you to fully automate & integrate Workday data, including balances, journals and currency rates, into BlackLine. This results in significant monthly time savings, near real time data access, and faster close time.
Workday <> BlackLine Use Case
Step 1: Extract Workday GL Balances & Journals and load to BlackLine
Extract data from Workday
- GL balances
- Canceled journals
Activity in period
Blend GL balances and USD
Blend GL balances and JE
OneCloud has out-of-the-box native and secure integration with Workday and BlackLine.
OneCloud has built-in transformation equivalent to Excel’s pivot table.
OneCloud leverages both Workday’s and BlackLine’s provisioned service account without relying on an individual account.
Scheduled and automated processes, results in a higher frequency of refreshes into BlackLine and near real-time data.
Extra features include notification and error-handling
Workday extract formats need to be transformed and subtotaled into a BlackLine’s Account object load format. The new process needs to automated, secure, near real time, and maintainable by the business users.
Extract currency from Workday
Map headers for final output
Currency upload into BlackLine
Technical data subject to modification and delivery subject to availability. Any liability that the data and illustrations are complete, actual or correct is excluded. Designations may be trademarks and/or copyrights of the respective company, the use of which by third parties for their own purposes may infringe the rights of such owner.
Step 2: Extract currency rates from Workday and load to BlackLine’s currency object without any inline transformation.
Fully automated and scheduled data transformation and loads.
Significant monthly time savings. Near real time data access and faster close time.
Auditable to see who ran what, where, when, and how. Scalable solution allowing easy integration with additional technologies.
Short implementation time (~20 Hours)
Intuitive UI and fast learning curve
Stay up to date
tel: +1 212 749 2220
Anaplan Use Case Examples