Best Practices

Recommended setup

Always set your URL region

Castor EDC runs three separate regional instances (UK, NL, US). If you pick the wrong region, your credentials won't work — even if they're correct. Double-check your region in Castor EDC account settings before connecting.

Set a meaningful start date for audit trails

Audit trail entities can contain thousands of rows in active studies. Use the date picker to set a start date that matches when you actually need data from — this keeps your first run fast and your destination clean.

Use separate data flows for structural vs. activity data

Entities like study fields, forms, and field validations change infrequently and describe your study design. Entities like study visits and audit trails change constantly. Keeping them in separate data flows lets you refresh each at the right cadence.

Data refresh and scheduling

Refresh audit trails more frequently than structural data

Audit trail records accumulate with every user action. If compliance reporting is a priority, schedule this entity to refresh daily or more often. Study forms and field definitions rarely change and can be refreshed weekly.

Run a manual sync first to confirm data volume

Before setting a schedule, run the data flow manually and check how many rows come back. For large studies with long histories, you may want to narrow the start date to keep export times reasonable.

Performance optimization

Join study users with study roles

Exporting these two entities separately and then joining them in Coupler.io gives you a complete access matrix — who is in each study and what they're permitted to do — without needing to cross-reference in a spreadsheet manually.

Aggregate study statistics across multiple studies

If your organization runs multiple concurrent studies, use Coupler.io's Aggregate transformation to combine study statistics into a single summary table for leadership reporting.

Send study progress data to AI destinations for narrative summaries

Pipe study statistics and visit data to Claude, ChatGPT, or Gemini to generate plain-language progress summaries — useful for non-technical stakeholders who don't read raw data tables.

Common pitfalls

Do not leave the start date blank on your first run if you're exporting audit trails from a study that has been running for more than a few months. Pulling the entire audit history at once can time out or generate an overwhelming number of rows.

Do

• Match your URL region exactly to your Castor EDC account registration
• Set a start date for high-volume entities like audit trails
• Use Join to link study fields with their validations and dependencies
• Verify your user role has read access to all studies before running

Don't

• Export study field dependencies or validations if your studies don't use conditional logic — they'll always be empty
• Run multiple Castor EDC data flows at the same time — stagger them to avoid hitting API rate limits
• Assume study statistics in your export match the live dashboard — they reflect the snapshot at time of sync