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 ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.2.tar.gz $ 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.
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.