Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

could I use the analytics Funcions directly in My BI Tool for example QlickView or Pentaho?

I know that
vertica has a big powerfull in analytics, with his own functions and giving
tools to programme your own code in R and put inside vertica for example.


But could you access this functions since BI tools as QlickView or Pentaho, I mean, I know that you can connect Vertica with this tools, but I’m not sure if you can execute selects with analytics parameters directly.


Example : SELECT slice_time, symbol, TS_FIRST_VALUE (bid,'LINEAR') AS bid FROM tick_store4 TIMESERIES slice_time AS '2 seconds' OVER (PARTITION BY symbol ORDER BY ts);

And your "R" Funcions?



  • I believe you can.

    vertica sees the BI tool as just another database client like vsql/jdbc/odbc..
    This equivalent to a sql query.

  • Hi Dani,

    Any tool using JDBC / ODBC / VSQL interface to talk to Vertica can access all functions of Vertica.
    If you are writing a SQL from your client with ANALYTIC Function / UDF Function / R Function and all the functions are present in Vertica database, then they all are accessible.

    Hope this helps
  • Thanks for your replies

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.