Using FTDP with Oracle DatabaseThe 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.