TIBCO® Clarity User's Guide

Software Release 2.4

May 2016

  • Important Information
  • TIBCO Documentation and Support Services
  • Introduction to TIBCO Clarity
    TIBCO® Clarity is a data preparation tool that offers you on-demand software services from the web in the form of Software-as-a-Service.
  • Data Preparation Workflow
    TIBCO Clarity provides you an easy data preparation flow. You can apply a data preparation workflow to a different sample set to further refine and compare transformation rules.
  • Subscribing to and Launching TIBCO Clarity
    Use TIBCO Cloud Marketplace to subscribe to and launch TIBCO Clarity.
  • User Interface
    After launching TIBCO Clarity, the home page is displayed with three sample datasets.
  • Configuring Global Settings
    TIBCO Clarity groups a set of settings together and make the global settings accessible whenever a connection, a custom data type, or a look-up table is required.
  • Creating Datasets and Projects
    A dataset is a collection of raw data from one or more data sources. It is a base on which you can create your projects.
  • Managing Datasets
    On the home page, you can find all the created datasets. You can create, import, export, and delete datasets. You can also upload similar source data to an existing dataset from multiple files at a time.
  • Manipulating a Column
    TIBCO Clarity provides you a set of operations that you can use to manipulate a specific column in a project.
  • Managing Project Data
    A project contains the sample data of a dataset. TIBCO Clarity provides you various operations to analyze and transform your project data.
  • Profiling Data
    Use the data profiling function to check and collect statistics and information about your data by generating row or column analysis reports about your data.
  • Validating Data
    TIBCO Clarity validates your data according to the data types and constraints defined for columns. It checks whether a column value conforms to the defined data types and constraints.
  • Charting Data
    Use the data charting function to create different types of charts of a project. This is another way to profile your data.
  • Address Cleansing
    Use the address cleansing function to identify and correct errors or inconsistencies in address.
  • Batch Processing
    Use the batch processing function to apply the operations that have been performed on a project to the source data.
  • Detecting Duplicates
    Use the Dedup (deduplication) function to detect or check duplicated or similar data in a project or an external table uploaded from TIBCO Patterns.
  • Synchronizing Data to TIBCO Spotfire
    TIBCO Clarity supports synchronizing cleansed project data to TIBCO Spotfire.
  • Managing OData Warehouse
    TIBCO Clarity supports synchronizing cleansed project data to OData warehouse.
  • Exporting Project Data
    TIBCO Clarity support exporting data in a project to various file formats, a database, other Cloud Software Group, Inc.products, Salesforce, Marketo, and Amazon S3.
  • Clarity APIs
    TIBCO Clarity provides a set of RESTful APIs. Integrated with Swagger, you can test these APIs in Swagger.