The JDBC subject source has queries to search by ID, identifier, and freeform. The JDBC2 subject source, has a table or view with those columns, and constructs the queries for you. If possible you should use the JDBC2 subject source.
Ideally you would create a table or materialized view and migrate data there, and build the JDBC2 subject source.
If you cannot load data into a table or materialized view, then you should make a view of the data and build the JDBC2 subject source from that view.
If you cannot do either of those, you can make a query that will be used as a table
For instance, if this is the query:
Code Block |
---|