Using Oracle with ITX 10 via JDBC
In this demonstration, I take you through the steps required to access an Oracle 19c database from ITX 10 via the JDBC adapter. I use the Design Studio to create a simple map which does a simple JDBC query. I execute the map with both Design Studio and Command Server. The map uses the JDBC adapter, which connects to a JDBC driver which then connects via TCP to a remote server running a Oracle instance.
In the video I document the JDBC adapter syntax, as well as giving hints on how to create Typetrees with the ODBC adapter.
JDBC rule:
=GET("JDBC","-URL jdbc:oracle:thin:@localhost:1521:orac -USER scott -PASSWORD tiger -TV -AS 0 -QTY * -LSN 0 -QUERY 'select * from Test1'")+LASTERRORMSG()