Excluding tables From the Attach To SQL Data dialog
To exclude tables from the Attach to SQL Data dialog, copy the sqlrepository.xml file to a new sqlexcludedtables.xml file and remove the table references that you want to include in the Attach to SQL Data dialog drop down menus. For example:
Save the sqlexcludedtables.xml file to the lib directory of your Apama installation. Table information stored in sqlexcludedtables.xml will now be excluded from the initial values of Table Name drop down menus in the Attach to SQL Data dialog.
Note: It is not necessary to create a Database Repository file in order to use sqlexcludedtables.xml. Apama will still use the sqlexcludedtables.xml file to exclude tables from the Attach to SQL Data dialog. If you have an sqlexcludedtables.xml file and you click the Save Database Repository button, the new sqlrepository.xml file will not contain any of the tables listed in your sqlexcludedtables.xml file.
To create your own sqlexcludedtables.xml file without creating a Database Repository File, supported tags and attributes are as follows:
sqlexcludedtables tag,
xmlns attribute: Top level tag that includes the namespace attribute
xmlns, which must be defined as
www.sl.com (
xmlns="www.sl.com").
db tag,
name attribute: Database name
table tag,
name attribute: Table name to exclude
Note: The file name sqlexcludedtables.xml cannot be modified.
Copyright © 2013
Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.