Before proceeding to analyze data in a delimited file, you must first set up the connection to this file.
Prerequisite(s): You have selected the Profiling perspective in the studio.
To create a connection to a delimited file, do the following:
Expand the Metadata folder.
Right-click FileDelimited connections and then select Create File Delimited Connection to open the [New Delimited File] wizard.
Follow the steps defined in the wizard to create a connection to a delimited file.
You can then create a column analysis and drop the columns to analyze from the delimited file metadata in the DQ Repository tree view to the open analysis editor. For further information, see Creating a basic column analysis on a file.
For information on how to set up a connection to a database, see Connecting to a database.
You can create a file delimited connection either from the Profiling or the Integration perspectives. Once created, this connection is always listed in both perspectives.
You can export your connection as a context and centralize it under the Context node in the Integration perspective of your Studio. This enables you to reuse this context in the data quality analyses that use the current connection. You can also create different context parameters for the same connection and later choose to execute an analysis on one specific context. For further information, see Using context variables to connect to data sources.