This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
integration:rawdata:ost:export [2011/03/14 14:21] 127.0.0.1 external edit |
integration:rawdata:ost:export [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | ====== Adminstration: Raw Data Files ====== | + | ====== Integration: Raw Data Files ====== |
| ===== Omnidex Standalone Tables ===== | ===== Omnidex Standalone Tables ===== | ||
| Line 23: | Line 23: | ||
| The Omnidex EXPORT statement can be used to create Omnidex Standalone Tables from another Omnidex environment. For example, users can connect to an Omnidex Environment File that accesses a relational database and then export Omnidex Standalone Tables for use in a data mart. | The Omnidex EXPORT statement can be used to create Omnidex Standalone Tables from another Omnidex environment. For example, users can connect to an Omnidex Environment File that accesses a relational database and then export Omnidex Standalone Tables for use in a data mart. | ||
| - | 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 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 [[integration:rawdata:ost:options|options]] for generating different types of raw data files. | The Omnidex EXPORT statement has several [[integration:rawdata:ost:options|options]] for generating different types of raw data files. | ||