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 [2015/07/14 17:34] doc |
||
---|---|---|---|
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. |