This shows you the differences between two versions of the page.
| — |
integration:rawdata:fixed:export [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ~~NOTOC~~ | ||
| + | {{page>:top_add&nofooter&noeditbtn}} | ||
| + | |||
| + | ====== Integration: Raw Data Files ====== | ||
| + | |||
| + | ===== Fixed-length Files ===== | ||
| + | |||
| + | [[integration:rawdata:fixed:home|Overview]] | | ||
| + | [[integration:rawdata:fixed:environments|Environments]] | | ||
| + | [[integration:rawdata:fixed:datatypes|Datatypes]] | | ||
| + | **[[integration:rawdata:fixed:export|Exporting]]** | | ||
| + | [[integration:rawdata:fixed:limitations|Limitations]] | | ||
| + | [[integration:rawdata:fixed:example|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 [[admin:features:snapshots:home|Omnidex Snapshots]]. | ||
| + | |||
| + | The Omnidex EXPORT statement can export the results of any SQL statement, including statements that retrieve a subset of columns or rows, join tables, perform aggregations or order the results. These SQL statements can also include SQL functions and expressions, allowing administrators to generate a wide variety of data files for their applications. | ||
| + | |||
| + | The Omnidex EXPORT statement has several options for generating different types of raw data files. By default, the EXPORT statement will create a fixed-length data file, and so no options are needed to produce these files. | ||
| + | |||
| + | This simple example exports all of the columns and rows from a table. No options are needed for fixed-length data files. | ||
| + | |||
| + | <code> | ||
| + | export (select * | ||
| + | from INDIVIDUALS) | ||
| + | to individuals.dat | ||
| + | with DELETE; | ||
| + | </code> | ||
| + | |||
| + | ===== ===== | ||
| + | |||
| + | **[[integration:rawdata:fixed:datatypes|Prev]]** | | ||
| + | **[[integration:rawdata:fixed:limitations|Next]]** | ||
| + | |||
| + | ====== Additional Resources ====== | ||
| + | |||
| + | See also: | ||
| + | |||
| + | {{page>:integration:rawdata:see_also&nofooter&noeditbtn}} | ||
| + | |||
| + | {{page>:bottom_add&nofooter&noeditbtn}} | ||