10 Frequently Asked Questions About FingerTec Database Integration with ERP Solutions

Monday, August 22, 2016 FingerTec 5 Comments

INTRODUCTION

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.


BENEFITS 

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.

FAQs

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

5 comments:

  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.

    ReplyDelete
    Replies
    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

      Delete
    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,
      Calvin

      Delete
    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

      Delete
    4. Mr Abdul Azim,

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

      Regards,
      Calvin

      Delete

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