[ckan-dev] CKAN and External Data Sources

[John Jediny - XAAB]

Haven't used/tested this myself but seems relevant per your needs - let us
know how things progress...
https://github.com/transparenzportalhamburg/ckanext-fulltext

On Wed, Jun 22, 2016 at 2:01 PM, Matthew Fullerton <matt.fullerton at gmail.com
> wrote:

> 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
>>
>>
>
> _______________________________________________
> 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
>
>


-- 
Chief Data Engineer
202-341-0191
@Data.gov
@Office of Citizen Science and Innovative Technologies/18F
<http://www.gsa.gov/portal/category/25729>
General Services Administration

Work in the Open... ideate, innovate, iterate...
@github <https://github.com/JJediny> | @projectopendata
<https://github.com/project-open-data>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20160622/857b71f5/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/857b71f5/attachment-0003.png>