How It Works
1
Add Portal: Enter the CKAN portal URL (e.g., data.gov, open.canada.ca)
2
Browse Datasets: Search and explore available datasets
3
Select Resources: Choose specific files from multi-resource datasets
4
Map Schema: Preview field mapping before syncing
5
Schedule Sync: Set up automatic data refresh
Supported Portals
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
Smart Schema Detection
The connector uses a 5-level detection strategy:
1
CKAN DataStore: Uses the portal's built-in data API when available
2
Resource Metadata: Reads field info from CKAN's metadata
3
Sample Analysis: Analyzes data samples to infer types
4
Header Detection: Identifies column headers automatically
5
Backup Inference: Smart type guessing for edge cases
Multi-Resource Handling
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
Data Formats Supported
Structured — : CSV, Excel (XLSX/XLS), JSON, XML
Geospatial — : GeoJSON, Shapefile, KML
Documents — : PDF, HTML (metadata extraction)
Sync Features
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
Perfect For
Government agencies accessing other jurisdictions' data
Researchers combining datasets from multiple sources
Journalists investigating public data
Analysts building cross-portal dashboards
Screenshots
Integrations
CKAN Connector works great with
Integrations
More Integrations apps
Ready to Simplify Your Work?
Install your first app in 30 seconds. No credit card required.