Data Warehouse Export

Overview

Note: This feature incurs additional fees.

With your business growing, the need to analyze data from multiple sources becomes more critical. It helps you answer questions, such as what is your ROI by customer, or project? Are your customer support initiatives improving your customer lifetime value (CLV)? Often, these are questions that you cannot answer by analyzing data from a single source.

Jump to

Benefits

  • Share work management data with other BI external sources (e.g. Salesforce.com)
  • Keep historical data-snapshots and perform trend analysis
  • Perform complex queries and in-depth analysis
  • Use the reporting tool of your choice

Supported Export Types

Clarizen supports export of data to:

  • Amazon Redshift
  • Amazon S3 (as a flat file, e.g. CSV, JSON)
    Flat files must first be saved to Amazon S3, then downloaded locally if needed.
  • Box (as a flat file, e.g. CSV, JSON)
    A Box account is required before you can configure the export functionality.
  • Azure Blob Storage

Supported data

In Clarizen, you can schedule a data export on a regular interval of all entities of your choice that are exposed by the API.

Incremental Updates

For each entity type, Clarizen stores a timestamp of the last export. The next time the export runs, it will get from Clarizen all the entities that were created/modified since the previous run, and will export the data.

Secured Data

Clarizen One data is protected during the export process by Amazon security policies.

Before You Begin

In order to configure Data Export and create/update new tables, you will need the following permissions for these three applications:

 mceclip0.png 

Setting up Data Export

To configure data export, do the following:

  1. Log into Clarizen as an administrator.
  2. Go to Settings > Extensions and scroll down to the Connected Web Apps section.
  3. Navigate to DWH Export, click Open. The DWH Export window opens.

Step 1

  1. Select and enable the Item Types that you wish to export. For example, Cases.
  2. Enable the Links for data you wish to export.

Step 2

From the Database Type dropdown list, select where you want to export the data to:

  • S3 - Flat files only
  • Box - Flat files only
  • Azure Blob Storage - Flat files only
  • Amazon Redshift
    1. Enter a Database name
    2. Enter a target schema name, such as Clarizen.
    3. Enter the host, port number, and credentials for your target database account.
    4. Click Test Database Connection.
      Note: Clarizen recommends performing this test to ensure successful export to your selected database. If the connection fails, make sure you’ve entered your database information correctly and try again.

Step 3

S3 and Amazon Redshift

  1. Enter a bucket name where the data is to be stored.
  2. Enter a prefix if you want to store files extracted from Clarizen in a subfolder within the Bucket.
  3. Select the File Type.
  4. Select the region where the files will be uploaded to.
  5. Enter the AWS Access Key.
  6. Enter the AWS Secret Access Key.
  7. Click Test Cloud Storage Connection.
    Note: Clarizen recommends performing this test to ensure successful export to your selected cloud storage system. If the connection fails, make sure you’ve entered your account information correctly and try again.

Box

  1. Click Associate with Box Account and log into Box.
  2. Optional - Use a prefix to store Clarizen extracted files in a subfolder under the selected folder.
  3. Select the File Type.

Azure Blob Storage

  1. Use a Connection String or Shared Access Signature (SAS) to connect to Azure.
    • Connection String: Enter the Connection String you generated in Azure.
    • SAS: Specify the Shared Access Signature.
  2. In the Container, specify the target container name (case sensitive). If the container is not found, it will be automatically created. 
    mceclip1.png
  3. Click Test Cloud Storage Connection.
    Note: Clarizen recommends performing this test to ensure successful export to your selected cloud storage system. If the connection fails, make sure you’ve entered your account information correctly and try again.
  4. Select the File Type.

Step 4

  1. Select Result Handling options.
  2. Select the frequency of the export.
  3. Choose whether you wish to be notified whenever a data warehouse export is completed.
  4. Select or enter the email where you’d like to receive the notifications.
  5. At the bottom of the page, click Save to save your settings.
    Note: You can click Test the Service to check if your configuration is correct. Otherwise, you can wait for the scheduled service to run.

Extraction of Deleted Time-phased Data (Controlled Availability)

Note: This feature is in controlled availability, and will be released for general availability soon. To gain early access, contact your Customer Success Manager.

What's New

Extract deleted time-phased data and resource links using Data Warehouse Export.

Benefits

  • Track changes to the data (including the deletion of time-phased data and resource link records) during incremental data extractions
  • Use the data for audits and analysis in external tools

How it Works

The Deleted data records are now extracted for the following time-phased and resource link entities:

LaborResourceTimePhase FixedPriceResourceTimePhase

  • RLTimePhase
    • RLTimePhaseMonthly
  • ResourceLinkFinancial
    • FixedPriceResourceLink
    • LaborResourceLink
  • ResourceTimePhase
    • LaborResourceTimePhase
    • FixedPriceResourceTimePhase
Have more questions? Submit a request

Comments

  • Avatar
    Eric Smith

    Spelling error -

    Supported export types

    Clarizen supports export of data to:

    - Amazon Redshift
    - Amazon 3S (as a flat file, e.g. CSV, JSON)
    Flat files must first be saved to Amazon S3, then downloaded locally if needed.
    - Box (as a flat file, e.g. CSV, JSON)
    A Box account is required before you can configure the export functionality.

     

    Error:

    - Amazon 3S (as a flat file, e.g. CSV, JSON)

    Should read:
    - Amazon S3 (as a flat file, e.g. CSV, JSON)

    Edited by Eric Smith
  • Avatar
    Eric Smith

    The Redshift service exists inside a VPC within AWS, unlike services like Quicksight or S3. All services within the VPC are protected by security group configurations. Therefore, it is necessary for a user to open a port to redshift and at the same time specify a IP range. To avoid opening the service to everyone , which is easy to do but not secure, it would be nice if Clarizen specified the IP address of their servers.