Performing an Incremental Update of a Relational Data Source

This procedure applies only to relational data sources. If you are working with a text file data source, see Performing an Incremental Update of a Text File Data Source.

Note:

In this procedure, “tables” refers to tables, views, aliases, and synonyms.

  To perform an incremental update of a relational data source:

  1. In the Source Navigator, select Data Sources.

  2. Under Data Sources in the physical tree, right-click the relational data source to which you want to add tables, and select Incremental Update.

    The Incremental Update dialog box is displayed.

  3. Click the buttons to the left of Available Tables to control the content displayed in the Available Tables box:

    • Show tables

    • Show views

    • Show aliases

    • Show synonyms

    These buttons are toggled. Click a button again to stop displaying a particular group of tables. For example, if you clicked “Show views” to display database views, click “Show views” again to stop displaying them.

  4. In the Available Tables box, perform an action:

    • Select the tables that you want to include in the data source connection, and click Add selected tables to data source.

      The tables that you selected are listed in the Tables in Data Source box.

    • Click Add all tables to data source to add the tables to the Tables in Data Source box.

      All tables should appear in the Tables in Data Source box.

    Note:

    When you select many tables to add to the connection, the incremental update process can take several minutes.

  5. Optional: To remove tables that you have just added to the data source, in the Tables in Data Source box, perform an action:

    • Select the tables you want to exclude from the data source connection and click Remove selected tables from data source.

      The tables you selected for removal appear in the Available tables box.

    • Click Remove all tables from the data source to exclude all tables newly added from the data source

      The tables that you just added are removed from the data source connection.

    Note:

    You can remove only tables that you added during the current incremental update session. You cannot remove tables that are already included in the data source. Tables that are unavailable in the “Tables in Data Source” box cannot be removed.

  6. Optional: Enter a Filter to view only a portion of the available data source tables.

    For example, if database tables are prefixed for a certain business area, such as with “perf” for Performance, enter a filter to return only those tables in that area, such as:

    perf*

  7. When you are finished adding tables to the data source, click OK.