How can I define a DSN for a CSV file

Products

• Cleverpath Reporter
• EUREKA:Reporter
• EUREKA:Strategy

Issue/Introduction

Overview: This document is intended to explain how to define a Data Source for a CSV (comma separated variable length) file.

 

Environment

Release:
Component: PORTAL

Resolution

Run the ODBC or Data Source Administrator.
Select "Add"
Select the ODBC driver "IQ Text".

Click the Advanced Tab and fill in the correct file extension and "use long qualifiers" if desired.

 

Next Click the define button and select your file. This dialog screen will allow you to define your columns.
Enter the table name in the "Table" field and check "Column Names in First Line" if they are, and then click guess.

 

 

Dialog after clicking guess:

You can see that "guess" reads in each column. In this case, I had my column names in the first line and they were used. If they had not been, generic names would have been assigned and you would need to then modify them one by one.

NOTE: If you have a lot of data and the first 25 columns do not accurately reflect the column widths, you should change the "rows to scan" on the advanced tab from 25 to a larger number.

Click OK. Cancel. OK. OK to complete.

You can now use the metadata manager to create a metadata file to report against if you like.