These CKAN Versions are exactely matched:

• 2.10.0
• 2.10.1
• 2.10.2
• 2.10.3
• 2.10.4
• 2.10.5
• 2.10.6
• 2.10.7
• 2.10.8
• 2.10.9
• 2.11.0
• 2.11.1
• 2.11.2
• 2.11.3
• 2.11.4
• 2.12.0
• 2.2
• 2.2.1
• 2.2.2
• 2.2.3
• 2.2.4
• 2.3
• 2.3.1
• 2.3.2
• 2.3.3
• 2.3.4
• 2.3.5
• 2.4.0
• 2.4.1
• 2.4.2
• 2.4.3
• 2.4.4
• 2.4.5
• 2.4.6
• 2.4.7
• 2.4.8
• 2.4.9
• 2.5.0
• 2.5.1
• 2.5.2
• 2.5.3
• 2.5.4
• 2.5.5
• 2.5.6
• 2.5.7
• 2.5.8
• 2.5.9
• 2.6.0
• 2.6.1
• 2.6.2
• 2.6.3
• 2.6.4
• 2.6.5
• 2.6.6
• 2.6.7
• 2.6.8
• 2.6.9
• 2.7.0
• 2.7.1
• 2.7.10
• 2.7.11
• 2.7.12
• 2.7.2
• 2.7.3
• 2.7.4
• 2.7.5
• 2.7.6
• 2.7.7
• 2.7.8
• 2.7.9
• 2.8.0
• 2.8.1
• 2.8.10
• 2.8.11
• 2.8.12
• 2.8.2
• 2.8.3
• 2.8.4
• 2.8.5
• 2.8.6
• 2.8.7
• 2.8.8
• 2.8.9
• 2.9.0
• 2.9.0a
• 2.9.1
• 2.9.10
• 2.9.11
• 2.9.13
• 2.9.2
• 2.9.3
• 2.9.4
• 2.9.5
• 2.9.6
• 2.9.7
• 2.9.8
• 2.9.9

ckanext-dataproxy

ckanext-dataproxy is a CKAN extension that enables previewing data from remote databases via SQLAlchemy. The extension is compatible with datastore by masking the dataproxy resource as a datastore resource so it could be requested via /api/3/action/datastore_search or previewed in-browser with recline-preview.

This allows CKAN to use foreign data wrappers as a source for the datastore.

Installation

NB! This module is developed for CKAN v2.2.x and v2.5.x, compatibility with other versions is not ensured.

1. Clone the repository:

cd /usr/lib/ckan/default/src
git clone https://github.com/cphsolutionslab/ckanext-dataproxy.git
cd ckanext-dataproxy

2. Activate your virtual environment:

. /usr/lib/ckan/bin/activate

3. Install requirements (It is not required to install drivers for databases you don’t plan to proxy):

pip install -r requirements.txt

Additional packages may be required to compile the database-specific drivers. For Ubuntu:

sudo apt-get install build-essential libmysqlclient-dev freetds-dev

4. Install the plugin:

python setup.py develop

5. Set the dataproxy secret in your CKAN settings file (e.g. /etc/ckan/default/production.ini):

ckan.dataproxy.secret = c9f56fdfd12ee615f3d858...  # Use a random secret

Generate a random secret:

echo "import hashlib ; from uuid import uuid4 ; print hashlib.sha256(str(uuid4())).hexdigest()" | python -

Enable on CKAN 2.2.x

Enable the extension by appending dataproxy to ckan.plugins:

ckan.plugins = stats text_preview ... dataproxy

Enable on CKAN 2.5.x

Enable the extension by appending dataproxy and dataproxy_view to ckan.plugins:

ckan.plugins = stats text_preview ... dataproxy dataproxy_view

Then append dataproxy_view to ckan.views.default_views:

ckan.views.default_views = image_view ... dataproxy_view

Usage

See the wiki for detailed usage instructions: - Usage with CKAN 2.2.x - Usage with CKAN 2.5.x