Supported Data Stores
1Integrate supports the following types of Data Stores for Read and Commit mapping and Copy To mapping, either as standard or using FME Desktop (which requires a licence). Pay particular attention to the prerequisites attached to certain Data Store types.
Note: All formats listed below as using FME Desktop require FME Desktop Professional Edition, unless otherwise indicated.
There are two methods for writing data in 1Integrate, however these are not supported by all Data Store types:
| 
                                                         Data Store Type  | 
                                                    
                                                         Read  | 
                                                    
                                                         Write  | 
                                                    
                                                         FME Desktop Required  | 
                                                ||
|---|---|---|---|---|---|
| 
                                                         Commit  | 
                                                    
                                                         Copy To  | 
                                                ||||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                      | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                      | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                      | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                      | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                      | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                ||
| 
                                                         
                                                              | 
                                                    
                                                         
                                                              | 
                                                    
                                                         
                                                              | 
                                                    
                                                         
                                                              | 
                                                ||
| 
                                                         
                                                              | 
                                                    
                                                         
                                                              | 
                                                    
                                                         
                                                              | 
                                                    
                                                         
                                                              | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                      | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                      | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                      | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                      | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                      | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                      | 
                                                ||
| 
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                    
                                                         | 
                                                ||