•ODBC Database Lookup & Update with:
§ ScanDox
§ mCapture
§ iForms
§ BarCoder
For enhanced indexing purposes, ScanDox and BarCoder each have built-in ODBC data lookup and mapping capabilities that can be specified parametrically through their standard user interface.
Typically, these database operations are able to look-up and automatically supply data values from external databases to update DocuPhase document index fields. However, it is also possible for these ODBC data and mapping capabilities to update external databases with DocuPhase index field and computed data values.
These external databases typically contain some of your business-related or industry data that also applies to your ECM documents and workflow. These ODBC links are simple to define and maintain so that their integration helps provide consistency and synchronization between your Business and DocuPhase stored content and data.
iForms uses Java-Script Rules and snippets for database lookups and can be used to integrate flexibly with external databases, systems and interfaces such as the ‘Google Maps API’.
DocuPhase provides Data Exchange Services as part of its base implementation to allow for enhanced indexing using external databases. Using this built-in feature of DocuPhase, key values can be specified in DocuPhase as “Look-up” fields and upon entry into the DocuPhase, the Look-up field is used as the basis of searches in database of other databases (i.e., any ODBC compliant database or data structures) and any other row member fields located by the key field can be mapped to fill DocuPhase index values.
Like Look-ups, Updates can also be applied to the external databases with the appropriate configuration and permissions.
Data Exchange runs as a service with an XML configuration file specifying the look-ups and data mappings.
Complex SQL commands can be specified between disparate data sources giving the users of DocuPhase extreme flexibility and power.