Can we analyze the data from a flat file

akonda · Post by **akonda** » Thu Jul 05, 2012 8:37 am

Hi

Can we analyze the data from a flat file source using information Analyzer (8.5) ?

ArndW · Post by **ArndW** » Thu Jul 05, 2012 8:58 am

yes. Declare it as an ODBC source and analyze away.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 05, 2012 4:18 pm

Go through the "Identify Flat File" process of metadata import, which will create metadata from your flat file into the file QETXT.INI used by Information Analyzer.

(You can create the entries in QETXT.INI manually, but it's a tedious and painstaking process. Far better to let the computer do the work for you.)

qt_ky · Post by **qt_ky** » Thu Jul 05, 2012 7:44 pm

I don't know about 8.5, but in 8.7, the "Identify Flat File" task is disabled no matter what I click on.

vmcburney · Post by **vmcburney** » Thu Jul 05, 2012 8:28 pm

First you need to define a file location as a data source. Modify .odbc.ini on your DataStage server and add a new text ODBC entry with the location of your files. Go into Information Analyzer and add this as a new data store and choose the ODBC text driver from the list of database connections. Now you should be able to identify flat files under this data source in the Import Metadata screen.

I do not know how to identify files without first putting the file location into .odbc.ini.

rjdickson · Post by **rjdickson** » Mon Jul 09, 2012 6:43 am

Agreed.

Also, there are actually many steps to configuring an ODBC DSN to connect to flat files. This link should help.