Creating and managing multiple federated objects

After you create federated objects, you can work in the Administration Explorer view of IBM® Data Studio to configure and manage individual federated objects or multiple federated objects.

About this task

To work with federated objects more efficiently, you can create or modify multiple objects.

After you create an object, you can send the script to the SQL and XQuery editor, and then cut and paste your SQL statements to create multiple objects. For example, you can create a wrapper in the Administration Explorer. You can then copy the command from that wrapper to create multiple new wrappers.

The following procedure describes how to manage multiple objects.

Procedure

  1. Create the required federated objects by completing the steps in Creating federated objects: Administration Explorer.

    For detailed examples of SQL commands, see Configuring data sources for the specific object that you are creating to access a data source.

  2. Select the Edit option to open the commands for the objects that you created.

    The commands are displayed in the SQL and XQuery editor. You can use the editor to add and edit multiple objects before you deploy your object definitions.

  3. Copy and edit the commands for the remaining objects.

    Copy commands from an object that you created previously. Copy and paste that command in the editor to create new objects.

  4. Click Run SQL to deploy the SQL scripts.
    Figure 1. Example of creating multiple federated objects in the SQL and XQuery editor.
    This figure shows that the components of a cache table are a nickname, materialized query tables, and a replication schedule. Data from the data source table is stored locallly. Users access the local data in the cache table by using applications.