Skip to content

Get Started

This page provides a high-level overview of the workflow for importing data, writing it to a database, then querying and visualizing that data in kdb Insights Enterprise Web Interface.

To get started with the kdb Insights Enterprise web interface, it is recommended that you:

  • Explore the web interface overview to familiarize yourself with its layout and functionality.
  • Review the high-level workflow for importing data, writing it to a database, and then querying and visualizing that data in kdb Insights Enterprise. For details, refer to the Workflow below.
  • Use the Guided walkthroughs to gain hands-on experience with this workflow.

Workflow

The workflow for importing, querying, and analyzing data is summarized in the following steps.

  1. Begin by creating a database and adding it to a package. Data is stored in kdb Insights Enterprise using kdb+, column-based, relational time series database technology.

    Refer to Create a database for details.

  2. Configure the database schema to store your data. The schema contains table definitions to ensure imported data is compatible with kdb+ data types.

    Refer to Create a schema for details.

  3. Create a pipeline to ingest data from a source into kdb+. This can be done using the Import Wizard or by building a pipeline of nodes.

    Refer to Import Wizard and build a pipeline for details.

  4. Deploy the package that contains the database and pipeline to ingest data.

    Refer to Deploy a package for details.

  5. Create queries to analyze the data using Basic query,q, SQL, or User Defined Analytics (UDAs).

    Refer to Create Query for details.

  6. Perform further ad-hoc queries on data using q or python in the Scratchpad.

    Refer to Create ad-hoc queries in Scratchpad for details.

  7. Create visualizations of your data using Views to incorporate data into charts, maps, and more, and share these views with others.

    Refer to Create a View for details.