10 Frequently Asked Questions About FingerTec Database Integration with ERP Solutions

Monday, August 22, 2016 TimeTec 18 Comments


Data from FingerTec devices can be integrated with ERP solutions to cater to our customer’s requirements. However, there are some that we could not do due to Security reasons.


By integrating our devices and database with your ERP System, you can fetch and interpret the data in your own way, to cater to your own requirements. By having this FAQ, you will gain more understanding on which operations that can be done, and which not.


1. Which type of database is used to store the data in Attendance DB?

Please refer to  http://www.fingertec.com/softwareselectionguide/ for more details about database engine for all FingerTec Software.

2. If storage of data is by relational database, then what is the table structure used?

The answer to that question is confidential due to security purpose.

3. What is the database language used to query the records from the database?

We couldn’t provide the details due to security reasons.

4. Is Attendance DB compatible to support with Relational Database Management System like Oracle?

You can use the FingerTec Data Processor (FTDP) software to integrate with MSSQL & Oracle database. Check out information about FTDP here: http://www.fingertec.com/images/w_brochure/software-FTDP_e.html

5. In what format is the data stored in Attendance DB? Encrypted or compressed? If encrypted, what is the encrypting algorithm used?

We have prepared various articles to attend to your questions but we couldn’t expose the encrypting algorithm due to security reasons.

FTDP with Third Party SystemClick Here.

FTDP with MSSQL databaseClick Here.

FTDP with Oracle databaseClick Here

FTDP setup fileClick Here.

FTDP manualClick Here.

6. Does your Attendance DB use open source, web server or it has its own server technology?

This information is confidential to us.

7. Does Attendance DB provide any API's to fetch the data?

You can use our Software Development Kit (SDK) to use our FingerTec Terminal with your third party system.

FingerTec BioBridge SDK comes with DLL and ActiveX formats and currently supports Windows 9x/2000/NT platforms. It works well on many development environments including of Visual Basic 6.0, Delphi 7.0, Visual C++, Microsoft.Net and etc.

You can refer to the links below for more detail about SDK:

8. Is your Attendance DB compatible with Windows? If yes, can you share with us the ODBC driver?

Yes, all FingerTec Software are compatible with Windows platform.
If you are using 64bit operating system, you need to go to C drive > Windows > SysWOW64 > double click at odbcad32.exe to add the database at the User Data Source.
( C:\Windows\SysWOW64\odbcad32.exe )

9. What is the username and password for the Attendance DB?

You can configure directly the username and password when you install the MySQL Server.

10. What is the recommended specification of the Attendance DB Server? Does it need a Static IP?

For server specification, you can use Intel Xeon with 8GB RAM, 500 GB HDD for a better performance. Yes, the server must have its static IP Ad


  1. Regarding the Fingertec TCMS V2.

    I encounter an issue whereby when I tested to post 1st half of FEBRUARY attendance to SAGE payroll and tended to choose 1st - 14th at Fingertec, the result captured in SAGE UBS payroll was in the 2nd half (in other words, is considered by SAGE as whole-month input of attendance).
    I have to choose 1st - 15th at Fingertec as half-monthly attendance then only the posting can be done,Fingertec can only recognize "from ... to 15th" as half month posting.
    May I know,how to solve this problem ?
    Please advise, Thank you.

    1. Hello Sir,

      Good day to you.

      Regarding on your problem with TCMSv2 Software, Kindly provide us your TCMSv2 Software version.

      To check the TCMSv2 Software version, please click System settings > what's new in this release.

      If you already using TCMSv2.2.027 version, please below steps to update into latest exe version:

      • Download ft.exe at this link: https://s3.amazonaws.com/files.fingertec.com/Faiz+Tools/TCMSv2+Software+FT+Setup/ft-72+22027+110816.exe
      • Rename files as ft.exe
      • Copy new ft.exe and paste into TCMSv2 folder (replace old ft.exe)
      • Find "Vistareg" and select run as admin
      • Open TCMSv2 Software (run as admin)

      After successfully update, please check is still facing the same issue.

      Appreciate your feedback

    2. Hi Mohamad Yusri,

      Thank you for your prompt reply, after following as what you guide me to do, the "from xx to 14th FEB" posting as half monthly pay in SAGE UBS still not able to be solved.
      I've tried around and found that only "from xx to 15th" chosen in FT, the posting will go to 1st half of pay in SAGE UBS Payroll.
      Is there any setting in FT that I can set particularly for FEBRUARY use up to 14th FEB ?
      Please advise, thank you very much.

      Best regards,

    3. Hi Mr Calvin,

      Regarding your issue, kindly let me check with Mr Yusri regarding issue and please provide us your email address to ease the communication process. Once checked, we will revert back to you via your email with a proper solution

    4. Mr Abdul Azim,

      Thank you for your attention,
      in respect with your request,my email is conphyx@yahoo.com
      Thank you.


  2. Hi,
    I would like to know if the software can be installed on multiple windows devices and share using the same DB. On the same network. Is it Possible?

    1. Hello Ken,

      Good day.

      If you want to install the software to multiple PC, you can use our Ingress software which have the server and client version. You just need to install 1 server version and other PC just use client version which is connected to the server. You can install the client up to 5 PC. You just need to make sure that the server can be access from other PC so that you can connect the database from the server without any problem.

      Thanks and best regards,
      Tengku Sulaiman

  3. Thank Tengku. Jz another one. Coz my client just bought 17 unit of TA500. Does ingress record time attendance as well.

    1. Hello Ken,

      Good day.

      Regarding to your query, Ingress is a server-client based software that supports time attendance & access control features.

      Thanks and best regards,
      Puah Chiun Yuen

  4. Hi all
    Biometric device save data in specific db but i want too to save the login transaction data in postgres database
    Pls i need help

    1. Hello Sir,

      If you want to use other database type, you can refer to this article on the point number 5. You cannot change the database type from the device.

      You also can use our software to manage all the transaction from our device.

      Best regards,
      Tengku Sulaiman

  5. V3 doesn't show attendance downloaded from USB. We have AC100C and it seems to work but shows nothing on screen

  6. Hi,
    I want to know if i got AC100 in my office, i want to install new AC100C at other location but the finger print / user is still the same and i don't want to re-enroll the user, is it possible to do so?

    1. Dear Sir,

      Good day to you,

      Currently those devices are connected via TCP/IP to the same software or not? If yes, you can upload the users' details via your software. Besides that, another option you can also upload the details via USB pendrive too.

      http://www.fingertectips.com/2016/08/tcms-v3-using-usb-flash-disk-for-data.html [ refer copying User from TCMS V3 into USB Flash Disk ]

      Remark: You need to make sure both devices use the same Fingerprint Biobridge version , go to Go to Menu > System Info > Device Info

  7. Despite the fact that the term 'Software patent' doesn't have a generally acknowledged definition. One definition proposed by the Foundation for a Free Information Infrastructure is that a software patent is a "patent on any presentation of a PC acknowledged by methods for a PC program". gmail list of email addresses


  8. We as a whole realize that time is cash. So instead of attempting to be a Jack-everything being equal, start off with a sensible number of social organizations that have a more extensive client profile. SMM Panel

  9. can my employee check the hrs worked on figertec 200plus?

    1. Hi,

      You could not check the work hours on the device as it only consists of raw clocking data. To check the work hours, you will need to install the TCMSv3 software. https://www.fingertec.com/softwareupdate/TCMSV3/software-tcmsv3_download_e.html

      Please email us at fingertec@support.com if there is any other issue.


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