Can Verity search a SQL database on a different server?

104 Views Asked by At

We have Verity running successfully on our small library website.

We have our Library catalog on a different server and it runs off an SQL database.

We would like to see if we can get Verity to search the catalog while also searching our site.

I have had trouble finding any documentation that could steer us in the right direction. Does anyone know if this is even possible and how we could go about doing it?

Thanks!!

1

There are 1 best solutions below

0
On

It is possible. CFINDEX supports a query attribute. You first need to create a new collection. Then, you'll have to query the SQL server you're trying to search against, and give the name of that query variable to CFINDEX along with the name of the new collection. Once you do this, you can then use CFSEARCH to search against data in your new collection. More information about CFINDEX can be found here.