About Using Workflows Tasks to Build ETL Workflows
The Qualtrics Workflows platform contains a series of tasks to assist in importing data from third-party destinations into Qualtrics or exporting data from Qualtrics to third-party destinations. These tasks follow the Extract, Transform, Load (ETL) framework. Using ETL tasks, you can create automated and scheduled workflows to bring data from third-party sources into Qualtrics as well as export data from Qualtrics to third-party destinations.
To create an ETL Workflow, you must create one or more extractor tasks and exactly one loader task. If you are looking to load data into multiple destinations, you should create separate workflows for each destination.
General Setup for Extractor and Loader Tasks
- From the Workflows page, create a new scheduled or event-based workflow. This workflow will trigger based on the criteria you set.
- The first task of your workflow should be your data extractor task. These tasks import data from an external source to Qualtrics. See available extractor tasks for more information about each available task
- The second task of your workflow should be your data loader task. These tasks tell Qualtrics where to save your imported data. See available loader tasks for more information.
- This step is optional, but useful for alerting you if something goes wrong. Use workflows notifications to get notified if the workflow ever fails.
Available Extractor Tasks
At this time, the following tasks are available for importing data into Qualtrics:
- Extract data from SFTP files task: Extract data from your SFTP server and import it into Qualtrics.
- Extract data from Salesforce task: Extract data from your Salesforce instance and import it into Qualtrics.
- Extract data from SuccessFactors task: Extract data from your SuccessFactors instance and import it into Qualtrics.
Available Loader Tasks
At this time, the following tasks are available for loading data into Qualtrics:
Troubleshooting Data Extracting and Loading Tasks
Data extractor and loader tasks must be used together. If you are missing a piece of their setup, the workflows editor will alert you.
If your tasks are failing or not firing properly, the first place you should look is Workflows reporting & history. This will contain information about every time your workflow fired and the results of that workflow.
In reporting & history, each piece of your workflow will have its own entry, making it easy to pinpoint where things went wrong.
After identifying the problem, you can click View under Details to see more information to help you diagnose how to fix the problem. This will pull up the JSON payload for the task. Scroll down to the Task Output section to find any errors.
Specific Use Cases
Check out the following pages for specific use cases and workflow setups.
- Account Management Command Center (CX): Import account data from Salesforce and save that data in your XM Directory to help understand your customer relationships.