Skip to main content
Administrator Guide
Last Updated: 2026-10-30
App Source Connections

App Source Connections

You can create app sources to import data into Prism Analytics tables from external platforms and Workday custom reports. App sources provide a standardized, reusable framework to efficiently import data into Prism Analytics tables.
Partners can incorporate app sources into their BoW application design to ingest and map external data into target Prism tables.
When you initiate a data transfer using an app source, Workday:
  • Connects to Amazon S3, SFTP servers, or Workday custom reports using the access credentials configured in the connection.
  • Retrieves the data defined in the app source.
  • Loads data directly into the target Prism Analytics table through the
    Tables Materialize REST
    API.
You create and maintain app sources using the
Manage App Sources
task in Prism. All app sources define how to access and retrieve data from a specific source, ensuring that the schema of the app source aligns directly with the target Prism table schema.
Source Type
Description
Amazon S3 (Simple Storage Service)
  • Defines a specific bucket in an Amazon S3 region.
  • Defines the AWS access keys or Identity and Access Management (IAM) credentials needed to authenticate with Amazon, access the S3 bucket, and pull CSV or compressed file exports.
  • Enables transferring large datasets efficiently into Prism Analytics target tables.
You must tag the AWS Identify and Access Management (IAM) user with the key
workday-type
and the value
integration
. Do not include whitespaces, and ensure exact capitalization as these values are case-sensitive.
SFTP
  • Defines how to connect to and authenticate against an external SFTP server.
  • Defines the specific files to retrieve from the server for data ingestion into Prism Analytics target tables.
You can connect to an SFTP server using 1 of these authentication methods:
  • User name and password.
  • SSH key authentication.
Workday Custom Report
  • Connects to internal Workday custom reports to retrieve operational data for Prism Analytics use.
  • Provides an alternative to manual UI exports by using Prism tasks to automate data transfers from custom reports.
  • Enables automatic schema mapping and enables Workday Orchestrate workflows to initiate data transfers using custom API names.