Data Hauler: Basic usage

Data Hauler makes use of TenUp to dynamically upload many tables from an ODBC-compliant database to 1010data Insights Platform at once.

The following is the basic structure of a Data Hauler command:

$datahaul64 [DATABASE_TYPE] -u [USERNAME] -p [PASSWORD] -C [CONNSTR] -d [DSTPATH]
A Data Hauler command has the following components:
[DATABASE_TYPE]
The type of ODBC-compliant database from which you are loading data into 1010data Insights Platform. If you enter datahaul64 on the command line without a database type, Data Hauler supplies a list of database types.
In addition, Database types provides a complete list of supported database types.
-u [USERNAME]
Your 1010data Insights Platform user name. If you do not provide a user name and there is no environment variable TENTENUID, Data Hauler prompts you for a user name.
-p [PASSWORD]
Your 1010data Insights Platform password. If you do not provide a password and there is no environment variable TENTENPW, Data Hauler prompts you for it.
-C [CONNSTR]
The connection string to an ODBC-compliant database. If you do not provide a connection string and there is no environment variable TENTEN_CONNECTION_STRING, Data Hauler prompts you for it.
-d [DSTPATH]
The complete path to a destination folder in 1010data Insights Platform. If you do not provide a destination folder, Data Hauler prompts you for it. For more information about file paths in 1010data Insights Platform, see 1010data Insights Platform file structure.

There are also optional switches can be added in any order. For more information, see Data Hauler: Switch reference.