[ckan-dev] Connecting Ckan to Oracle databases

Mon Sep 7 07:33:27 UTC 2015

Youssef,

As you know, I am searching a solution like you have explained. 

By the way, I was wondering if using the CKAN Geoserver extension could be a solution for what I have to do. I mean, with Geoserver you can publish different schemas from a spatial database. Then, I guess that I could configure a CKAN harvester collecting the information of these tables and adding at the same time some metadata description. In that moment I could get my purpose because I only need to inform which tables I have in my Oracle DB. 

It is only an idea but, could be helpful to our purpose? 

It would be much better to avoid installing Geoserver and its CKAN extension. The best option would be to have another pure CKAN extension for publish tables and views from databases. In my case, It also would be perfect having a webservice giving poll information and updates as number of records created/updated/deleted.

Does anyone another suggestion?

Thank you.

-----Mensaje original-----
De: ckan-dev [mailto:ckan-dev-bounces at lists.okfn.org] En nombre de Ian Ward
Enviado el: miércoles, 02 de septiembre de 2015 23:46
Para: CKAN Development Discussions
Asunto: Re: [ckan-dev] Connecting Ckan to Oracle databases

Hello Youssef,

I'm not aware of extensions that already do what you're asking, but CKAN will let you search any metadata you load.

I have a few questions for you: Do you want to be able to search the contents of larger documents or just descriptions? How many possible results would there be in total? How many different types of records are you searching? Does your web service let you poll for updates (just records created/updated/deleted in a certain time)?

Ian

On Wed, Sep 2, 2015 at 2:38 PM,  <Youssef.Kadri at statcan.gc.ca> wrote:
>
>
> Hello CKANers,
>
> I want to develop an enterprise search solution with CKAN. Is CKAN 
> able to connect to Oracle databases, crawl databases to be indexed and 
> after that searched?
>
> I also have a Web service to access to a database, is it possible with 
> CKAN to consume a Web service and search this database?
>
> If yes, which extensions or plug-ins  are necessary for that?
>
> Any documentation is welcomed.
>
> Thank you.
>
> Youssef
>
>
>
>
>
>
> _______________________________________________
> 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