DI-ODBC (Dimensional Insight ODBC Driver) is an ODBC driver that can retrieve Spectre data from DiveLine. ODBC-capable applications can use the driver to make queries against a DiveLine server, as specified by a connection string or a configured DSN.
With the addition of DI-ODBC, Diver Platform becomes an open architecture. Analysts can use their tool of choice to examine cBase data. Examples for usage include:
- Synchronizing data into an Excel spreadsheet
- Using the Spectre engine to feed an alternative graphing tool
- Dumping cBase data to import into another application
The driver can be used to query a cBase, cPlan, or Dive script. Queries are made using SQL syntax.
DI-ODBC is available for Windows, in 32- and 64-bit versions which are installed together by an MSI-based installer. The driver's version is 7.2, but it can connect to 7.2, 7.1, and 7.0 DiveLines. Note however, when connecting to 7.1 or 7.0, some features will be unavailable.
NOTE: DI-ODBC requires a special license and users need to be configured on the server.
This driver does not support all of the SQL language. See DI-ODBC SQL Grammar Quick Reference for what kinds of queries it does support.
When connecting to DiveLine version 7.0, DI-ODBC cannot fetch data from cbase files. It can use cplan files, but it cannot access the input_ tables in cPlans. (See Source Type Details for the Driver.) It can use dive files with no restrictions. If you need to connect to a cBase on a 7.0 server you can create a cPlan that references the cBase, but you cannot fetch non-aggregated data.
To get the most out of cBases and cPlans, DI-ODBC requires DiveLine version 7.1.
To connect to a Measure Factory, use the cPlan at /factory-output/__internal/all-measures.cplan. Each view will be exposed as an input_<view name> table.