Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

Table of Contents
classcontents

Overview

The Data Transformation module supports different ways of extracting data from sources and loading it into Yellowfin, using the input steps. This section will show you how to use and configure each of these steps.

Image Added

 

...

 

Types of Input Steps

Click on the name of an input step in the table below to learn how to configure it.

 

Icon

Input Step

Column

Image Removed

...

Icon

...

Description

Image Modified

...

Delimited file

...

Third-party ConnectorTo extract data from a single third-party connection table. The connectors currently supported are: Google Analytics, Google Sheets, and Salesforce.
Image Modified

Freehand SQL

Use this method to import data from a database using an SQL query

...

Report

...

.

Image Modified

Single table

This input step can be used to import data from a single database table.

Image Modified

...

Single third party connector

...

To extract data from a third-party connector, such as Twitter, Facebook, Google Analytics, etc.

...

...

Delimited File

 

...

Expand
titleDelimited file configuration fields
Configuration SettingExplanation

Protocol

Choose the file protocol here. For example, you can define if this is a local file, a file on the shared network, FTP or SFTP.

File path

Enter the path to the file.

Advanced settings

This link reveals more setting options, discussed below.

First row contains unique titles

Enable this toggle switch if the first row of the file contains titles or column names. If switched on, the system will read these values as the column field titles.

Field separator

Choose a character from the list to set it as the field separator, or enter a custom one after selecting the Other option.

Decimal separator

Choose a character from the list to set it as the decimal separator, or enter a custom one after selecting the Other option.

File encoding

Select a file encoding option.

Precision

 

Delimited file

This input method is used when extracting data from a delimited file (that is, a file with separators).

Image Added

Report

Use this method to use a Yellowfin report as the source of data. This method accepts 2-dimensional reports, but not multi-dimensional ones. The following types of reports are currently not supported: Jasper, SSRS, and BIRT.

 

...

Styleclass
ClasstopLink

back to menu

 

...

Freehand SQL

 

...