Workday integration with GCS

Google Cloud Integration Services
,
1

Hello everyone,

I intended to import all data from the Workday application and store it in the GCS bucket. Since the Workday Integration connector allowed us to access Workday objects as table entities, I used it to connect to Workday. The entity list is now very large, and I can only select one entity at a time when I am developing application integration with this connection. Given the number of entities in a workday, if we follow that path, we may wind up with 10,000 integrations.

Does the connector offer a simpler method for completing this integration, or would another approach also be beneficial?

1 Like
2

Hi @ashish34 ,

Welcome to Google Cloud Community!

Integrating Workday data with GCS:

Challenges:

  • Large number of Workday entities.
  • Selecting individual entities creates too many integrations.

Solutions:

  1. Workday Studio and GCS Connector:
    • Single integration using BOQL for multiple entities.
    • Export data to compatible format (CSV, JSON, Parquet).
    • Use GCS connector or API to transfer files.
  2. Workday Report-as-a-Service (RaaS):
    • Generate report encompassing desired data.
    • Schedule export to designated location.
    • Use Cloud Function or service to upload to GCS.
  3. Third-Party Integration Platform (iPaaS):
    • Pre-built connectors for Workday and GCS.
    • Configure data extraction and mapping to GCS format.
    • Schedule and automate integration process.

Considerations:

  • Data volume and frequency.
  • Technical expertise.
  • Security and compliance.

Choose the optimal solution based on your specific needs.