Global Conflict Analysis Hana Database Module

This application will deploy a SAP HANA database on SAP Cloud Platform with Predictive Analytics capability with data from the Armed Conflict Location and Event Data project (ACLED) as well as the Fragile States Index

Requirements

• A currently deployed enterprise instance of SAP HANA

• Cloud Foundry CLI

• Multiapps CF CLI Plugin

Deploy

• Make sure the cli is connected to your space with this script

./cf-login.sh

• Run the deployment script

./cf-db.sh

Bugfix workaround

• Currently there is a memory allocation error when attempting to load all the data at once

• The fix is to not load the ACLED_NOTES_ALL table by default. db/src/data/acled_notes_all.hdbtabledata has this option set

"no_data_import": true

• After running cf-db.sh, login into SAP Web IDE Full-Stack and navigate to database explorer.

• Connect to the gca-db database, select the ACLED_NOTES_ALL table, right-click and select import data

• Locally unzip zip/acled_notes_all.zip to a csv

• Upload acled_notes_all.csv

  • Uncheck has header
  • Select the ACLED_NOTES_ALL table
  • Map COLUMN_1 to data_id and COLUMN_2 to tidy_notes

• Confirm and run the import

Access the database

• Get the access configuration from the service keys section of the instance in the cockpit or with the cli with the following command

cf service-key gca-db gca-db-key