Data Integration #1

 

 

Exchanging data between a database and another application needs an understanding of what type of file and how it is stored.

 

 

A file conversion filter converts the source file into a format that the target application can understand. You can see this when you

 

                                                SAVE AS

                                    Or        EXPORT AS             in the application you are using

 

 

Comma Separated Values (CSV) format and TAB separated format is generally read by applications. These are also called Data Interchange Formats (DIFs).

 

Another file used in conversion is a rich text file (rtf).