Our software / DAP

Your data warehouse.
Practical control.

DAP is a clik digital software package already used by client organisations. It connects to your data warehouse, bringing data administration, extract workflows and processing oversight into one web interface.

Discuss DAP

Inside DAP

Explore the application.

Demonstration data · Select a screen to explore it

The DAP lookup interface populated with demonstration reference-data tables.

Lookup-table management

Maintain reference tables and the values used by warehouse processes. Actual DAP interface shown with demonstration data.

DAP CDS Exports showing demonstration extract definitions, date controls and export settings.

NHS extract workflows

Choose a CDS extract and review dates and output settings. Actual DAP interface shown with demonstration definitions.

Inside DAP

Lookup-table management

The DAP lookup interface populated with demonstration reference-data tables.

1 / 2

What you can do with DAP.

01

Organise sources and processing.

Manage source connections, linked data and datasets through a shared interface. Define processing steps and their order so the setup behind the warehouse is easier to inspect and maintain.

  • Data-source and linked-table administration
  • Dataset configuration
  • Stored procedures and processing sequences
02

Keep lookup data and mappings connected.

Maintain lookup tables and their values alongside the mappings used by your warehouse. Bring reference data into the same environment as the processes and reporting that depend on it.

  • Lookup-table and attribute management
  • Reference-data mappings
  • User-maintained tables
03

Prepare and run extracts.

Work with NHS extract definitions and file outputs from your warehouse environment. DAP includes CDS and COSD workflows, XML and delimited exports, and configuration for CDS versions, elements and mappings. The datasets and outputs needed are agreed for your implementation.

  • CDS and COSD extract workflows
  • XML and delimited file exports
  • CDS version and element configuration
  • XML mappings and schema validation
04

Schedule exports and review processing.

Configure scheduled delimited exports and review their run history. Alongside export management, warehouse build audits help technical teams see processing timings and failures.

  • Scheduled delimited exports
  • Export run history
  • Warehouse build timings and failure visibility
05

Explore definitions and relationships.

Use the data dictionary and schema explorer to understand fields, relationships and documented mappings. Where metadata is available, follow the recorded sources and transformation rules behind a field.

  • Searchable field definitions
  • Interactive schema and relationship views
  • Documented mappings and field-level lineage
06

Manage imports and grouper configuration.

Administer external import definitions and the configuration used for HRG grouping. Keep the relevant versions, paths and output settings accessible alongside the other warehouse administration tasks.

  • External import configuration
  • HRG types and versions
  • Grouper output and path settings

Let’s make more
of your data.

Tell us about your warehouse and the tasks you need to manage. We’ll discuss how DAP can fit your environment and agree the implementation and support you need.

info@clikhealthsolutions.co.uk