Data Access

Data is the raw (or intermediate) material for an Intellect system. Data is converted into information products. Accordingly, Intellect needs access to data, in whatever form, in whatever location. Most companies have data spread throughout their organization so we engineered Intellect to access data from a variety of sources.

Text Files

Excel Workbooks

Intellect Historian

OSIsoft PI data historian

OLE Databases (e.g., Microsoft Access)

ADO Databases (e.g., SQL Server)

Oracle Databases

OPC

and in finance:

Metastock Data

QuoteTracker tick streams

MetaTrader4 tick streams ...

and any combination of the above simultaneously using data synchronization.

Data can also be stored by Intellect into most of these, except the financial sources which are read only and writing to Excel is not recommended. This enables you to chain together sources. For example: Data is read from OSISoft PI and SQL Server simultaneously, synchronized, processed and an intermediate result is archived to the Intellect Historian, which is read by another process which creates a final result that is written simultaneously to a text file, the Intellect Historian and also Oracle.