> 1. when we created a sequence in source, odata url gives error - Capabilites of this OracleConn are not available.
What Teiid version are you on? That seems more like an issue with the connection pool as Teiid is expecting to be able to obtain a connection to determine the database version.
> 2. "TEIID30328 Unable to evaluate (SELECT nextval FROM v2.seq LIMIT 2): TEIID30504 OracleConn: 17002 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values:  SQL: SELECT Table1_SEQ.NEXTVAL AS c_0 FROM DUAL]"
if we give 'Name in source' for the sequence table as DUAL
That also seems to indicate a problem with the connection pool. The underlying 17002 error is a connection error - https://community.oracle.com/thread/2601351
> How do we insert in to a table by a sequence generated number?
The approach you are taking should work. Just make sure there are no issues with the connection pool, then revalidate.
Thank you very much Ramesh and Steven, I am able to insert with sequence generated number now.