Connector Details

Connector Attributes	Details
Name	Workday Report
Description	Workday's RaaS (Reporting as a Service) provides organizations with access to valuable data insights and analytics, leveraging the comprehensive dataset stored within the Workday platform. With RaaS as a data source, organizations can extract and analyze data related to human resources, finance, payroll, and more, enabling informed decision-making and strategic planning. Workday's RaaS empowers users to create customized reports, dashboards, and visualizations tailored to their specific business needs, helping drive efficiency, productivity, and performance across the organization. By leveraging RaaS, organizations can unlock the full potential of their Workday data, gaining actionable insights that drive business growth and success.
Connector Type	Class D

Features

Feature Name	Feature Details
Load Strategies	Full and Incremental Load
Metadata Extraction	Supported
Data Acquisition	Supported
Data Publishing	Not Supported
Automated Schema Drift Handling	Supported

Source Connection Attributes

Connection Parameters	Data Type	Example
Connection Name	String	WorkdayRaaSConnector
Tenant	String	your-tenant-name
Host	String	your-workday-host.com
Custome Report URL	String	https://your-workday-host.com/custom-report
Workday RaaS Credentials	String	jdbc-workday-cred-raas (Create Azure key vault as show below)
Bronze Schema (Optional)	String
Silver Schema (Optional)	String

Connector Specific Configuration Details

Workday connector has optional values such as Bronze Schema and Silver Schema
This connector supports extracting data from workday REPORT tables.
To access workday REPROT tables, we need additional parameters and create KV secret (jdbc-workday-cred-raas) in the format shown below
1. custom_report_url : URL where we find the required reports ( Object list ) , for example https://services1.myworkday.com/ccx/service/customreport2/<Client/ISU_PowerBI/Reports_as_a_Service
2. oauth_client_id : This is the Client ID for Oauth account
3. oauth_client_secret : This is the Client Secret for the Oauth Secret
4. oauth_token_url : This is the URL to generate the Oauth token for example https://services1.myworkday.com/ccx/oauth2/<Client/token
5. oauth_authorization_token : This is Oauth authorization token
6. oauth_refresh_token : This is the Oauth refresh token

 keyvault secret value format to access workday Report tables:  
{ "tenant": "<Insert_tenant_id>", "host": "<Insert_hostname>", "custom_report_url": "<Report_url>", "workday_raas_cred":"jdbc-workday-cred-raas"}

Create KeyVault secret with this name and format
jdbc-workday-cred-raas:
{"oauth_client_id": "<oauth_client_id>", "oauth_client_secret":"<oauth_client_secret>", "oauth_token_url": "<token_url>", "oauth_authorization_token": "<oauth_token>", "oauth_refresh_token": "<oauth_refresh_token>" }

Screenshot To Use Connector