BAM Table Migration

This JDeveloper plugin will help you migrating existing tables or views from any JDBC source to BAM Active Data Cache. Using the default JDeveloper database connection window and choosing database connection + table/view will introduce now a new context menu option ”Copy to BAM ...”. This starts up the plugin to help you copy the table or view  structure and all the data to BAM target folder.

 If the target folder doesn’t exist, Oracle BAM will create it automatically. BLOB or CLOB columns are not migrated they are simply dropped out of the table migration while copying the table structure and data to Oracle BAM.

JDeveloper 10g

Main functionality

  • Copies table or view structure as data object in Oracle BAM ADC
  • Copies all the content of the table or view to Oracle BAM ADC
  • Prints out the XML data object structure in JDeveloper log window for further re-use if needed.
  • Supports both BAM 10.1.3.x and BAM 11.1.x

Limitations

  • Ignores LOB colums since Oracle BAM don’t support them.

To-Do

  • Data filtering might be needed

Full Documentation Here

JDeveloper 11g

Main functionality 

  • Copies table or view structure as data object in Oracle BAM ADC
  • Copies all the content of the table or view to Oracle BAM ADC
  • Prints out the XML data object structure in JDeveloper log window for further re-use if needed.
  • BAM connections are read from application connections (not global IDE connections)
  • Supports BAM 11.1.x

Limitations 

  • Ignores LOB colums since Oracle BAM don’t support them.

To-Do

  • Data filtering might be needed
Ċ
Harri Kaukovuo,
Jan 14, 2009, 2:30 PM
ċ
oracle.emp.kaukovuo.bam.tableplugin.2.1.0.zip
(96k)
Harri Kaukovuo,
Jan 14, 2009, 3:20 PM
ċ
oracle.emp.kaukovuo.bam.tableplugin.3.0.zip
(126k)
Harri Kaukovuo,
Nov 29, 2010, 5:27 AM
Comments