Luminesce Reference

• What are a data provider and a direct provider?

• What tools are available to write Luminesce queries?

• Using Luminesce to read/write Drive files

• Using Luminesce to read/write LUSID investment data

• Understanding the Luminesce SQL query syntax

• Installing the standalone Windows ODBC driver to connect a BI app to Luminesce

• Using Tools.* providers

• Supported functions in Luminesce SQL queries

• Using Sys.Admin.SetupView to create custom views

• Installing the Windows DBC server driver and ODBC/JDBC client drivers to connect BI apps to Luminesce

• Using Sql.Db.Mine to help end users read from/write to SQL databases

• Using Luminesce to read/write to the Configuration Store

• Using Luminesce to read/write to the Notification Service

• Installing the Power BI Connector to connect Power BI Desktop to Luminesce

• Caching Luminesce query results from BI apps for faster execution

• Using Luminesce to read/write SFTP server files

• Using Luminesce to read/write local files (NAS)

• Luminesce SQL keywords

• Using Luminesce to read/write to the Scheduler

• Enabling SSL to secure Windows DBC server and ODBC/JDBC client communications

• Using query folding to optimise Luminesce queries in Power BI Desktop