Skip to content
Book a demoStart free
Connectors

Castor EDC connector

Set up the Castor EDC connector in Kaivo: authentication, configuration, the 16 BigQuery tables it syncs, and answers to common questions.

Castor EDC connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Castor EDC data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your data from Castor EDC instead of moving it.

Sync your Castor EDC clinical trial data into BigQuery with Kaivo to analyse study data and form completeness.

CategoryTech
AuthenticationAPI key
SetupSelf-service

Getting started with the Castor EDC connector

Section titled “Getting started with the Castor EDC connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Castor EDC account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Client Secret.

Field Description
Client Secret
Your Castor EDC API Client Secret, shown alongside the Client ID under Account → Settings → Castor EDC API.

|

Prerequisites

Castor EDC uses OAuth client credentials, so you need API credentials from your Castor EDC account:

  1. Sign in to your Castor EDC account, hover over Account and click Settings, then open the Castor EDC API tab.
  2. Generate a new API client and copy the Client ID and Client Secret.

Then enter those values below.

Need help? Reach our team via the chat in the bottom-right corner.

When you set up the connector, you provide:

Field Description
URL Region
The Castor server region where your study is hosted (the subdomain of your Castor URL).

| | Client ID |

Your Castor EDC API Client ID, generated under Account → Settings → Castor EDC API.

| | Start Date |

Any data before this date will not be fetched.

|

Kaivo syncs 16 tables from Castor EDC into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

audit_trial (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date STRING
datetime__date STRING
datetime__timezone STRING
datetime__timezone_type FLOAT64
event_details JSON
event_type STRING
user_email STRING
user_id STRING
user_name STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
country (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
country_cca2 STRING
country_cca3 STRING
country_id STRING
country_name STRING
country_tld STRING
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version STRING
_links__self__href STRING
created_by STRING
created_on STRING
crf_id STRING
domain STRING
expected_centers FLOAT64
expected_records FLOAT64
gcp_enabled BOOL
live BOOL
main_contact STRING
name STRING
premium_support_enabled BOOL
randomization_enabled BOOL
slug STRING
study_id STRING
surveys_enabled BOOL
trial_registry_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_field_dependency (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__self__href STRING
child_id STRING
id FLOAT64
operator STRING
parent_id STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_field_validation (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__self__href STRING
field_id STRING
id FLOAT64
operator STRING
text STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_fieldoption_groups (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__self__href STRING
id STRING
layout BOOL
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: study_fieldoption_groups__options

Section titled “Subtable: study_fieldoption_groups__options”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
group_order FLOAT64
id STRING
name STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_fields (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__self__href STRING
additional_config STRING
exclude_on_data_export BOOL
field_hidden FLOAT64
field_id STRING
field_image STRING
field_info STRING
field_label STRING
field_length FLOAT64
field_max FLOAT64
field_max_label STRING
field_min FLOAT64
field_min_label STRING
field_number FLOAT64
field_required FLOAT64
field_slider_step STRING
field_slider_step_value FLOAT64
field_summary_template STRING
field_type STRING
field_units STRING
field_variable_name STRING
id STRING
parent_id STRING
randomize_option_order BOOL
report_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: study_fields__dependency_children

Section titled “Subtable: study_fields__dependency_children”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: study_fields__dependency_parents

Section titled “Subtable: study_fields__dependency_parents”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_form (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_embedded__visit___links__self__href STRING
_embedded__visit__id STRING
_embedded__visit__visit_id STRING
_embedded__visit__visit_name STRING
_embedded__visit__visit_order FLOAT64
_links__self__href STRING
form_description STRING
form_id STRING
form_name STRING
form_order FLOAT64
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_role (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__self__href STRING
name STRING
permissions__add BOOL
permissions__decrypt BOOL
permissions__delete BOOL
permissions__edit BOOL
permissions__email_addresses BOOL
permissions__encrypt BOOL
permissions__export BOOL
permissions__lock BOOL
permissions__query BOOL
permissions__randomization_read BOOL
permissions__randomization_write BOOL
permissions__sdv BOOL
permissions__sign BOOL
permissions__survey_send BOOL
permissions__survey_view BOOL
permissions__view BOOL
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_site (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__self__href STRING
abbreviation STRING
code STRING
country_id FLOAT64
date_format STRING
deleted BOOL
id STRING
name STRING
order FLOAT64
site_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_statistics (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__self__href STRING
records__total_count FLOAT64
study_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: study_statistics__records__institutes

Section titled “Subtable: study_statistics__records__institutes”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
institute_id STRING
institute_name STRING
record_count FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_survey (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__self__href STRING
id STRING
intro_text STRING
name STRING
outro_text STRING
survey_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_survey_package (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__self__href STRING
allow_open_survey_link BOOL
allow_step_navigation BOOL
as_needed BOOL
auto_lock_on_finish BOOL
auto_send BOOL
default_invitation STRING
default_invitation_subject STRING
field_pagination STRING
finish_url STRING
id STRING
intro_text STRING
is_mobile BOOL
is_repeatable BOOL
is_resumable BOOL
is_training BOOL
name STRING
outro_text STRING
sender_email STRING
sender_name STRING
show_step_navigator BOOL
survey_package_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: study_survey_package___embedded__surveys

Section titled “Subtable: study_survey_package___embedded__surveys”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__self__href STRING
id STRING
intro_text STRING
name STRING
outro_text STRING
survey_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: study_survey_package___embedded__surveys__survey_forms

Section titled “Subtable: study_survey_package___embedded__surveys__survey_forms”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_user (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__self__href STRING
email_address STRING
entity_id STRING
full_name STRING
id STRING
last_login STRING
manage_permissions__manage_encryption BOOL
manage_permissions__manage_form BOOL
manage_permissions__manage_records BOOL
manage_permissions__manage_settings BOOL
manage_permissions__manage_users BOOL
name_first STRING
name_last STRING
user_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
role_id FLOAT64
role_name STRING
site_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
study_visit (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__self__href STRING
id STRING
visit_id STRING
visit_name STRING
visit_order FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
user (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__self__href STRING
email_address STRING
entity_id STRING
full_name STRING
id STRING
last_login STRING
name_first STRING
name_last STRING
user_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Castor EDC supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Castor EDC?

Section titled “How long does the initial sync take for Castor EDC?”

It depends on how much history is in your Castor EDC account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Castor EDC’s schema changes?

Section titled “What happens when Castor EDC’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Castor EDC, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Castor EDC instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Castor EDC connector in Kaivo and all of its synced data is deleted with it.

Use study_fields and study_form to find missing or incomplete records across sites.

Join study_site with study_statistics to compare data collection across sites.

Use audit_trial to track changes to study data over time.

Use Castor EDC data in your AI and BI tools

Section titled “Use Castor EDC data in your AI and BI tools”

Once Castor EDC data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Castor EDC data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Castor EDC connector pricing and plan details.

  • Adform: Sync Adform to BigQuery.
  • Amplitude: Sync Amplitude to BigQuery.
  • Auth0: Sync Auth0 to BigQuery.
  • Convex: Sync Convex to BigQuery.
  • GitHub: Sync GitHub to BigQuery.
  • GitLab: Sync GitLab to BigQuery.