Employee Data Hub - How to sync data between Workday, Okta and Oracle database
Employee data hub is a critical system that requires reliable and robust sync between several HRIS, IDP, Payroll, and a central data hub. Learn how to build this system with Workato, Okta and Oracle.
👉🏻 Video Summary 👈🏻
⏺ Source Data:
→ Workday (employee information), Okta (identity and provisioning data), Qualtrics (exit/pulse surveys);
→ JSON file - benefits data
→ Daily load; scheduled run at 11:00 PM ; 500-1000 rows
⏺ OPA and OPG:
→ Multiple OPAs for higher throughput, LB, FT
⏺ Target/Destination:
→ Oracle Database
→ Multiple tables: Employee_Master, Employee_Apps, Employee_Surveys
→ Include audit fields i.e. batch identifier, created by, created_date
⏺ Transformations:
→ Data validation checks e.g. checksum for rows fetched vs rows loaded; Filesize checks
→ Pre-packaged transformations for name, email, address validation; check for presence of mandatory fields
Got suggestions for topics? Leave your comment down below or drop us a note at [email protected]
⚫️ Access the full Workato Documentation here:
https://docs.workato.com/
⚫️ Read our product blog to find out how you can get more out of Workato:
https://www.workato.com/product-hub/
⚫️ Sign up for our webinars:
https://discover.workato.com/events-w...
⚫️ Learn from our on-demand courses:
https://academy.workato.com/
Find #Workato everywhere!
► Website: www.workato.com
► LinkedIn: / workato
► Twitter: / workato
► Facebook: / workato
► Instagram: https://www.instagram.com/workatohq/?...
► Medium: / workato
Subscribe to our channel here:
/ workato
#Workato #tutorials #employeedatahub #datasync #okta #oracle
About Workato:
Workato, a leader in Forrester Wave iPaaS and a Gartner Cool Vendor, is the only integration platform that is enterprise-grade yet easy to use enabling IT and business users to integrate all their apps, databases, APIs and automate their business workflows. Workato is the fabric with which you can weave a very intelligent nervous system for your modern enterprise.