Canon 3323B001 Administrator's Guide - Page 29

Setting a database as a destination, Quick Connect, Properties, Destinations, Database, Field Selector

Page 29 highlights

eCopy Connector for Quick Connect Administrator's Guide | 25 Setting a database as a destination Setting a database as a destination enables you to configure a connector profile so that users at the device can scan and index documents and store them in the specified database. You can configure the profile to store the index information in a file, in the same database as the scanned document, or in a different database. When you set a database as a destination, you can use the Map Document Destination feature to map the name and file extension of the scanned document to STRING fields in a table in the database. This enables you, or a database administrator, to create associations between the scanned document and any index information that the user enters on the Index screen for the document, wherever that index information is stored. To set a database as a destination: 1 In the console tree, select Quick Connect > Properties > Destinations and then click New. The New destination window opens. 2 In the Name field, enter a name for the destination. 3 In the Type list, select Database. 4 Configure the data source (see page 31). When you have successfully configured the data source, the Data Field Selector window opens. 5 On the Map Document Destination tab, under Select Table Name, select a table. The Database Fields list displays only those columns that have been defined as IMAGE or STRING data types. Quick Connect stores documents in IMAGE fields and file names in STRING fields.

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42

eCopy Connector for Quick Connect Administrator’s Guide
|
25
Setting a database as a destination
Setting a database as a destination enables you to configure a connector
profile so that users at the device can scan and index documents and store
them in the specified database. You can configure the profile to store the
index information in a file, in the same database as the scanned document,
or in a different database.
When you set a database as a destination, you can use the Map Document
Destination feature to map the name and file extension of the scanned
document to STRING fields in a table in the database. This enables you,
or a database administrator, to create associations between the scanned
document and any index information that the user enters on the Index
screen for the document, wherever that index information is stored.
To set a database as a destination:
1
In the console tree, select
Quick Connect
>
Properties
>
Destinations
and then click
New
.
The
New
destination
window opens.
2
In the
Name
field, enter a name for the destination.
3
In the
Type
list, select
Database
.
4
Configure the data source (see page 31).
When you have successfully configured the data source, the
Data
Field Selector
window opens.
5
On the
Map Document Destination
tab, under
Select Table
Name
, select a table.
The
Database Fields
list displays only those columns that have
been defined as IMAGE or STRING data types. Quick Connect
stores documents in IMAGE fields and file names in STRING
fields.