Business intelligence tools

We provide ODBC 3.8 and JDBC 4.2-compliant drivers to support native integration of business intelligence (BI) apps such as PowerBI or Excel with Luminesce. Once installed and configured, and providing end users have sufficient access control permi...

If you have Power BI Desktop from the Microsoft Store, you can install Luminesce Power BI Connector on a Windows computer to query Luminesce providers directly. To do this, you require: Administrative privileges on a Windows 7 SP1+ computer ...

If you have a Windows computer and an ODBC-aware BI app such as Tableau or Excel, you can install the Luminesce ODBC driver to query Luminesce providers directly from a familiar interface. Note If you have Power BI Desktop from the Microsoft St...

You can install the Luminesce DBC server driver on a Windows computer—and Luminesce ODBC/JDBC client drivers on Windows, Mac, UNIX or Linux client computers—to allow end users to query Luminesce providers directly from familiar BI apps such as DBeav...

We strongly recommend enabling SSL to encrypt communications between a Windows computer running the DBC server driver and client computers running an ODBC or JDBC client driver in production environments. See how to install without SSL in test envi...

Query folding is the ability for a Power BI Desktop Power Query to use a single SELECT query statement to retrieve and transform data. With query folding, data is both retrieved and transformed at the source . Without query folding, excess data ...

You can integrate your BI app with Luminesce to enable end users to query providers from their familiar BI environment as they would any other data source. Find out more about this . In some circumstances, you can choose to cache query results (da...