CKAN Connector
Connect to CKAN-based open data portals worldwide
Ready to Simplify Your Work?
Install your first app in 30 seconds. No credit card required.
We use essential cookies for security and access. Optional cookies stay off unless you choose them, and embedded dashboards run in essential-only mode.
Install your first app in 30 seconds. No credit card required.
Add Portal: Enter the CKAN portal URL (e.g., data.gov, open.canada.ca)
Browse Datasets: Search and explore available datasets
Select Resources: Choose specific files from multi-resource datasets
Map Schema: Preview field mapping before syncing
Schedule Sync: Set up automatic data refresh
Connect to any CKAN portal including:
Government Data — : Data.gov, Open Canada, Data.gov.uk, EU Open Data Portal
City Portals — : NYC Open Data, City of Toronto, Melbourne, Paris
Regional — : State and provincial government portals
International — : UN, World Bank, OECD data portals
The connector uses a 5-level detection strategy:
CKAN DataStore: Uses the portal's built-in data API when available
Resource Metadata: Reads field info from CKAN's metadata
Sample Analysis: Analyzes data samples to infer types
Header Detection: Identifies column headers automatically
Backup Inference: Smart type guessing for edge cases
CKAN datasets often have multiple files:
Resource List — : See all files in a dataset (CSV, Excel, JSON, etc.)
Format Filtering — : Focus on the formats you need
Individual Selection — : Choose exactly which resources to sync
Preview Each — : See what's in each file before connecting
Structured — : CSV, Excel (XLSX/XLS), JSON, XML
Geospatial — : GeoJSON, Shapefile, KML
Documents — : PDF, HTML (metadata extraction)
Scheduled Refresh — : Daily, weekly, or custom intervals
Manual Trigger — : Sync on demand anytime
Incremental Updates — : Only fetch changed data when possible
Error Recovery — : Automatic retry with backoff
Government agencies accessing other jurisdictions' data
Researchers combining datasets from multiple sources
Journalists investigating public data
Analysts building cross-portal dashboards




Integrations
Integrations