2 Replies Latest reply: Jan 14, 2013 5:03 AM by Romain CHAUMAIS RSS

    Extension that retrieves data from SQL database

      Has anyone built an extension that can construct a SQL statement by putting current selections into where clause and send the SQL to a relational DB and retrieves and visualizes results? For instance, in an app there's a field called "sales person", if a user select a sales person George, I would like to send a SQL "select * from dbo.sales where sales_person='George'" and display the results in something similar to a straight table.

       

      I believe the BigQuery extension is similar to what I am looking for but I have not seen it yet.

       

      Thanks!

       

      Lingxiang