Differences

This shows you the differences between two versions of the page.

Link to this comparison view

integration:rawdata:ost:export [2015/07/14 17:34]
doc
integration:rawdata:ost:export [2016/06/28 22:38]
Line 1: Line 1:
-~~NOTOC~~ 
  
-{{page>:​top_add&​nofooter&​noeditbtn}} 
- 
-====== Integration:​ Raw Data Files ====== 
- 
-===== Omnidex Standalone Tables ===== 
- 
-[[integration:​rawdata:​ost:​home|Overview]] | 
-[[integration:​rawdata:​ost:​environments|Environments]] | 
-[[integration:​rawdata:​ost:​options|Options]] | 
-[[integration:​rawdata:​ost:​datatypes|Datatypes]] | 
-[[integration:​rawdata:​ost:​ofx|Offset Indexes]] | 
-**[[integration:​rawdata:​ost:​export|Exporting]]** | 
-[[integration:​rawdata:​ost:​limitations|Limitations]] | 
-[[integration:​rawdata:​ost:​example|Example]] 
- 
- 
----- 
- 
-==== Exporting Data to Omnidex Standalone Tables ==== 
- 
-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 has several [[integration:​rawdata:​ost:​options|options]] for generating different types of raw data files.  ​ 
- 
-This simple example exports all of the columns and rows from a table to an Omnidex Standalone Table. 
- 
-<​code>​ 
-export ​       (select ​       * 
-                 ​from ​       INDIVIDUALS) 
-  to          individuals.ost 
-  with        OST INDEXBY='​INDIVIDUAL;​HOUSEHOLD'​ NULL_INDICATORS=OFF DELETE; 
-</​code>​ 
- 
-=====  ===== 
- 
-**[[integration:​rawdata:​ost:​ofx|Prev]]** | 
-**[[integration:​rawdata:​ost:​limitations|Next]]** 
- 
-====== Additional Resources ====== 
- 
-See also:  
- 
-{{page>:​integration:​rawdata:​see_also&​nofooter&​noeditbtn}} 
- 
-{{page>:​bottom_add&​nofooter&​noeditbtn}} 
 
Back to top
integration/rawdata/ost/export.txt ยท Last modified: 2016/06/28 22:38 (external edit)