A Virdi fingerprint machine that supports Oracle database connection. You can check the product specifications on the [Virdi website].
An Oracle database server that is accessible from the network. You can use any version of Oracle database, but we recommend using the latest one, which is [Oracle Database 21c].
An Oracle database user account with sufficient privileges to create tables and insert data.
A network cable or wireless connection to connect the Virdi fingerprint machine to the Oracle database server.
Steps
Follow these steps to configure Oracle database for Virdi fingerprint machines:
On the Oracle database server, create a table to store the fingerprint data. The table should have the following columns: ID (number), FINGERPRINT (blob), NAME (varchar2), and TIMESTAMP (date). You can use any name for the table, but we will use FINGERPRINT_TABLE as an example. Here is the SQL statement to create the table:
CREATE TABLE FINGERPRINT_TABLE ( ID NUMBER PRIMARY KEY, FINGERPRINT BLOB, NAME VARCHAR2(50), TIMESTAMP DATE );
On the Virdi fingerprint machine, go to the menu and select System Settings. Then, select Database Settings and choose Oracle as the database type.
Enter the IP address or hostname of the Oracle database server, the port number (default is 1521), the service name or SID of the database, the username and password of the Oracle database user account, and the name of the table that you created in step 1. For example:
IP Address192.168.1.100
Port Number1521
Service NameORCL
User NameVIRDI_USER
PasswordVIRDI_PASS
Table NameFINGERPRINT_TABLE
Save the settings and test the connection. If the connection is successful, you will see a message saying "Connected". If not, check your network settings and database parameters and try again.
Enroll users on the Virdi fingerprint machine by following the instructions on the screen. The fingerprint data will be automatically stored on the Oracle database server along with the user name and timestamp.
To verify users, place your finger on the scanner and wait for the result. The Virdi fingerprint machine will query the Oracle database server and compare your fingerprint with the stored data. If there is a match, you will be granted access or attendance. If not, you will be denied or alerted.
Conclusion
In this article, we have shown you how to configure Oracle database for Virdi fingerprint machines. By using Oracle database as a backend storage, you can enhance the security and scalability of your biometric system. You can also use Oracle tools and features to manage and analyze your fingerprint data. For more information about Virdi fingerprint machines and Oracle database, please visit their official websites .
a104e7fe7e