Canon 3323B001 Administrator's Guide - Page 30

Map Fields, Data Field Selector, Database Field, Document Data BLOB, New destination, Destinations

Page 30 highlights

26 | Installing and configuring the connector 6 Under Map Fields, select the Quick Connect field that you want to map to a database field. The Data Field Selector window displays a maximum of three Quick Connect fields that you can map to database fields in the selected table. The fields allow you to store the document data (the scanned document), document name, and document extension. 7 In the Database Field column, select the target field. An administrator with knowledge of the database should know what data type to select for each Quick Connect field. For example, the Document Data (BLOB) field must be mapped to an IMAGE data type field for SQL and Access databases or to a BLOB data type field for Oracle databases. 8 Click OK. The New destination window displays the database settings. 9 Click OK to save the settings. The Destinations list displays the name and summary information for the database destination you created.

  • 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

26
|
Installing and configuring the connector
6
Under
Map Fields
, select the Quick Connect field that you want
to map to a database field.
The
Data Field Selector
window displays a maximum of three
Quick Connect fields that you can map to database fields in the
selected table. The fields allow you to store the document data (the
scanned document), document name, and document extension.
7
In the
Database Field
column, select the target field.
An administrator with knowledge of the database should know
what data type to select for each Quick Connect field. For
example, the
Document Data (BLOB)
field must be mapped to
an IMAGE data type field for SQL and Access databases or to a
BLOB data type field for Oracle databases.
8
Click
OK
.
The
New destination
window displays the database settings.
9
Click
OK
to save the settings.
The
Destinations
list displays the name and summary
information for the database destination you created.