Visokio website     Downloads     Video tutorials     KnowledgeBase  
Database bookmark filtering (2.7) - Visokio Forums
Database bookmark filtering (2.7)
  •     chris October 25, 2011 5:48AM
    Hi,

    You may or may not be aware that you can create a bookmark to a database in DataManager. After bookmarking you can expand the bookmark to see all of the tables inside that database, organised by catalog and schema. You can then choose which tables you want to work with by dragging them onto your DataManager workflow.

    We have now introduced the ability to filter which tables are available. This will be useful if you want to bookmark a database with a large number of tables but only show a subset of these tables.

    To use this functionality, create a new database bookmark by selecting "add > Database" in the "Bookmarks" tab or edit an existing bookmark by right-clicking and choosing "Configure". Now click on the "Filters" tab. You can create any number of filters and can filter on the Catalog, Schema or table name. For example if I only want to retrieve tables that are prefixed by "tbl" I can add the filter "Table starts with tbl".

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership