Integration & strategy
Can Excel report on data stored in a CIMCO database?
Updated
CIMCO databaseExcelODBC
Direct answer
Yes. Excel can connect through an appropriate ODBC driver, and a purpose-built database view can present cleaner fields than exposing raw application tables. This is useful for familiar analysis and scheduled refreshes, but the connection should be read-only and built against a supported, documented schema or view.
Practical checkpoint
Use a least-privileged reporting account, validate row definitions and time zones against a known CIMCO report, and protect credentials and refresh files.