This shows you the differences between two versions of the page.
|
integration:rawdata:delimited:export [2012/10/26 15:34] 127.0.0.1 external edit |
integration:rawdata:delimited:export [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ~~NOTOC~~ | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | |||
| - | ====== Adminstration: Raw Data Files ====== | ||
| - | |||
| - | ===== Delimited Files ===== | ||
| - | |||
| - | [[integration:rawdata:delimited:home|Overview]] | | ||
| - | [[integration:rawdata:delimited:environments|Environments]] | | ||
| - | [[integration:rawdata:delimited:options|Options]] | | ||
| - | [[integration:rawdata:delimited:datatypes|Datatypes]] | | ||
| - | [[integration:rawdata:delimited:ofx|Offset Indexes]] | | ||
| - | **[[integration:rawdata:delimited:export|Exporting]]** | | ||
| - | [[integration:rawdata:delimited:limitations|Limitations]] | | ||
| - | [[integration:rawdata:delimited:example|Example]] | ||
| - | |||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== Exporting Data to Delimited Files ==== | ||
| - | |||
| - | The Omnidex EXPORT statement can be used to create delimited files from another Omnidex environment. For example, users can connect to an Omnidex Environment File that accesses a relational database and then export delimited files for use in a data mart. In fact, this approach is the basis for 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. These [[integration:rawdata:delimited:options|options]] are the same as those used in the CREATE TABLE statement. | ||
| - | |||
| - | This simple example exports all of the columns and rows from a table. The options used will create a comma-delimited file appropriate for the Microsoft Windows operating system that honors quotation marks. | ||
| - | |||
| - | <code> | ||
| - | export (select * | ||
| - | from INDIVIDUALS) | ||
| - | to individuals.csv | ||
| - | with DELIMITED COLUMN=',' RECORD='\r\n' QUOTES DELETE; | ||
| - | </code> | ||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[integration:rawdata:delimited:ofx|Prev]]** | | ||
| - | **[[integration:rawdata:delimited:limitations|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:integration:rawdata:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||