Basic Usage

Once you've successfully installed Tenup on your system, you can start uploading data to 1010data. There are just a few simple components to a basic Tenup command. Here's what the atnatomy of a basic query in Tenup looks like:

Keep in mind that this is a basic Tenup command. There are options and alternative methods available, and we'll get to them a little later in this manual. But these are the pieces of information that are required by Tenup. Let's go through each piece one at a time:
Note: When you see a word in all caps enclosed in brackets ([ ]), this represents a variable. So when you see [USERNAME] in a command, you would substitute your 1010data username. This notation will be used throughout this document.
One final note before looking at a basic Tenup command. Tenup provides two kinds of switches for performing the same task, which work as follows (where [S] represents a command option, or "switch."):
This manual will use the short version for its examples. If you are curious about the longer form for each option, you can find them all as well as useful information about each option by running the following command:
$ tenup64 --help

Required Information for a Tenup Command

Table 1. A Basic Tenup Command
Command Component Description
How the Tenup program is invoked. All Tenup commands begin with this.
-u tells Tenup you are providing a username to send to 1010data. After the -u, simply type a space and then your 1010data username.
-p tells Tenup you are providing a password to send to 1010data. After the -p, simply type a space and then your 1010data password.
The DSN (Data Source Name) Connection String for the ODBC compliant database you're extracting data from. Connection strings often contain a username and password that are specific to your account on the ODBC compliant database. The most basic form of a connection string simply contains the name of the data source you're extracting from, i.e., :
However, most connections strings contain authentication information in addition to the DSN:
Note: Above is a simple connection string. Many connection strings also pass configuration information to the ODBC driver/database. If you're not sure what information must be in the connection string, contact your database administrator.
The name of the new 1010data table you're creating. 1010data tables are expressed as follows:
Where training is a top-level parent folder, retail is a subfolder of training, and item is the name of the table.
Note: You must have permission to write to the folder where you will save your new 1010data table.
A query that will retrieve data from your ODBC compliant database. The most common form of query is SQL. The simplest SQL query looks like this:
You can either write a query yourself or acquire one from your IT department. Keep in mind, SQL databases are not the only ODBC compliant databases. The above is used strictly as an example.
While this basic command structure is all that is required of basic interactions using Tenup, there is important information of which you should be aware:
  • If you don't provide a password in your command, Tenup will automatically prompt you for it. Examples for the rest of the manual won't include passwords.
  • If your company uses a custom URL to access 1010data, or you want to use a version of 1010data that's different from the version your company has been provisioned to use, you will need to provide a gateway in addition to the information detailed above.

Using a Query File

Placing your query in the command itself is perfectly workable for small queries. However, if you want to provide a more complex query to the data source for an extract and load operation, writing the query in a file is much better. You can tell Tenup to query the data source with a query located inside a file with the @ syntax it provides:

Where to Save Your New Table

Whenever you extract data from a data source outside of 1010data you will need to save that data in the 1010data system. You will need to provide a full path to the new table being created. If you are appending to an existing table, you will need to provide the path to that table. If you're familiar with the file browser in the 1010data web interface it's easy to find the location where you want to save your table. Each folder has a name, and subfolders and tables are denoted by a . character. Here's an example of a folder name at the highest level:

Notice that the name of the folder, training is a single word with no capital letters or spaces. Next, we'll look at the name of the retail subfolder:

In this example the Retail folder is highlighted in the browser. The name of the folder is actually, training.retail because it is a subfolder of the Training Examples folder. When you load data with Tenup, you will provide the command with a folder location and the name of the new table you are creating.

If we were to use this location with our example command above and create a new table it would appear in the Tenup command as follows:
$ tenup64 -u [USERNAME] -C [CONNSTR] training.retail.newtablename [QUERY]
To illustrate the process, let's look at a basic extract and load example. To start, we need a data source. To make sure we can connect to the data source through an ODBC driver, we'll use the isql tool to take a quick peek at the data we're going to extract and load.
Note: Some information in the commands will still be obfuscated to protect the annonymity of 1010data's employees.
We will assume the iSQL connection information has been configured correctly and then issue the following command:
$ isql -v mysql_odbc
where mysql_odbc is the DSN (data source name) used for this command. For the purposes of this guide we will use the same sample SQL dataset for most examples. To start, we'll run a very basic SQL query using iSQL:
SELECT * FROM testtable;
which will return all the data from a table named testtable. The results of the query in iSQL appear below:

What we have here is a collection of some data from a popular computer game, taken from the public API of the developer and loaded into a SQL database. While it's nice to have it in SQL, it would be much better to have it 1010data where it can be more thoroughly analyzed. We'll use the basic Tenup command to extract the data and load it into 1010data. Again, keep in mind certain values in this command are replaced with generic values to protect the information:
$ tenup64 -u myusername -C "DSN=datasourcename;UID=username;PWD=myPa$$w0rd!" training.retail.mygamedata -t "WoW Guild Roster" 'select * from testtable;'

After running the Tenup command, assuming no errors were returned, you can login to 1010data and see the newly created table, as shown below:


To use the command for this extract and load you can't be logged in to 1010data already. The options for killing or possessing an existing section are detailed in the Managing Connectivity section of this guide.

Specifying a Gateway (-g)

When you log in to 1010data, whether it's via Tenup or the web GUI, by default you will automatically be logged in to the version of 1010data that your organization has been provisioned to use. This is the default behavior and no action on your part is required. However, there are some situations in which you may want to use a different version of 1010data than your default version. For instance, our beta environment is often used by 1010data users who want to see what features and improvements are on the horizon. Furthermore, some of our clients use custom URLs for 1010data access. This means that instead of going to the standard URL for access, they have some custom corporate URL such as:

In either instance (e.g., you want to use a specific version of 1010data you're not provisioned for, or your company uses a custom corporate gateway) you will need to specify your gateway to Tenup. The following two examples show the syntax for each circumstance you may encounter when you need to specify a gateway. In both cases you will use the -g option. To specify a specific version of 1010data, you only need to specify the version, as follows:

$ tenup64 -u [USERNAME] -g beta-8.03 -C [CONNSTR] [PATH_TO_NEW_TABLE] [QUERY]

The example above tells Tenup not to use the standard gateway logic but to instead create a session in 1010data version 8.03. The current beta versions of 1010data begin at version 8.01.

To specify a custom corporate gateway, you need to provide the fully qualified URL, as follows:
If you need to use a corporate gateway and also want to use a specific version of 1010data you can combine the previous examples, as follows:

Testing Your Setup

One step you may want to take before trying your first extract and load is to perform a "dry run" using the -D option, as shown in the command below:
The command above will validate that the connection information you provided works for both the data source and 1010data, but the command will not actually extract and load any data.