I have tried jdbc/odbc in oracle,but failed.
Is there any type suitable for TimesTen ?
First, you would need to download the correct JDBC driver from Oracle TimesTen Software Downloads
and place it in the appropriate LIB directory (each Pentaho tool needs that JDBC driver installed in a different place)
Then, you need to connect the Pentaho tool to the DB. The steps for this vary by tool. For PDI, you would need to use the Generic DB option to specify the JDBC URL.
Han Zhang If your question is answered (for example, by your own answer), remember to flag the comment as "correct answer", which will flag the question as answered. If your question is not answered, please remember to add more details to your question.
Retrieving data ...