Workday Reports

Connector Details

Connector AttributesDetails
NameWorkday Report
DescriptionWorkday'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 TypeClass D


Feature NameFeature Details
Load StrategiesFull and Incremental Load
Metadata ExtractionSupported
Data AcquisitionSupported
Data PublishingNot Supported
Automated Schema Drift HandlingSupported

Source Connection Attributes

Connection ParametersData TypeExample
Connection NameStringWorkdayRaaSConnector
Custome Report URLString
Workday RaaS CredentialsStringjdbc-workday-cred-raas (Create Azure key vault as show below)
Bronze Schema (Optional)String
Silver Schema (Optional)String

Connector Specific Configuration Details

  1. Workday connector has optional values such as Bronze Schema and Silver Schema

  2. This connector supports extracting data from workday REPORT tables.

  3. 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<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<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
{"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>" }

  1. More details around this connector

Screenshot To Use Connector