Defining a Data Destination

Define the data destination in the Destination tab.

  1. Enter the destination database connection details. The destination database must always be an IQ server.
    Note: If you have previously created an EL Project, the database destination connection details defaults to the most recently used destination connection details.
    • Connection Profile – to apply or subscribe to a previously defined database connection profile, select it from this list.

    • Interface – select the method or driver to use to connect to the destination database.

    • Host – select the destination database. The options that appear in the this list depend on the selected interface.

    • User – specify the authorized database user name.

    • Password – specify the authorized database user password. The password value is encrypted by default.

    • (Optional) Database – specify the database to be used as the destination database.

    • (Optional) Schema – specify schema or owner of the destination tables.

    • (Optional) Click Profiles to save the entered connection details as a connection profile. Enter a profile name and description before saving the profile in the repository. Once the profile is saved, you can subscribe to it.

    • The connection is automatically tested when you switch to another tab. If you want to manually test the connection, click Test Logon.

  2. View the Summary pane for information about the destination connection.
Related reference
Managing Database Connection Profiles in EL and SQL Transformation Projects