Databases and Integrations

1
Databases and Integrations

• How to use ZyIMAGE and ZyIMAGE Webserver in
  combination with other systems such as databases,
  ERP, Workflow?
• SQL, Access, MS Office, SAP, Oracle, Progress,
  Lotus Domino, Sharepoint, Exchange, etc.

2
Databases and Integrations

• Why does the customer want integration?
• Use of information which is available in other
  existing systems.
• Add functionality ZyIMAGE does not have.
• Add ZyIMAGE functionality to existing systems.
• Just asking..
• No reason at all.

3
Databases and Integrations

• 6 ways to integrate ZyIMAGE
• front-end imaging applications
• Command line options
• ODBC connection (as of ZyIMAGE 4.x)
• Web-based integration with Java and CGI
• Web-based integration with ZyNET.exe and PERL
• Web-based integration using ZyIMAGE Application
  Integrator (ZAI)

4
Front-end imaging applications

• Imaging applications that perform tasks ZySCAN is
  not capable of
• Clipping
• Form recognition
• Other/existing imaging applications
• Faxservers
• Imaging databases
• Digital copiers (hardware)

5
Front-end imaging applications

• Different types of standard import formats
• Images formats (Tiff, M-Tiff)
• ZyCLIP (newsclip, proclip)
• Watermark databases
• Kofax Ascent
• Faxservers (Faxination, Rightfax, )
• Bacon
• Xionics

6
Command line options

• Windows-based using ZyIMAGE
• Web-based using ZyIMAGE Webserver

7
Command line - Windows

• Command line options - Windows-based
• Start ZyINDEX
• Start ZyTIMER
• Start ZyFIND
• Start ZyRESULT
• Start ZyVIEW

8
Commandline -Windows

• Command line options - Windows-based
• Sample start ZyRESULT with a search query
• "c\Program Files\ZyLAB\ZyIMAGE\Bin\ZyFIND.exe"
  -iIndexname -qSearchstring
• See sample integration with MS Word in your
  Program Files folder of ZyLAB in the Add On
  directory.

9
Command line - Web

• Command line options - Web-based
• Start iexplore.exe with a search command.
• "http//www.zylab.nl/Exe/ZyNET.exe?ZyActionDZyDoc
  umentClientclientnameIndexindexnameQueryQuer
  ystringRank1UseranonymousPasswordanonymousS
  ortMethodHitdensityMaximumDocuments15FuzzyDegr
  ee1ImageQualityr85g16/r85g16/x150y150g16Displa
  ypfDefSeekPageBackZyActionSBackDescResults
  pageMaximumPages1ZyEntry1SeekPage"

10
Commandline integrations

• Where is it used?
• MS Office
• MS Access-based applications
• SAP 2, search for scanned invoices
• any Dos/Windows application that can be modified
  to create an option for a command line.

11
Database-oriented integrations

• 4 other ways to integrate ZyIMAGE
• ODBC connection (as of ZyIMAGE 4.x)
• Web-based integration with Java and CGI
• Web-based integration with ZyNET.exe and PERL
• Web-based integration using ZyIMAGE Application
  Integrator (ZAI)

12
Database-oriented integrations

• One condition Unique ID between the two systems
  you want to integrate.

ODBC DATABASE DOCID
ZyIMAGE DOCID
Unique ID
13
ODBC Connection

• ZyINDEX starts ODBC connection
• Copy fields from the database to fields in new or
  changed documents in ZyIMAGE.
• Copy fields from changed or new documents in
  ZyIMAGE to fields in a database.

14
ODBC Connection

• Where is it used?
• Mail Registration
• Add CRM data to documents
• Use existing meta information of documents in
  ZyIMAGE

15
Web-based with Java and CGI

• Web-based integration with Java and CGI
• Search in ZyIMAGE Webserver, retrieve documents
  DOCID and search with DOCID to obtain data from
  the database

16
Web-based with Java and CGI
Webserver
Database
ZyIMAGE
User's Browser
17
Web-based with Java and CGI

• Web-based integration with Java and CGI
• Search in Database using ASP(Active Server
  Pages), retrieve information with DOCID and
  search with DOCID to obtain documents from
  ZyIMAGE.

18
Web-based with Java and CGI
Webserver
Database
ZyIMAGE
User's Browser
19
Web-based with Java and CGI

• Web-based integration with Java and CGI
• Combined Search Search in Database using
  ASP(Active Server Pages) and in ZyIMAGE at the
  same time and match results on the client.
• Can be slow, depending on the number of results.

20
Web-based with Java and CGI
Webserver
Database
ZyIMAGE
User's Browser
21
Web-based with ZyNET and PERL

• Web-based integration with ZyNET.exe and PERL
  scripts on the server
• ZyNET.exe delivers results for the result page
  (result.htm) and file display page (file.htm). In
  version 4.0 a single webclient can control
  multiple template versions.
• Perl-script and (custom) templates can be used to
  extract any information that is delivered by
  ZyNET.exe.

22
Web-based with ZyNET and PERL
Webserver
ZyIMAGE
Database
User's Browser
23
Web-based integrations

• Where is it used?
• Integrations with financial and ERP systems, SAP
  R/3
• Integrations with Workflow systems, Lotus Domino,
  Documentum, Exchange 2000
• Integrations with CRM systems, PeopleSoft
• Integration with Mail Registration Systems
• Lay-out options (Perl)

24
Application Integrator (ZAI)

• Web-based integration using ZyIMAGE Application
  Integrator (ZAI)
• Create your own modules to integrate ZyIMAGE with
  any system.

25
Application Integrator (ZAI)

• Web-based integration using ZyIMAGE Application
  Integrator (ZAI)
• Direct access to the index
• Direct access to the search engine
• Direct access to ZyALERT
• and more.
• Using COM objects

26
Application Integrator (ZAI)
Webserver
Database
ZyIMAGE
ZAI
User's Browser
27
Application Integrator (ZAI)

• Where to be used?
• Any integrationwhich requires
• fast access to large amounts of data
• additional security restrictions
• complex integrations
• use of ZyALERT