Using FTDP with Oracle Database

Thursday, October 17, 2013 FingerTec 7 Comments

The Oracle database server records all user information and transactions. The high storage capabilities of the server eliminates the need for a conventional filing system, providing a better and paperless working environment. It is possible to install FTDP to work with Oracle so that 3rd party software plug-ins can access the transaction data with ease. Read more to see the step-by-step guide to install FTDP with Oracle Database. 

Download FTDP here



Step to install FTDP software with Oracle Database


1.    Create a table space in the Oracle database for FTDP storage size 200MB.
2.    Create a user or link the existing user to this table space.
3.    Configure Oracle Local Bet Service Name Configuration on the PC.
4.    Go to Windows > Control Panel > Administrative Tools > Data Sources (ODBC)
5.    For Windows 7/Vista/8 64 bits, go to C:\Windows\SysWOW64\odbcad32.exe.
6.    Open up Data Sources (ODBC) > System DSN tab.
7.    Add a new data source, select the Oracle driver and click Finish.
8.    Input a new Data Source Name, select the TNS service name, key in User ID and click on Test Connection to make sure the connection to the Oracle database is successful. Click OK to save.
9.  Go to Start > All Programs > FingerTec > FingerTec Data Processor > Database Initialization Tool.
10. Select Oracle, key in TNS Service Name, UserName, Password and Table Space name and click Connect to connect Oracle database. Continue by clicking on Initialize, and wait until the Oracle database initialization is complete.
11. Double click on FingerTec Data Processor, key in your password and login.
12. Go to Configuration > Database Setting, select the FTDP Oracle data source, key in its User name and Password, tick Allow saving password and click on Test Connection to make sure the connection to Oracle database is successful. Click OK to save and exit.
13. Restart the FTDP application and voila! Now you have successfully connected the FTDP application to the Oracle database.

7 comments:

  1. this configuration will allow us to read data from oracle database to the fingertech database (access database), but we need to send the data downloaded into finguretech from the attendance machine and send it to oracle tables, how can we do that

    ReplyDelete
    Replies
    1. Dear Customer

      You can't directly download the clocking data from the FingerTec terminal into your third party software. You will need to use the FTDP software as a bridge by switch the database from Microsoft Access Database to the Oracle Database using ODBC setting.

      Delete
    2. Dear Customer

      You can refer below information for the sample FTDP table description:

      TRANSACTION
      LID - table unique ID
      UserID - user id in clock
      TemID - terminal id in table terminal
      DateTime - date & time of the log
      InOut - check-in (0) or check-out (1) value of the log
      Workcode - work code of the log
      VerMode - verification mode (0-fp, 1-password)
      USERS
      ID - table unique ID
      UserID - user id in clock
      UserName - user name in clock
      Password - password in clock
      Privilege - privilege value in clock (refer to privilege table)
      CardNo - user's card number in clock
      Name - user full name
      VerType - user verification type in clock
      Valid - Is user valid (enable/disable) in clock
      RegDate - the date of user downlaoded from clock
      TplCount - user template count in clock
      TZGID - user time zone group ID (refer to table TZG)
      Slct - is selected (for check/uncheck user on the screen)
      FaceCount - user face template count (0/1)
      TEMPLATE
      ID - table unique ID
      UserID - user id in clock
      Index - template index number
      Tpl - template data
      EnDate - enrollment date (reserve value)
      TplType - template type, fingerprint algo 9 or 10

      Delete
  2. thank you very much for your support
    we got the below link from support team but when we followed the link it creates ODBC connection when can connect to oracle database and read data from it and save it inside finguretech system
    http://www.fingertectips.com/2013/10/using-ftdp-with-oracle-database.html
    however our requirement is to send the data which FTDP donwnloaded from the attendance machine and send it automatically (periodically based on schedule) to oracle database, so we need the steps how to connect to oracle from FTDP how to send the data and in which tables to send the data.... etc
    Please if you have a detailed screen shots will be helpful.

    Thanks in advance.


    ReplyDelete
  3. can you help please

    ReplyDelete
  4. Dear customer,

    For your information, the step shown above is the way to transfer the data downloaded from Fingertec devices into FTDP, and straight away into Oracle database, same as your requirement. Hence please follow the steps shown above accordingly, and to which table the data is stored in Oracle, depends on how you configure the Oracle. You can refer to the above comment for the FTDP table names. and the data it stores.

    ReplyDelete
  5. Hi,

    My requirement
    Once i created a new employee in Oracle HRMS, it will be automatically visible in Fingertec. Will you pls help on the steps on Post connectivity.

    How it will be transfer to Fingertec database?
    What are the columns are required from my Oracle employee table to your db?
    Is there any scheduler which we need to be configured?
    And what is the process for disable the employee in fingertec once employee terminated in Oracle HRMS.

    ReplyDelete

Have any questions or inquiries about FingerTec? Drop your input here.