Develop > Develop Content > Extend Content > IDE > IDE Advanced Tasks > Data Source Explorer

Data Source Explorer

Following the ETL Generator process, you can optionally access the following features and processes for advanced content development.

The IDE provides a Data Tool Platform plug-in which enables you to connect to a specific data source and browse the database.The Data Source Explorer enables connection to the data sources through the SQL, Oracle and MySQL drivers. You can then browse the database tables, make queries, and view the data source information.

ClosedTo access:

  • To create a new data source connection profile, in the IDE main page, select Window > Show View > Other > Data Management > Data Source Explorer, right click Database Connections and right-click New.

ClosedCreate a new database connection in the Data Source Explorer

  1. Navigate to Window > Show View > Other > Data Management > Data Source Explorer. The Data Source EXPLORER tab is displayed.

  2. Right-click Database Connections and then right-click New.

  3. Select Oracle, SQL Server, or MySQL and click Next.

  4. Enter the Database, Host, Port number, Username and Password.

  5. Click Test Connection to check for errors with the connection to the database.

  6. Click Finish to enable the connection to the database.

You can change the driver definitions or create another driver.

ClosedModify driver definitions

Note IDE provides out-of-the-box drivers for MSSQL, Oracle, and MySQL.

  1. Navigate to Window > Preferences > Data Management > Connectivity > Driver Definitions.

  2. Select the driver you want to change, or click Add to add an additional driver.

    For details on the Data Tool Platform, see the Eclipse DTP tutorials.

ClosedData Source Explorer

Note IDE provides out-of-the-box drivers for MSSQL, Oracle, and MySQL.

ClosedData Source Connection Profile

User interface elements are described below (when relevant, unlabeled elements are shown in angle brackets):

UI Element

 Description
<Driver List>

Select SQL, Oracle, or MySQL Server.

Specify a Driver and Connection Details

  • ClosedMSSQL Server

    UI Element

    		 Description
    Database Enter the specific database name.
    Host Enter the host server.
    Port number Enter the database port.
    User name

    Enter the database user name.
    Password Enter the database password.

    New Driver Definition. Click to configure new driver definitions. For details, see the Eclipse DTP tutorials.

    Edit Driver Definition. Click to edit the current driver definitions. If you receive an error for the driver, check that the correct path is displayed in the driver files of the JAR list.

  • ClosedOracle Server

    UI Element

    		 Description
    SID Enter the Server ID, the unique name of the database.
    Host Enter the host server.
    Port number Enter the database port.
    User name

    Enter the database username.
    Password Enter the database password.

    New Driver Definition. Click to configure new driver definitions. For details, see the Eclipse DTP tutorials.

    Edit Driver Definition. Click to edit the current driver definitions. If you receive an error for the driver, check that the correct path is displayed in the driver files of the JAR list.
  • ClosedMySQL Server

    User interface elements are described below (when relevant, unlabeled elements are shown in angle brackets):

    UI Element

    		Description
    DatabaseEnter the specific database name.
    URLEnter the database URL.
    User name

    Enter the database username.

    PasswordEnter the database password.

    New Driver Definition. Click to configure new driver definitions. For details, see the Eclipse DTP tutorials.

    Edit Driver Definition. Click to edit the current driver definitions. If you receive an error for the driver, check that the correct path is displayed in the driver files of the JAR list.

Send Help Center feedback