The process of setting up an Oracle datasource is similar to the one that we describe in the preceding section for SQL Server, but Oracle requires different connection parameters. Just as you do with SQL Server, you start by clicking the Data Sources link under Data & Services on the left-hand panel of Administrator. (Note: The Oracle driver is available only with ColdFusion MX Enterprise.) Then just follow these steps: 1. In the Add New Data Source section, enter the name of the new datasource (in this example, we’re calling it CFMXBibleOracle) and choose Oracle as the driver type; then click Add. Our Oracle installation in this example has a SID (Service ID) named CFMXServer and a user named CFMXUser. Note that administering Oracle is beyond the scope of this book; the database, username, and password used in this example should be replaced with your own values. 2. In ColdFusion Administrator, enter CFMXServer in the SID Name field and CFMXUser in the Username field. Then enter the password, leave the default port of 1521, enter a brief description, and click Submit. The built-in Type 4 Oracle driver supports multiple result sets returned from Oracle packages. See Listing 10-24 in Chapter 10 for a very scalable way to accomplish this task. Verity Collections The Verity Collections page of ColdFusion Administrator (shown in Figure 43-15) enables you to manage your Verity collections. Here you can create new collections, or you can index, repair, optimize, purge, or delete an existing collection without resorting to writing code. This section assumes that you are familiar with Verity and its terminology. If you are not, please read the Verity section of Chapter 32. To create a new collection, just enter the name of the collection, the collection’s language, and the name of the directory where you want the collection to be created. The default is cf_rootveritycollections. To index a collection, click the Index Collection icon next to the name of the collection that you want to index. (This icon is the farthest left.) The indexing utility in Administrator gives you the capability to do only a path index; if you want to use file or custom indexing you must use a manually coded call to CFINDEX