Is it possible to import sequence, triggers from Oracle db using teiid designer?

[raghu85]

I am using teiid 7.7 and Oracle as database.

i want to import some specific tables, procedures, sequence and triggers from db.

I was able to import tables and procedures but want some information on how to get sequence, triggers details from Oracle db.

Thanks.

[shawkins]

Are you looking to simply capture the metadata or do you need to utilize those constructs at runtime?  The Teiid runtime does not have general support for sequences and only uses virtual instead of triggers.  There are a couple of workarounds that can be done to use sequences - see https://docs.jboss.org/author/display/TEIID/JDBC+Translator and in Teiid 8.2+ you can use native procedure calls.

Steve