Linking Up the FTDP Access Database and MSSQL 2012 Server Database for Ease of Integration

Linking Up the FTDP Access Database and MSSQL 2012 Server Database for Ease of Integration

Introduction

The FingerTec Database Processer (FTDP) helps to manage and manipulate users, fingerprints, logs and readers information in order for customers to connect FingerTec terminals to a third-party system. Transaction logs from FingerTec terminals are stored in a database server, either MySQL or MSSQL, for software developers or system integrators to utilize the database server to work with their application development. The following guide will assist you in linking up the FTDP access database and the server database for MSSQL 2012.

Before you start to link up the two databases, make sure you have the following installation files:

1. FTDP v1.7.6 or above
2. SQLEXPR_x64_ENU.exe
3. SQLManagementStudio_x64_ENU.exe

For items 2 and 3, these files only apply to Windows 7 (64-bit). You will need to look for a different installer if you are running a different version of Windows OS.

Part 1 – Installation of MSSQL Database Server

1. Run SQLEXPR_x64_ENU.exe and select the option to install a New SQL Server.



2. Follow the onscreen instructions and click Next to proceed with the installation.




3. Select all components that you want to install.



4. Follow the onscreen instructions and click Next to proceed.




5. Select Mixed Mode and key in the password for the SQL Server system administration account in order to protect your MSSQL database.




6. Close to complete the installation process.


Part 2 – Installation of MSSQL Management Studio

MSSQL Management Studio must be installed before you can access the database to browse records and link up with the FTDP Access Database.

1. Run SQLManagementStudio_x64_ENU.exe and choose to install a New SQL Server when prompted.



2. Click Next.



3. Select all components needed to be installed.



4. Follow the onscreen instructions and then, click Close to complete the installation.



Part 3 – Run the FTDP Database Initialization Tool

1. Run the Microsoft SQL server. Copy the name of the server which will be used to insert into FTDP later. Key in the password to access MSSQL. Click Connect to gain access into the database.



2. Locate FTDP Database Initialization Tool.exe from the FingerTec Data Processor folder. Paste the database server name you had copied earlier into the Server field, key in the username (default: sa) and password into the corresponding column. Click Connect.





Part 4 – Configure ODBC Data Source

1. Run C:\Windows\SysWOW64\odbcad32.exe.



2. Click Add and proceed to the next step.



3. Select SQL Server Native Client and click Finish.



4. Name the data source, for example, FTDPMSSQL, and paste the database server name into the Server field.



5. Key in the username and password.



6. Follow the onscreen instructions, then click OK to complete.




Part 5 – Setup ODBC Data Source Connection in FTDP

Run FTDP and select Database settings. Key in the name of the data source, username and password to complete the installation.


Customers who are using their payroll or HRM software that runs on MSSQL will find this guide to be beneficial as they can utilize FTDP to obtain records from FingerTec devices. By integrating the FTDP access database with the MSSQL 2012 server database, their software will be able to read the records immediately in order to process the required data.

Note: If some of the screenshots or steps viewed here are different from the ones in the current system, this is due to our continuous effort to improve our system from time to time. Please notify us at info@timeteccloud.com, we will update it as soon as possible.

    • Related Articles

    • FTDP MSSQL Installation

      The MSSQL 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 ...

    • Using FTDP with Oracle Database

      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 ...

    • Retrieve Attendance Logs from FCC into the FTDP software

      Introduction FCC is a cloud-based solution that backs up all your FingerTec terminals’ data on a cloud server. With FCC, you can centralize your data for easy viewing and managing. You can stop worrying about data lost because the original data will ...

    • Troubleshooting Ingress Server–Client by Restoring Fresh Database

      Introduction There are plenty of factors that can cause Ingress Server-Client connection problem. One of the reasons is caused by the different server and client locations in addition to it being connected through VPN or port forwarding. Hence, this ...

    • Diagnose, Compact and Repair for Microsoft Access Database (TCMS V3 and Ingress MDB)

      Introduction  FingerTec offers 2 types of software which are known as the TCMS V3 - Time Attendance system and Ingress - Time Attendance & Access Control system respectively. Currently, TCMS V3 offers only 1 option to support the Microsoft Access ...