You can connect to Fineo through SqlLine - a standard console based SQL access tool.

How To

1. Download

The Fineo-specific build of sqlline is available here [1]. It includes all the necessary Fineo dependencies.

2. Prepare

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 [2] for its speed and stability.

3. Start

Now you are ready to start the sqlline shell:

$ ./sqlline

4. Connect!

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!

5. Examples

Here are some simple things you can do in Sqlline.

List tables

sqlline> !tables

Get all rows in a table

sqlline> SELECT * FROM <table name>

6. Exiting

Crtl-C (the usual exit option) only cancels the previous command. Instead you need to use:

sqlline> !quit

Notes

1. SqlLine

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.

2. Logback

For logback, the jars you need are: logback-core and logback-classic. Download these jars and add them to the lib/ directory.