Data sources define which data is available to visualize in Akuko. These are used to power the map layers, table, charts and other data components used in Akuko posts. It is easy to combine different data sources in a post to build an engaging data story.
Akuko currently supports three primary types of data sources
Static Files - CSV and Geojson
Online Apps - Google Sheets
Database Connections - PostgreSQL
In the near future, we have plans to support the additional data sources:
Office 365 / Sharepoint
If there is a data base or online app you would like us to support please contact us.
Go to the Sources page and click Add Source in the top right corner.
Give your source a name and then in the pull down select the source type.
To upload a static file, select a valid CSV and GeoJSON file and it will automatically upload.
Note: Akuko currently expects that any column with numeric data to only be numbers including blank spaces which should be replaced with a zero.
You currently can not update a data source created from a static file yet.
Connecting to a Database Source
If you wish to create a source from a database table, select the database you want to connect too. Akuko currently only supports PostgreSQL. Enter in the database connection properties requested and hit connect. Once connected, Akuko will automatically determine the schema of your DB table and generate a corresponding source. Once your DB source is setup, you can create components that will automatically reflect the contents of your database in real time.
Click on the data source you want to delete. Click on the menu in the top right and then select Delete Source. You will then be prompted to confirm you want to delete the data source.
Once deleted the data source cannot be retrieved. When deleting data sources please be aware that there may be numerous posts and components tied to that data source that may break. You may wish to rename the data source to something like My Data Source - Old if you need to repoint existing components in posts to an updated source.
If you are connected to an external data source like a database or Google Sheet it is important to know that deleting a source will not result in deleting your underlying data. Unless you have uploaded a static file, data sources in Akuko just represent a mapping to an external data source.