Workday integration with GCS

[ashish34]

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?

[christianpaula]

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.