[ckan-discuss] RDBMS Data Source

[Rufus Pollock]

On 19 March 2012 00:47, Haq, Salman <Salman.Haq at neustar.biz> wrote:
> Hi,
>
> I hope this is the right forum for this question:
>
> Currently CKAN supports three types of data sources: CSV/Excel file upload,
> hyperlink to API, hyperlink to CSV/Excel file.
>
> Is there a plugin that supports a relational database as fourth type of data
> source?

No, but it's a really interesting idea. You'd be wanting to add to
this extension:

<https://github.com/okfn/ckanext-datastorer>

Specifically (I think):

https://github.com/okfn/ckanext-datastorer/blob/master/ckanext/datastorer/tasks.py#L86

@David (Raznick): any thoughts on this?

> Such a plugin could be provided a username/password combination to connect
> to the server and extract metadata information automatically. Pyodbc or
> SQLAlchemy could be used for implementing this.

Indeed. The issue here is how to provide the username / password info ...

Rufus