https://www.omnidex.com/docs/v51/ 2026-04-23T10:38:24+0000 https://www.omnidex.com/docs/v51/ https://www.omnidex.com/docs/v51/lib/tpl/simple/images/favicon.ico text/html 2012-10-26T14:57:21+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rawdata:fixed:datatypes&rev=1351263441&do=diff Integration: Raw Data Files Fixed-length Files Overview | Environments | Datatypes | Exporting | Limitations | Example ---------- Datatypes The record layout described in the CREATE TABLE statement must exactly match the record layout in the data file, including the order, datatype and length of each column. If these record layouts do not match, Omnidex will have problems reading the data from the data file. text/html 2012-10-26T14:57:21+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rawdata:fixed:environments&rev=1351263441&do=diff Integration: Raw Data Files Fixed-length Files Overview | Environments | Datatypes | Exporting | Limitations | Example ---------- Environments The Omnidex Environment File is the key to setting up Omnidex on raw data files. Fixed-length files do not contain any metadata, meaning there is no available information about things like columns and datatypes. The Omnidex Environment File fulfills this role. text/html 2012-10-26T14:57:21+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rawdata:fixed:example&rev=1351263441&do=diff Integration: Raw Data Files Fixed-length Files Overview | Environments | Datatypes | Exporting | Limitations | Example ---------- Example The following example is a simple database using fixed-length files. The Omnidex Environment File is displayed below; however, the entire example, including sample data files, can be downloaded as a ZIP file at the following link: text/html 2012-10-26T14:57:21+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rawdata:fixed:export&rev=1351263441&do=diff Integration: Raw Data Files Fixed-length Files Overview | Environments | Datatypes | Exporting | Limitations | Example ---------- Exporting Data to Fixed-length Files The Omnidex EXPORT statement can be used to create fixed-length data files from another Omnidex environment. For example, users can connect to an Omnidex Environment File that accesses a relational database and then export fixed-length data files for use in a data mart. In fact, this approach is the basis for text/html 2012-10-26T14:57:21+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rawdata:fixed:home&rev=1351263441&do=diff Integration: Raw Data Files Fixed-length Files Overview | Environments | Datatypes | Exporting | Limitations | Example ---------- Overview In general, Omnidex data files must maintain a consistent structure, meaning that the data has consistent rows and columns. For example, most relational database systems allow data to be exported into data files, and these files are ideal for indexing with Omnidex. Similarly, companies often receive data from vendors or suppliers in this same form, and… text/html 2012-10-26T14:57:21+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=integration:rawdata:fixed:limitations&rev=1351263441&do=diff Integration: Raw Data Files Fixed-length Files Overview | Environments | Datatypes | Exporting | Limitations | Example ---------- Limitations Fixed-length files are often the highest performing and most flexible approach to indexing large amounts of data, but they do have some limitations. These limitations are described below: