Integrate with CKAN

[cphsolutionslab]

I hope this is the right place to "ask for a feature".

I was wondering if it's possible to integrate CartoDB with CKAN (ckan.org)?

We are currently using CKAN as an open data platform at our municipality. We would like to offer a sort of toolbox for working with our data, such as CartoDB.

Our first thought is, that users from our CKAN can login to our own hosted CartoDB and then have all our datasets available for reading. They should be able to create and edit own tables, but not ours.

CartoDB should be integrated so new datasets, edits and deletions from CKAN automatically were replicated or directly fetched from CKAN (perhaps only stored on CKAN for storage savings).

Any thoughts on such add-on?

[peterdesmet]

I'm also interested in CKAN-CartoDB integration.

[acouch]

Think this issue would make more sense in the ckan/ckan issue queue. As far as I can tell CartoDB offers everything on their end to make this available.

FYI I just added CartoDB integration to DKAN https://github.com/NuCivic/dkan_datastore_cartodb

The code might not be very useful for CKAN as they have completely different code bases but the model might be useful to follow (or not to follow).

Basically we replaced the native datastore with CartoDB using the file API: http://blog.cartodb.com/got-files-weve-got-a-import-api/

When a user uploads a resource they have the option of pushing it to CartoDB where it becomes a table. The table then can be queried via the CartoDB SQL API and a user can choose a visualization to represent the resource (replacing the Recline preview).

So in this case the Dataset metadata stays in the catalog and the resource files are represented in CartoDB.

Would be interested to hear if that is the use case you were thinking of.

To do this in CKAN you might want to create a new Service Provider (https://github.com/ckan/ckan-service-provider) similar to the current DataPusher (https://github.com/ckan/datapusher)?

[peterdesmet]

Continued the conversation as a CKAN service provider issue. This issue can be closed.

[javisantana]

cc @iriberri