Learning Tabulify - Step 1 - Installation

Tabul

To learn Tabulify, you need to install the Tabul command line tool.

This pages will guide you through the installation steps.

Options

HomeBrew

On Windows WSL, macOS or Linux, you can install Tabulify with brew.

brew install tabulify/tap/tabulify

Windows Installer

You can install tabulify on Windows with the installer.

Steps:

  • Download the tabulify-2.0.0-jre-x64.msi installer
  • Open it
  • You may get a Windows protected your PC.
    • To continue, click on the More info link
    • Then on the button Run anyway
  • Done

Tabul

If you can call the tabul command line, your installation is validated.

Tabul is the command line tool of Tabulify and is composed of module that regroups command where each command can be customized with argument and options.

  • Open a console
  • Call tabul with the help option
tabul --help
  • The help should shows up.
Tabul
=====

Tabul, the tabulify command line data processing tool



Example
-------

 1 - To load a csv file into the sqlite database, you would type:


    tabul data transfer data.csv @sqlite




Syntax
------


    tabul <command> [-h,--help]


where:


  Commands:

    app             Management apps

    connection      Management and configuration of the connections to systems.

    data            Data operations against data resources (table, file, ...).

    env             Management and configuration of the tabul execution environment

    flow            Execute Flows

    service         Start and stop services

    vault           Encrypt and decrypt sensitive information

    version         Show build and version information


  Option:

    -h,--help       Print this help

    -v,--version    Print version information

Terminal

Tabulify supports a lot of command line in the tabul data module and having a good terminal that simplify our task is important.

We recommend therefore a terminal that supports bash.

See Why do we recommend bash ?

Next Step

In Tabulify, all data are uniformly called data resources. All data operations are made on data resource. You drop, select, create, … etc data resources.

What's a Data Resource ?




Related Pages
How to create a SQL view with a CREATE statement file

This Howto will show you how to create a SQL View with a SQL file that contains a CREATE SQL statement with the Tabul table create command. You should have Tabulify installed on your computer: ...
HowTo's Connections

Tabulify comes with pre-configured connections that are used in the How-to's After a fresh installation, you should see them by listing the connection. sqlite and sqlite-target are sqlite connection...
HowTo's Services

Tabulify comes with pre-configured services that are used in the How-to's After a fresh installation, you should see them by listing the service. where: oracle is an oracle database sqlserver...
Learn Tabulify in 10 steps

tabulifydata processingdata deliverytabul learn guide you through the data concepts and show you how to perform basic data operations tabulify Step 1 - Tabulify Installation
SQLite - How to fill a table with a resource data generator?

This how-to will show you how to define the generation of data via a data definition file and load it into a table via the tabul data fill operation.
SQLite - How to fill a table with auto generated data

This how-to will show you how to fill a table with auto-generated data and the Tabul fill action.
Tabul - Home Directory

Tabulify Home (TABULIFY_HOME) is the directory where the installation file were unzipped. tabul is able to detect your home. You can see it with the conf list command
Tabul - How to copy the data definition of all tables from a star/snowflake schema

This howto will show you how to copy the data definition of all SQL tables from a star/snowflake schema.
Tabul - How to create a table from the definition of another table

This Howto will show you how to copy the data definition of a SQL table from another SQL table
Tabul - How to load a CSV file into a SQL table

How to upload a CSV file into a SQL table in two steps

Task Runner