Learning Tabulify - Step 1 - Installation

Tabli

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

This pages will guide you through the installation steps.

Steps

Prerequisites

Tabulify relies on Java version 1.8

You should have therefore already a java installation from and above 1.8

You can check it by calling the below command

java -version
java version "1.8.0_251"
Java(TM) SE Runtime Environment (build 1.8.0_251-b08)
Java HotSpot(TM) 64-Bit Server VM (build 25.251-b08, mixed mode)

If this is not the case, you can download it and install it at the Java download page

Installation Directory

Create a directory called the Tabulify Home where you will unzip the content of the installation file. A path without space is recommended

  • Windows
:: Below c:\tabulify is the Tabulify Home.
mkdir c:\tabulify
  • Linux / Mac
# Below /opt/tabulify is the Tabulify Home.
mkdir /opt/tabulify

Download

You need to https://tabulify.com/tabulify.zip download the zipped file for your operating system.

Tabulify is distributed for different operation system.

Unzip

Unzip the downloaded file into the Tabulify Home

At the command line:

  • Windows
unzip tabulify.zip -d c:\tabulify
  • Linux
unzip tabulify.zip -d /opt/tabulify
  • Optionally, create a symlink into your bin directory to be able to call Tabulify from everywhere.
mklink c:\tabulify\tabli.cmd %USERPROFILE%\bin\tabli.cmd
  • This local bin directory should be added to the PATH environment variable.
setx PATH=%PATH%,%USERPROFILE%\bin

Tabli

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

Tabli 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 tabli with the help option
tabli --help
:: or if you didn't have the directory in your PATH environment variable
:: TABULIFY_HOME\tabli.cmd --help
:: in our installation documentation
:: c:\tabulify\tabli.cmd
  • The help should shows up.
Tabli
=====

Tabli, the tabulify command line data processing tool



Example
-------

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


    tabli data transfer data.csv @sqlite




Syntax
------


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


where:


  Commands:

    conf          Management and configuration of the tabli environment.

    connection    Management and configuration of the connections to systems.

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

    vault         Encrypt and decrypt sensitive information


  Option:

    -h,--help     Print this help

Terminal

Tabulify supports a lot of command line in the tabli 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 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.
How to create a CSV File with generated data

This article shows you how to generate a csv file from a generator tabular file.
How to create a table from the definition of another SQL table

This Howto will show you how to copy the data definition of a SQL table from another SQL table
How to create a table with a CREATE Sql statement file

This Howto will show you how to create a SQL table with a SQL file that contains a ''CREATE'' SQL statement
How to fill a database relational schema with generated data and tabli

This how-to will show you how to use the tabli fill command to fill all the tables of a schema with generated data.
How to list SQL Tables

This howto will show you how to list SQL Tables
How to load a CSV file into a SQL table

How to upload a CSV file into a SQL table in two steps
How to select data resources with a Glob Pattern

With this howto, you will learn what a glob pattern is and how to use it to select data resources.
HowTo's Connections

Tabulify comes with pre-configured connections that are used in the How-to's sqlite and sqlite-target are sqlite connection oracle is an oracle database sqlserver is an sqlserver database...
Learn Tabulify in 10 steps

tabulifybusiness and financial analytics data processing tabulifytabli learn guide you through the data concepts and show you how to perform basic data operations tabulify Step 1 - Tabulify...

Task Runner