Data Warehouse Sources › Overview of Importing Comma-Separated Values (CSV) Files

Overview of Importing Comma-Separated Values (CSV) Files

Using the Data Warehouse Sources dialog, you can manually define data sources or import source information from an existing database, script file, .erwin file, CA ERwin Model Manager model, or comma-separated value (CSV) file. Before you can import a CSV file as a data source, you must create the file using your preferred text editor, and it must contain the following information:

• Table descriptions
• Column descriptions

Use the following guidelines when you create a CSV file that you want to import as a data source:

• Precede table and column descriptions by only a single comment section. The format for comments is /*<Insert comment here>*/.
• Precede column descriptions with table descriptions.
• Group column descriptions by the tables in which they are contained.
• Enclose text entries in double quotes.
• Embed blank lines in the file to increase readability. Blank lines are ignored when importing the file.