Chapter 1

Welcome to the free edition

The free edition is DataBridge running inside your web browser. There is nothing to install and you do not need to sign in, and the files you open are read on your own machine and never uploaded.

What you can do here

Everything in the Transform group of the left navigation works fully in the free edition:

PageWhat it is forChapter
File TemplatesDescribe a file's layout: its type, delimiter, header row and columns.2
Field MappingsTurn one layout into another with copy, combine and clean-up rules.3
Transform DataRun a file through a template and mapping and download the result as CSV, TSV or JSON.4
Quick TransformOne-click clean-ups (case, whitespace, duplicates, dates, phone numbers) with no template needed.4
Expression BuilderTry out expressions against a sample row before you rely on them.4
Validate FileCheck a file against a template and list every problem.5
Data DiffCompare two versions of a file and see what changed.5
Export & ImportSave all your definitions to one file, or bring them back.6

A second group, Server features, holds Connections, Queries, Destinations and Jobs. The free edition cannot use them, so each shows a locked preview that names the module that unlocks it. Chapter 7 explains what they are.

Where your work is stored

Data lossEverything you create in the free edition (templates and mappings) is saved only in this one browser, on this one computer. It is not an account and there is no copy anywhere else. Clearing the browser's site data, using a private or incognito window, switching to another browser or browser profile, or moving to another computer means starting with nothing. Export your work regularly with Export & Import (chapter 6) if you want a copy that survives any of those.

The app shows a short notice to this effect on Home and Settings, and the first time you open Home it asks you to acknowledge a Before you start message with I understand. The first time you open Home with nothing stored, it also fills the lists with a few sample templates and mappings (six templates and three mappings) so you have something to try; they count toward the limits below, and you can delete or edit them like your own. Once the app has loaded, it is kept in the browser's cache and opens again without a network connection. This guide is not cached. Nothing you enter is sent to ExtensibilityCo unless you choose to send feedback, and you see the full message before it goes.

Limits of the free edition

WhatLimit
File templates10
Field mappings5
CSV and TSV files10 MB each
Excel workbooks (.xlsx)5 MB each
Rows per file in Transform Data, Quick Transform, Validate File and Data Diff100,000
Export & Import files10 MB

When you reach a limit the app says so and refuses the save rather than losing anything. The File Templates and Field Mappings lists show how many you have used. The template and mapping limits are removed by any paid module Full edition.

Finding your way around

The status bar at the bottom shows the edition, where your data is stored, your time zone and record counts.

A typical first session

  1. Create a template for the file you receive (chapter 2), and another for the layout you need to produce.
  2. Create a mapping from the first template to the second (chapter 3).
  3. Open Transform Data, preview the result, then download it (chapter 4).
  4. Export your definitions so you have a copy (chapter 6).