Integration: Raw Data Files

Environments and Raw Data Files

Omnidex provides access to raw data files by creating a database around them. The Omnidex administrator creates an Omnidex Environment File that declares a complete database with table and column definitions, table constraints, and Omnidex indexes. The tables simply point to the raw data files as their source of data. Omnidex applications can then query the database without any concern whether the underlying data came from a relational database or raw data files.

The instructions for referencing the raw data files in CREATE TABLE statements vary based on the file type. Consult the Integration Guides for each type of raw data file for instructions on adding them to Omnidex Environment Files.

Combining Raw Data Files and Relational Databases

Raw data files often supplement a relational database. For example, a transaction log or a supplemental data file may contain information that is ideal to correlate with a relational database. Companies importing that data into the relational database can avoid the extra work, and use Omnidex to join those two data sources together instead.

An Omnidex Environment File can include more than one database, and each database can be of a different type. An Omnidex Environment File can have one database that points to the underlying relational database, and a second database that points to a series of raw data files. When connected to this Omnidex Environment File, applications can issue SQL statements that join tables from both databases.

Once connected to this Omnidex Environment File, statements can be issued that reference all of the tables in the environment, including referencing tables from both databases.

Additional Resources

See also:

 
Back to top
integration/rawdata/environments.txt ยท Last modified: 2016/06/28 22:38 (external edit)