Importing Selected Database Tables

By default, the DB Import utility imports all the schemas along with the tables within the schemas. Alternatively you can choose which tables to import.

Procedure

  1. In BE_HOME/studio/eclipse/configuration/studio.tra, set the following property: 
       be.dbconcepts.dbimport.use.sql=true
  2. Restart TIBCO BusinessEvents Studio for the change to take effect.

    Setting this property to true adds an additional field, User SQL Query, to the DB Import dialog.

Specifying Tables to Import

  1. In the User SQL Query field, enter a query that returns the schema name and the table name that you are interested in importing. You can use the WHERE clause appropriately in the query to selectively import database tables.
    Note:

    While specifying the tables to be imported, you must specify the schema name first and then the table name. When you use User SQL Query, the Owner Name field has no effect.

    For example, when using Oracle 11g database, specify the following query to import the tables whose names start with ’TABLE_’: 

    select schema_name, table_name from user_tables where table_name like 'TABLE_%’

    Below is an example of User SQL Query for IBM Z/ series database: 

    Select creator, name from sysibm.systables where creator=’username’ and name like ‘TABLE_%’

    Below is an example of User SQL Query for IBM I/ series database: 

    select TABLE_SCHEMA,TABLE_NAME from sysibm.TABLES where TABLE_SCHEMA='schemaname' and TABLE_NAME like 'TABLE_%'
Related concepts
Related tasks