Before attempting to install and work with Tenup, there are steps that should be taken take to ensure success. All of the following information and preparation are necessary before trying to upload data with Tenup.

Most of the above items are self-explanatory. In order to extract data you will need a valid account for the data source you want to take the data from. For instance, for the process of extracting data from one database and loading into another, you must have valid credentials for both systems.

However, 1010data strongly recommends that before you attempt to use Tenup that you confirm your data source configuration with a simple ODBC client application. On Linux and Mac you can use isql, a free, open-source client application included with unixODBC.

To install unixODBC on Linux and OS X, first run the following commands from your command line:

$ curl -O
$ tar -xzf unixODBC-2.3.2.tar.gz
$ cd unixODBC-2.3.2/
$ ./configure
$ make
$ sudo make install

This series of commands will download the source files for UnixODBC 2.3.2, compile the source into an executable, and install it on your system. It is important that you install version 2.3.1 or later, and earlier versions will cause a runtime error.

On many Linux distributions /usr/local/lib (where UnixODBC will install by default) is not searched when loading shared objects. This can cause the following error to occur: error while loading shared libraries: cannot open shared object file: No such file or directory. To avoid this error, export the following environment variable:
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/usr/local/lib"

To test your ability to connect to the DSN, you can run the following command:

$ isql -v [DATA_SOURCE_NAME]
where DATA_SOURCE_NAME is the DSN for the database you're connecting to. isql is a remote console for interacting with databases via ODBC. It is useful to test your connection with isql because it requires that the data source has an ODBC driver correctly installed and functioning. This, in turn, is important, because Tenup is only able to extract data from ODBC data sources that have an ODBC driver correctly installed and functioning. The average user should not attempt to install and configure an ODBC driver for a database. This is a job for your friendly neighborhood Database Administrator.