You can connect to Fineo through SqlLine - a standard console based SQL access tool.
Unpack the tarball.
$ tar -xf <sqlline version>.tar.gz $ cd <sqlline version>
To add extra logging, and avoid
SLF4J: Failed warning messages, an SLF4j compatible logging framework should be added to the
lib directory. Fineo recommends using logback  for its speed and stability.
Now you are ready to start the sqlline shell:
Start by entering the connection credentials:
sqlline> !connect jdbc:fineo:api_key=<your api key>
If you did not enter a authentication method (see JDBC guide), you can enter your IAM credentials as a username (access key) and password (secret key) combination:
Enter username for jdbc:fineo;api_key=<key>: Enter password for jdbc:fineo:api_key=<key>:
That's it. From there you can easily access all of your data through SQL!
Here are some simple things you can do in Sqlline.
Get all rows in a table
sqlline> SELECT * FROM <table name>
Crtl-C (the usual exit option) only cancels the previous command. Instead you need to use:
We include a couple of fixes, like loading the properties file correctly and using lib/ vs. changing the java-ext dir. For more details, see our fork. If you want a generic bundle of SqlLine without the fineo jar, please contact us.