Exporting a table specification

You can save a list of the accelerator-shadow tables on an accelerator to an XML file and in a later step import that list for use with another accelerator. This way, tables can be added more quickly than by adding schemas and tables individually.

About this task

A typical use case is an administrator who saves a valid table specification that was created in a test environment in order to use this specification in a production environment. To make the definition work in a different environment, you can edit the XML file with a text editor, and, for example, use the find-and-replace function to replace the names of schemas and tables.
Restriction: This option is available in IBM Db2 Analytics Accelerator Studio only. It does not exist for the other administration clients.

Procedure

  1. Click File > Export.
  2. In the Export window, expand the IBM Db2 Analytics Accelerator folder to see its contents.
  3. Select Table Specifications.
  4. Click Next.
  5. In the Export Table Specification window, select an appropriate database connection profile.
    The profile gives you access to the accelerators that a Db2 subsystem is connected to. Tables are exported from these accelerators. You thus have to select the proper profile, that is, one that gives you, by way of the connected Db2 subsystem, access to the accelerators that contain the right tables. If the proper profile does not exist yet, you can click New to create it.
  6. Click Next.
  7. From the From accelerator drop-down list, select the accelerator containing the tables to be exported.
  8. In the table below, you can see the schemas and tables on the selected accelerator. From this table, you can select the tables or entire schemas whose specification you want to save to an XML file.
    Type the names of schemas or tables in the Name like filter field, either fully or partially, to display just schemas and tables bearing or starting with that name. The names of tables that have already been selected are grayed out.
  9. Click Browse.
  10. In the Export to File window, navigate to the folder in which you want to save your table specification XML file.
  11. Type a file name in the File name field.
    By default, the file is given an extension of idaa.xml. Files of this type are encoded in UTF-8.
  12. Click Save.
    You return to the Export Table Specification window. The path and the file name of your table specification XML file are displayed in the To XML file field.
  13. Click Finish.