Overview

Fuzzy DB plugin is used to extract the document level fields of a document from records in the database on the basis of the matched value of the HOCR content or the previously extracted value of a document level field.

User can configure either table or view to extract record from database.

Preconditions

Table mapping:  Database table should have primary/unique key. Row Id drop-down on screen should be mapped with any of the primary/unique key columns. Row Id drop-down on screen will populate only primary/unique key columns in drop-down. If there is no primary/unique key in table, then Row Id drop-down on screen will not populate any value.

View Mapping: There is no need for any primary/unique key for Views. But, it should have unique values in at-least in a column.

Row Id on screen will populate all the columns of views. User has to map Row Id with the column which is having unique values, otherwise Ephesoft will prompt a message that, selected column is not having unique values.

For such scenarios where database Views doesn’t have any unique value column, user can add Row-Number column and can use this column as unique value column and can map this column with Row Id on screen.

Note: Oracle View name should be in all Caps.

ORACLE

——————————————————–
— DDL for Table VENDOR
——————————————————–
CREATE TABLE “EPHESOFT”.”VENDOR”
( “NAME” VARCHAR2(20 BYTE),
“ID” VARCHAR2(20 BYTE),
“ADDRESS” VARCHAR2(20 BYTE),
“PHONE” VARCHAR2(20 BYTE),
“CATEGORY” VARCHAR2(20 BYTE)
)
——————————————————–
— DDL for View V_VENDOR
——————————————————–

CREATE OR REPLACE FORCE VIEW “EPHESOFT”.”V_VENDOR” (“ROW_ID”, “NAME”, “ID”, “ADDRESS”, “PHONE”, “CATEGORY”) AS
SELECT  t.”NAME”,t.”ID”,t.”ADDRESS”,t.”PHONE”,t.”CATEGORY” FROM (SELECT * FROM VENDOR) t;

 

MS-SQL
——————————————————–
— DDL for Table VENDOR
——————————————————–
CREATE TABLE [dbo].[VENDOR](
[NAME] [varchar](20) NULL,
[ID] [varchar](20) NULL,
[ADDRESS] [varchar](20) NULL,
[PHONE] [varchar](20) NULL,
[CATEGORY] [varchar](20) NULL
)
——————————————————–
— DDL for View V_VENDOR
——————————————————–
CREATE VIEW [dbo].[V_VENDOR]
AS
SELECT  t.NAME, t.ID, t.ADDRESS, t.PHONE, t.CATEGORY FROM (SELECT NAME,ID,ADDRESS,PHONE,CATEGORY FROM dbo.VENDOR) AS t

MARIADB
——————————————————–
— DDL for Table VENDOR
——————————————————–
CREATE TABLE `VENDOR` (
`NAME` VARCHAR(20) NULL DEFAULT NULL,
`ID` VARCHAR(20) NULL DEFAULT NULL,
`ADDRESS` VARCHAR(20) NULL DEFAULT NULL,
`PHONE` VARCHAR(20) NULL DEFAULT NULL,
`CATEGORY` VARCHAR(20) NULL DEFAULT NULL
)
——————————————————–
— DDL for View V_VENDOR
——————————————————–

select `t`.`NAME` AS `NAME`,`t`.`ID` AS `ID`,`t`.`ADDRESS` AS `ADDRESS`,`t`.`PHONE` AS `PHONE`,`t`.`CATEGORY` AS `CATEGORY` from `VENDOR` `t`

 

 

Was this article helpful to you?

Anil Mishra

Comments are closed.