[ckan-dev] CKAN and External Data Sources

[Matthew Fullerton]

Dear Bill,
I can only say that I've done a lot of work in this area, all of it
unfinished, and I personally would be thrilled if you got something like
this working reliably.

Best,
Matt

On 22 June 2016 at 18:40, Frischling, Bill <BFrischling at usnews.com> wrote:

> Hi Everyone…
>
> New convert to CKAN. We’re testing it to help us better leverage our
> internal data.
>
> We’re working on adapting fadein.dk’s dataproxy (
> http://extensions.ckan.org/extension/dataproxy/) to be able to to:
>
>    - Read/display Mysql data (initial)
>    - “Marry” the database to CKAN so it becomes like an internal data
>    store (next step… CKAN and the databases would be in the same internal VPC).
>
> Based on the documentation, it appears CKAN is actively moving away from
> remote data (after this, we want to look at a similar approach to merge ETL
> of json/xml into the CKAN view). We’ve identified where in the code we need
> to adapt to permit this remote access (remote to CKAN, in the same cloud),
> but if we’re going down a cul-de-sac, better to know now.
>
> My question: are we going down a bad road and if so, is there a way others
> would recommend to achieve the end goal, which would be to make our
> existing internal databases visible to our reporters via CKAN without
> wholesale migration. Nearly everything we have internal is MySQL/Postgres
> and the CKAN interface is simple, elegant, useful, and has the added
> benefit of adding a generic API to quickly let our reporters plug into our
> CMS to generate charts/graphs, etc.
>
> Any guidance would be appreciated. And we plan to open source the plug-in
> adaptation once we’re done testing. Thank you.
>
>
> *Bill Frischling *Vice President / Entrepreneur-in-Residence
> P: +1 202 955 2631 ? C: +1 703 623 1424
> bfrischling at usnews.com
> *[image: Title: U.S. News and World Report]*
>
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20160622/6546aab2/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 62B99093-AB62-431C-A8A6-2E0449677F22[20].png
Type: image/png
Size: 6442 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20160622/6546aab2/attachment-0003.png>