Uploading Data

In this section:

Once signed in, the TIBCO DQ UI offers different navigational views to get you started.

To upload data, click Explore New Data in the upper-right corner of the Home Page, as shown in the following image.

The Explore New Data dialog opens, as shown in the following image.

You can upload data from a text file or JDBC data source (PostgreSQL, SQL Server, etc.). Click File Upload or JDBC datasource.

Uploading Data From a Text File

To upload data from a text file (for example, .csv):

  1. Drag an input text file to the upload window or browse your local file system and select an input text file.

    Note: Text files up to 5GB in size are supported.

  2. Click Next.

    The Add Context pane opens, as shown in the following image.

  3. Add business context for your input data.

    Tip: Setting up the right business context helps users filter DQ statistics and metrics in the TIBCO DQ Watchdog App.

    Property

    Description

    Save As

    Data set name if different from file name.

    Source Name

    Name of the data source.

    Source Type

    Is the data source considered internal or external to the organization.

    Application Name

    Name of the application that generated the input data.

    Industry

    Select an industry represented by the data.

    Entity

    Name of the business entity the data represents (e.g., customer, partner, supplier, office).
  4. Provide parsing options for your input data.

    Property

    Description

    File character set

    Character encoding, supported types are UTF-8, UTF-16, or ISO-8859-1.

    File has header

    True if file has a header column, False otherwise.

    File Delimiter

    Field delimiter, supported delimiters are Comma (,), Pipe(|), Semicolon (;), Space, or Tab.

    Quote Character

    Define the enclosing character if text within a field includes the delimiter character. Supported characters are double quote (“) or grave accent (`).

Uploading Data From a JDBC Data Source

To upload data from a JDBC data source:

  1. Provide the JDBC source database username and password.
  2. Provide the source database JDBC connection string.

    Database

    Format

    Example

    SQL Server

    		 jdbc:sqlserver://[serverName[\instanceName][:portNumber]] jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks

    PostgreSQL

    		 jdbc:postgresql://host:port/database jdbc:postgresql://localhost:5432/AdventureWorks

    Oracle

    		 jdbc:oracle:thin:@host:port:database jdbc:oracle:thin:@localhost:1521:AdventureWorks

    MySQL

    		 jdbc:mysql://localhost:port/database jdbc:mysql://localhost:3306/AdventureWorks
  3. Provide the SQL select statement to read data from a table or a view.

Tracking Upload Progress

The upload progress bar displays the current upload status, as shown in the following image.