Skip to main content
Planview Customer Success Center

How do I create a database table to use with the Enterprise Data Stream Template?

Last Updated:    |  Applicable Hub Versions: All

Answer

The database table populated by the Enterprise Data Stream Template should have columns corresponding to fields in the artifact model, as well as some built-in fields that are designed to facilitate reporting.

Creating the Table with the Suggested DDL

The easiest way to create a database table for the Enterprise Reporting Template is to use the suggested DDL:

  1. When you are creating your database collection, click the "Suggest DDL for creating a table..." link at the bottom
  2. In the pop-up that appears select the model that your integration will be using
  3. Copy the suggested DDL and use it to create a table in your database

Creating the Table without the Suggested DDL

If you prefer to create your database table prior to configuring your database collection, without the aid of the suggested DDL, please ensure that your table has the following columns (with the exact column names listed) for Hub's built-in fields:

  • repository_id - a varchar with size of at least 255
  • repository_url - a varchar with size of at least 255
  • artifact_id - a varchar with size of at least 255