The REDCap-ETL (Extract Transform Load) external module:
- Extracts data from REDCap
- Transforms the extracted data based on user-specified transformation rules
- Loads the transformed data into a database
REDCap-ETL supports:
- running ETL processes on demand
- scheduling ETL processes to run automatically on a daily or weekly basis
To use REDCap-ETL on a project, you need the following:
- Project Design and Setup Permission. In general, you need this REDCap user right to access external modules for a project, and it is also required for REDCap-ETL.
- Data Export Permission. REDCap "Data Exports" user right of "Full Data Set" for the project.
- No Data Access Group (DAG). You need to have access to all of the project's fields, so you cannot belong to a DAG.
- REDCap API Token. REDCap-ETL uses the REDCap API (Application Programming Interface) to extract data from REDCap, so you need to have a REDCap API token for the project with export permission. You can either use your own API token, or select the API token of another of the project's users who has "Full Data Set" export rights and is not in a data access group. To be able to request an API token with export permission, you need to have the REDCap user right "API Export".
- MySQL Database Account. An account for a MySQL database where the data can be loaded. The account has to
have at least the following permissions:
- SELECT
- INSERT
- CREATE
- DROP
- CREATE VIEW