Omni-Gen™ Personal Edition Getting Started Guide > Working With Data > Working With a Database Source

Working With a Database Source

How to:

The following procedure describes how to import data from a database into Omni-Gen™ Personal Edition.

Procedure: How to Work With a Database Source

  1. To import data from a data source, select Database table from the Add Data Source dialog box, as shown in the following image.
  2. Click Continue.

    The Add Data Source Configuration dialog box opens, as shown in the following image.

  3. Click Select file to navigate to and locate the applicable JDBC driver for your data source.

    Based on the selection of the JDBC driver, and if it is available in its metadata, the JDBC driver and JDBC URL parameters will be populated.

  4. Provide the connectivity information to your data source and a table name to load, as shown in the following image.
  5. Click Test Connection.

    If the connection is successful, the Load Data option is available, as shown in the following image.

  6. Click Load Data.

    The data is loaded and displays in Profiling view, as shown in the following image.