Working with Data Models › 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, a model located in a mart, 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.

More information:

CSV File Column Description Format

CSV File Table Description Format

Sample Data Warehouse CSV Source File