Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# 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

3. 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_%'

Did you find this helpful?

YesNo
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO BusinessEvents® Enterprise Edition

Copyright © 2004-2024. Cloud Software Group, Inc. All Rights Reserved.