The Kahua Data Store is a read-only SQL database that contains data from your domain and is kept in sync with the production database in near real-time. When enabled, it can be used for a number of purposes, including to create cross-application reports, connect to PowerBI or other analytics tools, or to replicate data to an enterprise data warehouse.
This article outlines basic information for accessing and enabling the data store. You can find more detailed information using the data store in this article in the Kahua wiki. For more information, reach out to support or your account representative.
Key elements of the data store feature are as follows:
- Typically data in the data store is updated within seconds of a change to the production data. However, this update is asynchronous, so it is theoretically possible that updates could take longer than a few seconds, particularly if bulk data updates are made that create a large amount of data changes that need to synced to the database at once.
- Kahua apps define what entity and attribute data the app publishes to the data store. If an app, extension, or supplement does not define an entity or attribute as enabled for the data store, then it won't appear for use in the data store. While most all relevant data is available for most apps, it is possible that certain pieces of data may not be enabled for data store in an app, and modifications must be made to the app to make it available in the data store.
- Entity history and configuration data are currently not available in the data store.
- Apps must be individually enabled in order for the data within those apps to be available in the data store.
TABLE OF CONTENTS
Enable the Data Store
Enabling the Data Store can be done from within Kahua by any domain administrator. The Kahua Data Store provisions the creation of a domain specific database which can be used for various reasons.
Kahua apps define what entity and attribute data the app publishes to the data store. If an app, extension, or supplement does not define an entity or attribute as enabled for the data store, then it won't appear for use in the data store.
To enable the data store, complete the following steps:
- Login to your Kahua site as a domain administrator.
- Navigate to Apps > Administration > Domain Settings > Data Store.
- Select the Enable Data Store toggle.
- Enter the Database Password.
- Select Save.
Configure the data store
Once the Data Store is enabled, you must select applications in the list that contain the data you want to publish to the data store.
To select the applications, complete the following steps:
- Navigate to Apps > Administration > Domain Settings > Data Store.
- In the Enable Applicationssection, select the toggle for the applications you want to enable.
- To assist with managing your selections, select Enable All or Disable All as appropriate.
- It is a best practice to enable the following apps, as they are commonly referenced from other applications.
- Companies
- People
- Projects (often renamed to Portfolio Manager)
- kahua AEC Cost (if using the data store for cost related apps)
- Click Save when you are done. On save, Kahua creates tables in the data store for the selected applications and populates them with data from Kahua.
- Select Refresh to enable the detail view under each selected application. The detail view includes the names of the tables being created and status of the data being published to each table.
Access the data store
How you interact with the data store depends on your target usage. Direct SQL connections to the data store are not supported for security reasons, but there are tools available to utilize the data store, including the data store table API.
For more detailed information, refer to this article in the Kahua wiki.