Often times your documents contain metadata that can be used to link them to other documents within an ICA collection. Using index fields and other mechanisms, ICA's search and analytics engine can support the implied relationships between these documents and the relational algebra that can be applied to them. The JDBC Driver contained in this zip file (JDBCDriver2ICA-1.0.1.jar) enables you to connect to and search an ICA collection using SQL just as you would normally use SQL to access a relational database. Using SQL to access these implied relationships requires some pre-configuration of your ICA collection and is described in detail in the document “Relational Content Analytics – Part 1 To test out your setup with the driver you should be able crawl multiple tables from a relational database of your choice into ICA and then query it using SQL via the JDBC Driver to ICA provided by this publication (See section 3.1 “Executing the JDBC Driver to ICA”). You could use the command line SQL client program provided by this publication, or alternatively use a conventional RDBMS SQL client program of your choice. For example, to perform the test just described I downloaded the publicly available SQuirrel SQL Client from the web, configured it with the JDBC Driver to ICA, and then was able to issue SQL commands via the SQuirrel client to an ICA collection consisting of RDMS crawled content.
(See Relational Content Analytics - Part 1 of 2)