Opening SQL Databases

The licensed SQL Interface feature enables you to use SQL databases as data sources.

  To open SQL databases as data sources:

  1. Open Data Prep Editor.

  2. Select File, then Open SQL.

  3. Log on a SQL database.

  4. Click OK/Retrieve to connect to the SQL database.

  5. In the SQL Connect dialog box, enter the database user name and password.

    The data source is displayed in the top pane of Data Prep Editor.

  6. If necessary, set the file delimiters.

Related Information