We use Agile to store all of our process and part documents (pdfs) for Sarbanes-Oxley Compliance. We have a JEE application that allows people to look up items in Agile and get the matching data from our Oracle ERP system. This app uses the Autonomy search engine. There is some java code that pulls the documents and data from Oracle and Agile and creates indexes in Autonomy.
How would you suggest going about replacing this stuff with TEXIS? I'm really unsure where to start.
This is the last piece of Autonomy we have to remove from our systems (we have converted over to TEXIS for everything else).
There are a couple of approaches you could take. There is a JDBC API for Texis that will let you execute SQL in Texis from Java. If you need more complex processing you could create a Vortex script to do the processing using XML over HTTP.
So in the JDBC case there wouldn't be any difference between using Texis and an Oracle database. This app also has taxonomy data, so for instance a particular document might show up under the two categories. The app lets users look into the categories via an HTML tree type layout. I assume I can't get that detailed with Vortex.
Perhaps the best option would be to pull all of the documents from Agile into a web site and have Texis index that site. Then maybe I could somehow pull search data into the Java app. I think I can do that by using the XML type on the index result type. Is that right?
Then I could try to match up the results with the oracle data and the taxonomy tree. What do you think of that?
With JDBC the only difference between Texis and Oracle would be any differences in the SQL support.
I'm not quite sure I understand about the categories, but it sounds as if you should be able to do it with Vortex.
You could crawl a website with the content, and use the XML method to return results to Java. You could modify the crawler to store additional data, such as the taxonomy data, or other data to make the matching easier.
